Virtual Training Company s MySQL tutorial is just what you need to begin designing and developing database management systems. Joshua Mostafa will help you go from a beginner s understanding of databases and SQL to gaining mastery knowledge in only 8 hours of training. He starts the tutorial by covering the basics of databases and SQL. Once you are comfortable with the basics, move on to the more complex aspects of SQL, such as variables and security. You can start right away by simply clicking one of the movie topics below.
Getting StartedWelcomeWhat You Will NeedDatabase BasicsWhat Is A Database?RDBMSsTables and Data Pt 1Tables and Data Pt 2SQL BasicsFinding Your Way AboutCreating a DatabaseCreating a TableColumn Types-String Pt 1Column Types-String Pt 2Column Types-Numeric Pt 1Column Types-Numeric Pt 2Retrieving Data With Search CriteriaChanging Existing DataAltering A TableKeys And IndexesBasics Syntax RecapOperators in MySQLArithmetic Operators
Numeric Comparison Operators
String Comparison Operators
Logical Operators
Bitwise Operators
Regular Expressions 1
Regular Expressions 2 Pt 1
Regular Expressions 2 Pt 2
Operators Syntax Recap
Querying Your DataSorting Retrieved Data
Specifying Numbers of Results
Joining Tables Pt 1
Joining Tables Pt 2
More On Joining Tables
Data Aggregation
Queries Syntax Recap
More Complex SQLUsing Default Data
Date And Time 1 Pt 1
Date And Time 1 Pt 2
Date And Time 2
ENUM column type
SET column type Pt 1
SET column type Pt 2
Using Variables
Conditional: IF()
Complex Syntax Recap
Good PracticesUsing SQL batch files Pt 1
Using SQL batch files Pt 2
Data Modeling Pt 1
Data Modeling Pt 2
Normalization Pt 1
Normalization Pt 2
Optimizations
SecurityUsers And Privileges
More About Users And Privileges
The mysql Database Pt 1
The mysql Database Pt 2
Encryption
Security Syntax Recap
Building A Database ApplicationPlanning The Structure
Designing The Database Pt 1
Designing The Database Pt 2
Creating The Database Pt 1
Creating The Database Pt 2
Logging In And Out
Checking Videos In And Out Pt 1
Checking Videos In And Out Pt 2
Searching For A Video
Adding A New Title
Signing Up A New Customer
Hiring And Firing Employees Pt 1
Hiring And Firing Employees Pt 2
Listing Debtors
Click here to find out more about the MySQL Training CD 
