This course takes you from “what is MySQL?” to running it with confidence in production. All along you build the database behind Orbit, the small notes app from the other courses on this blog: its users, notes and tags, the queries its API runs, the accounts it connects with and the backups that keep it safe.
Every lesson has SQL you can copy, results that come from the same data you created in earlier lessons, three short exercises to check what you learned and answers to the questions people ask most.
Before you start: you need a terminal. If commands like cd, ls and sudo are new to you, take the first lessons of the Linux Tutorial first. Lesson 2 shows how to install MySQL on Linux, macOS and Windows, or run it with Docker.
The examples target the two current long-term support lines, MySQL 8.4 LTS and MySQL 9.7 LTS. Almost everything also works on MySQL 8.0, and lessons point out when a feature needs a newer version. The last lesson collects what changed in 8.4 and 9.7 in one place. Keep the MySQL Cheatsheet open in another tab: it has over 200 ready-to-paste commands grouped by task.
If you already know PostgreSQL, the Postgres Tutorial builds the same Orbit database, so you can compare how the two servers solve the same problems.