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!
Online Manual Demonstration pt. 1
Online Manual Demonstration pt. 2
Important Configuration Options
MySQL Client Interactive Mode pt. 1
MySQL Client Interactive Mode pt. 2
MySQL Client Interactive Mode pt. 3
Exploring Databases and Tables
Sorting Results Using ORDER BY
Avoiding Duplicates Using DISTINCT
Filter Derived Columns with HAVING
Multilevel Sums Using WITH ROLLUP
Exporting Using SQL Commands pt. 1
Exporting Using SQL Commands pt. 2
Exporting on the Shell Command Line
Prepared Statement Demonstration
Information_Schema Database pt. 1
Information_Schema Database pt. 2
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.