VTC Legacy
Home / Databases

MySQL 5 Development (Part 1)

by David Swain
129 lessons17 chapters10.8 hReleased 20117 free
Start the free chapter

As with any significant software product, MySQL is a broad subject for study and there is a lot we must know to be able to use it effectively. David Swain's MySQL 5 Development Part 1 course for VTC is the first in a training series intended to provide a solid foundation on which to build MySQL mastery. In this introductory course, we learn a number of non-destructive, read-only techniques for retrieving data from a MySQL database, as well as some useful history and practical background information about MySQL. We focus on statement and expression syntax and "why" those elements are written in a specific way. Further study exercises are provided for many of the hands-on lessons. Click the movie links below to get started now!

Course content

Introduction7 lessons
Database Basics6 lessons
Installation6 lessons
Configuration4 lessons
Client Programs9 lessons
SELECT Statement Basics6 lessons
Variables6 lessons
Calculations and Expressions15 lessons
Querying SQL Data13 lessons
Databases and Tables12 lessons
Data Type Details15 lessons
Storage Engines11 lessons
Exporting Data6 lessons
Prepared Statements4 lessons
Server Information6 lessons
Conclusion2 lessons
Credits1 lessons