MySQL & MariaDB in Depth practice
12 exercises and 32 quizzes from the lessons of this track. Sample tests run in your browser; what you pass is kept in this browser only.
Start here: versions, a lab server and configuration
MySQL's SQL: types, modes, text and time
Schema design, indexes and server-side objects
- Quiz: InnoDB clustering: tables stored by primary key
- Quiz: Secondary, composite and covering indexes
- Quiz: JSON, generated columns and full-text search
- Match ST_Distance_Sphere in Python, then filter
- Quiz: Spatial data in MySQL: SRIDs and R-tree indexes
- Work out which partitions a date range reads
- Quiz: Partitioning in MySQL: pruning and retention
- Quiz: Stored programs, triggers and events in MySQL
InnoDB internals
The optimizer, EXPLAIN and query tuning
Binary log and replication
Group Replication and InnoDB Cluster
Backups, restores and point-in-time recovery
Security and access control
Upgrades: 8.4 LTS to 9.7 LTS and 26.x
MariaDB: how it differs and how to move
Applications, managed MySQL and Vitess
Results here are what this browser has checked: feedback for you, not proof. They stay on this device; your Learn progress can be exported to a file. · Back to the MySQL & MariaDB in Depth track