MySQL Curriculum

Understand databases, tables, rows, columns, data types, and primary keys.

Learn SQL vocabulary, then run your first CREATE DATABASE and USE statements.

Create tables, insert data, query it back with SELECT and WHERE.

Update existing rows, delete rows, and learn safety rules.

Narrow results with AND/OR, LIKE patterns, ORDER BY, LIMIT, and DISTINCT.

Combine data from multiple tables using INNER JOIN and LEFT JOIN.

Count, sum, and group data with COUNT, SUM, AVG, GROUP BY, and HAVING.

Enforce data integrity with UNIQUE, NOT NULL, DEFAULT, and FOREIGN KEY.

Speed up queries with indexes and learn to use EXPLAIN.

Build a complete schema from scratch with a real-world scenario.

Change table structure with ALTER TABLE, DROP, and schema inspection commands.

Nest queries inside other queries to solve complex problems step by step.

Complete your join toolkit with RIGHT JOIN, UNION, and multi-table modifications.

Add conditional logic with CASE, store reusable queries with views, and protect data with transactions.

Transform data with string and date functions, and handle duplicates with upsert patterns.

Compute rankings, running totals, and row-by-row comparisons without collapsing rows.

Write readable complex queries with WITH ... AS and explore hierarchies with recursive CTEs.

Join a table to itself and handle NULL values with COALESCE, IFNULL, and NULLIF.

Store flexible data with JSON and understand the nuances of MySQL data types.

Encapsulate logic with stored procedures, automate actions with triggers, and prevent SQL injection.

Control who can access your database and what they can do with CREATE USER, GRANT, and REVOKE.

Control concurrent transaction behavior and store international text correctly with utf8mb4.

Prevent race conditions with row-level locking and understand how deadlocks happen and how MySQL resolves them.