Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.
Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials please do not hesitate to contact us for help.
This beginners MySQL
tutorial is ideal if you want to design and develop database management
systems. Expert author Joshua Mustafa commences with the basics of SQL and
databases and then smoothly moves on to the more advanced aspects. Simply click any linked lesson below for FREE MySQL video training movies.
Try this training now - See below for FREE tutorials
All Courses on 1 or 2 CDs
For Mac and PC
Complete CD Contents and FREE Video Tutorials
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left
We hope you enjoyed the FREE lessons above. To view the complete contents, including the chapters below, please purchase the CD. CLICK HERE TO BUY THIS CD
Querying Your Data in MySQL
How to Sort Retrieved Data
Specifying Numbers of Results
Joining Tables - Lesson 1
Joining Tables - Lesson 2
Joining Tables - Lesson 3
Data Aggregation Explained
Queries Syntax Recall
More Complex SQL
Using Default Data Overview
Date & Time - Lesson 1
Date & Time - Lesson 2
Date & Time - Lesson 3
ENUM column type
SET column type - Lesson 1
SET column type - Lesson 2
Using Variables Overview
Conditional: IF()
Complex Syntax Recall
Good Practices
Using SQL batch files - Lesson 1
Using SQL batch files - Lesson 2
Data Modeling - Lesson 1
Data Modeling - Lesson 2
Normalization in MySQL - Lesson 1
Normalization in MySQL - Lesson 2
Optimisations Overview
Security
Users and Privileges in MySQL
Further Users And Privileges
MySQL Database - Lesson 1
MySQL Database - Lesson 2
Encryption Explored
Security Syntax Recall
Constructing A Database Application in MySQL
How to Plan The Structure
Designing The Database - Lesson 1
Designing The Database - Lesson 2
The Creation of The Database - Lesson 1
The Creation of The Database - Lesson 2
Logging In And Out
Checking Videos In And Out - Lesson 1
Checking Videos In And Out - Lesson 2
How to Search For A Video
How to Add A New Title
Signing Up A New Customer
Hiring And Firing Employees - Lesson 1
Hiring And Firing Employees - Lesson 2
Listing Debtors
UK & Europe
Marrutt Software Training
Bellbrook Industrial Estate
Uckfield, East Sussex, TN22 1QL
United Kingdom
UK Tel: +44 (0) 1825 764057
UK Fax: +44 (0) 1825 768841
US & Canada
Marrutt Software Training
1133 Broadway, Suite 706
New York, NY 10010
United States
US Tel: 646-736-7932
US Fax: 646-895-7649
UK & Europe
US & Canada