HowToCodePage

MySQL

The most widely deployed open-source database.

💡
This course has 3 lessons. Start with the first one and use the next / previous links at the bottom of each lesson — the sidebar keeps the whole course in order.

Lessons

  1. Installation, databases, users and enginesGet a server running, create a database and a least-privilege account, and know which storage engine is actually holding your rows.
  2. Indexes and reading EXPLAINComposite column order, covering indexes, and how to turn a query plan into a concrete fix instead of a guess.
  3. Replication, backup and operational pitfallsBinary logs, replicas, restorable dumps, and the failure modes that only appear after a few months in production.

More in Databases

SQL PostgreSQL MongoDB Redis SQLite

Last refreshed 2026-09-17.