Practical MySQL
Master the world's most widely-used open-source database management language with this comprehensive and flexible course on MySQL.
Watch Introductory Video
MySQL is the most widely used open source database system in the world, making a thorough knowledge of MySQL a vital skill for every web developer.
This is a highly practical course, which concentrates on teaching you exactly what you need to know, first to get up and running and then to master MySQL in action. The course moves from simple queries to much more advanced topics - more advanced than many MySQL administrators need to do their job!
Topics include:
- MySQL in phpMyAdmin, on the command line, and in PHP scripts
- MySQL queries
- built-in MySQL functions
- users and privileges
- relational database design
- preserving data integrity with constraints
- automation with stored procedures, triggers and scheduled events
- customisation with user-defined functions (UDFs) and views
- MySQL in PHP with PDO and named parameters
- a variety of create-read-update-delete (CRUD) projects in PHP
You can see the full curriculum below.
The course is flexibly designed, with Working Files which make it suitable for learners with a range of existing knowledge or for complete beginners – if you do not need to start at the beginning of the course then it is easy to look through the code and dive straight in at any point to speed things up.
Course Curriculum
-
Preview01-01 Create database, create table (7:45)
-
Preview01-02 Insert data (6:53)
-
Preview01-03 Coding style and convention (5:53)
-
Preview01-04 Import data from SQL file (2:18)
-
Preview01-05 Select all records from a table, order and limit results (6:06)
-
Preview01-06 Select records matching search criteria (6:21)
-
Preview01-07 Revision - Create new table and insert data with SQL query (7:29)
-
Preview01-08 Numerical comparison operators (5:48)
-
Preview01-09 MySQL aggregate functions (4:30)
-
Preview01-10 MySQL ROUND function (5:22)
-
Preview01-11 MySQL string functions (8:07)
-
Preview01-12 MySQL Aliases (3:49)
-
Preview01-13 Functions within functions (4:10)
-
Preview01-14 Update existing records (1:34)
-
Preview01-15 Update part of existing records (4:07)
-
Preview01-16 Alter table structure - Add columns (3:06)
-
Preview01-17 Alter table structure - Change datatype (1:16)
-
Preview01-18 Export data to SQL file (3:55)
-
Preview01-19 Delete selected records (1:43)
-
Preview01-20 Delete (drop) columns (1:04)
-
Preview01-21 Delete all records from a table (2:45)
-
Preview01-22 Delete (drop) table and database (1:53)