Skip to content
elephantoo

MySQL

Speak SQL: store, query and connect data in the world’s most popular open-source database.

A complete, job-ready path through MySQL 8. Install the server and clients, design tables with the right data types and constraints, and write everyday SQL with confidence. Then level up with joins of every kind, subqueries, CTEs, window functions and views, learn to design normalised schemas, make queries fast with indexes and EXPLAIN, keep data safe with transactions and locking, automate with stored procedures, triggers and events, and run MySQL in production: users and privileges, backups, JSON, full-text search and replication.

31 lessons ~7 h 59 min Beginner → Advanced

Your progress

0%

0 of 31 lessons complete

Start course

What you’ll learn

  • Install MySQL 8, connect with the mysql client and create databases and tables
  • Choose correct data types and enforce data quality with constraints and foreign keys
  • Insert, update, delete and query data with SELECT, WHERE, ORDER BY, LIMIT and built-in functions
  • Summarise data with aggregates, GROUP BY and HAVING, and combine tables with every kind of JOIN
  • Write subqueries, UNIONs, CTEs (including recursive ones), window functions and views
  • Design normalised schemas (1NF–3NF) and model one-to-many and many-to-many relationships
  • Speed up queries with the right indexes and read EXPLAIN plans
  • Use transactions, isolation levels and locking correctly under concurrency
  • Write stored procedures, functions, triggers and scheduled events
  • Secure, back up, restore and replicate a MySQL server; store JSON and run full-text searches

Syllabus

6 modules · 31 lessons
  1. 1Introduction to databases & MySQLRelational databases, tables, rows, columns and keys, and your very first database.
  2. 2Installing MySQL 8 & clientsInstall MySQL Server on Linux, macOS or Windows, secure it, and connect with the mysql client or a GUI.
  3. 3Databases & tables: CREATE, ALTER, DROPCreate databases with utf8mb4, define tables, change them with ALTER TABLE and remove them safely.
  4. 4Data typesIntegers, DECIMAL vs FLOAT, CHAR vs VARCHAR, TEXT, DATE/DATETIME/TIMESTAMP, ENUM, BOOLEAN and JSON.
  5. 5INSERT, UPDATE & DELETEAdd, change and remove rows safely, including multi-row inserts, upserts and safe-update habits.
  6. 6SELECT: reading dataChoose columns, compute expressions, rename with aliases, remove duplicates and limit results.
  1. 11Constraints: keys, UNIQUE, CHECK & DEFAULTPRIMARY KEY, FOREIGN KEY with ON DELETE/UPDATE, UNIQUE, NOT NULL, CHECK and DEFAULT.
  2. 12JOINs: combining tablesINNER, LEFT and RIGHT joins, table aliases, multi-table joins and finding unmatched rows.
  3. 13Self joins, CROSS JOIN & FULL OUTER emulationJoin a table to itself, build combinations with CROSS JOIN, emulate FULL OUTER JOIN and use USING.
  4. 14Subqueries & correlated subqueriesScalar, list and table subqueries, IN, EXISTS, ANY/ALL, derived tables and correlated subqueries.
  5. 15UNION, INTERSECT & EXCEPTStack result sets with UNION and UNION ALL, and find overlaps and differences in MySQL 8.0.31+.
  6. 16CTEs & recursive CTEsReadable queries with WITH, chaining CTEs, and walking hierarchies and series with WITH RECURSIVE.
  7. 17Window functionsOVER, PARTITION BY, ROW_NUMBER, RANK, running totals, LAG/LEAD and frame clauses.
  8. 18ViewsSave queries as virtual tables, updatable views, WITH CHECK OPTION and using views for security.
  9. 19Normalisation & schema design1NF, 2NF and 3NF with worked examples, modelling relationships, naming and when to denormalise.