MySQL Training - FREE Tutorials

We hope you enjoyed the free lessons above. To view the complete contents including the chapters below, please purchase the CD. Alternatively you can sign up to the Online University and gain full, instant access to this, and all 450+ tutorials for only $30/£15 per month by clicking here
CLICK HERE TO BUY THIS TUTORIAL ON CD

Operators in MySQL
Arithmetic Operators
Numeric Comparison Operators
String Comparison Operators
Logical Operators
Bitwise Operators
Regular Expressions - Tuition 1
Regular Expressions - Tuition 2
Operators Syntax Recap

Querying Your Data
Sorting Retrieved Data
Specifying Numbers of Results
Joining Tables
More On Joining Tables
Data Aggregation
Queries Syntax Recap

More Complex SQL
Using Default Data
Date And Time 1
Date And Time 2
ENUM column type
SET column type
Using Variables
Conditional: IF()
Complex Syntax Recap

Good Practises
Using SQL batch files
Data Modeling
Normalization
Optimizations

Security
Users And Privileges
More About Users And Privileges
The 'mysql' Database
Encryption
Security Syntax Recap

Building A Database Application
Planning The Structure
Designing The Database
Creating The Database
Logging In And Out
Checking Videos In And Out
Searching For A Video
Adding A New Title
Signing Up A New Customer
Hiring And Firing Employees
Listing Debtors

CLICK HERE TO BUY THIS TUTORIAL ON CD