Duration: 8 hrs

The CD Rom training tutotial for MySQL is just what you need to begin designing and developing database management systems.

Author Joshua Mostafa will help you go from a very basic understanding of databases and SQL to gaining a great level of knowledge in just 8 hours of training. He begins the tutorial by covering the basics of databases and SQL. Once you are comfortable with the basics, you can then move on to the more complex aspects of SQL, such as security and variables.

Getting Started
Welcome
What You'll Need
Database Basics
What Is A Database?
RDBMSs
Tables & Data Pt 1
Tables & Data Pt 2
SQL Basics
Finding Your Way About
Creating a Database
Creating a Table
Column Types-String Pt
Column Types-String Pt
Column Types-Numeric Pt 1
Column Types-Numeric Pt 2
Retrieving Data With Search Criteria
Changing Existing Data
Altering A Table
Keys & Indexes
Basics Syntax Recap
Operators in MySQL
Arithmetic 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 Data in MySQL
Sorting Retrieved Data
Specifying Numbers of Results
Joining Tables in MySQL
Joining Tables Pt 2
More On Joining Tables
Data Aggregation
Queries Syntax Recap
More Complex SQL
Using Default Data
Date & Time 1 Pt 1
Date & Time 1 Pt 2
Date & Time 2
ENUM column type
SET column type Pt 1
SET column type Pt 2
Using Variables
Conditional: IF()
Complex Syntax Recap
Good Practises
Using 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
optimisations
Security
Users and Privileges in MySQL
More About Users And Privileges
MySQL Database Pt 1
MySQL Database Pt 2
Encryption
Security Syntax Recap
Building A Database Application in MySQL
Planning 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