MySmartCoPilot

Your country

Tools that support it use your country for local currency, number formats, units and paper size. Your choice is saved only in this browser.

Data and databases

MySQL & MariaDB in Depth

The planned outline of 16 modules. Lessons are written, run and reviewed before they are published.

Coming soon 16 modules

Coming soon. This track is being written. Below is its planned outline: a lesson appears here once its examples have been run and its technical review is signed off.

Before this track

Planned outline

  1. Module 1

    Start here: versions, a lab server and configuration

    Coming soon
  2. Module 2

    MySQL's SQL: types, modes, text and time

    Coming soon
  3. Module 3

    Schema design, indexes and server-side objects

    Coming soon
  4. Module 4

    InnoDB internals

    Coming soon
  5. Module 5

    Transactions and concurrency

    Coming soon
  6. Module 6

    The optimizer, EXPLAIN and query tuning

    Coming soon
  7. Module 7

    Online DDL and safe schema migrations

    Coming soon
  8. Module 8

    Binary log and replication

    Coming soon
  9. Module 9

    Group Replication and InnoDB Cluster

    Coming soon
  10. Module 10

    Backups, restores and point-in-time recovery

    Coming soon
  11. Module 11

    Observability and server tuning

    Coming soon
  12. Module 12

    Security and access control

    Coming soon
  13. Module 13

    Upgrades: 8.4 LTS to 9.7 LTS and 26.x

    Coming soon
  14. Module 14

    MariaDB: how it differs and how to move

    Coming soon
  15. Module 15

    Applications, managed MySQL and Vitess

    Coming soon
  16. Module 16

    Interview preparation and production review

    Coming soon

Related tools

SQL Formatter Readable, consistently indented SQL for 20 dialects — or a safe one-line copy. CSV to SQL Converter Typed CREATE TABLE and batched INSERTs, upserts or bulk-load scripts for six databases. JSON Formatter Pretty-print, minify and fix JSON with exact error locations. UUID Generator Random v4 and time-ordered v7 UUIDs, in bulk — plus a UUID inspector.

Official documentation

More in Data and databases