MySQL Course

MySQL is the world's most widely deployed open-source relational database — the "M" in the classic LAMP stack, and still the default choice behind an enormous share of web applications. This course assumes you already know SQL fundamentals (see the site's SQL Course if you need a refresher on SELECT, WHERE, and JOIN) and focuses on what's specifically MySQL: its command-line client, its particular data types, storage engines, user privileges, and day-to-day administration.

What you'll learn

You'll start by connecting to a real MySQL server and creating databases and tables the MySQL way, then move into the details that separate MySQL from generic SQL — choosing a storage engine, adding indexes and reading an EXPLAIN plan, and managing who's allowed to do what with GRANT and REVOKE. The back half covers MySQL's own function library, stored procedures, its native JSON column type, and finally backing up a real database with mysqldump.

Because these examples touch server administration — users, storage engines, backups — they aren't live in-browser editors. Each one shows a real command or query run against the mysql CLI, next to its exact output, so you can follow along on your own MySQL install.

Lessons

1. Introduction
2. Data Types
3. Creating Databases & Tables
4. Storage Engines
5. Indexes & EXPLAIN
6. User Management & Privileges
7. MySQL-Specific Functions
8. Stored Procedures
9. JSON Support
10. Backups with mysqldump