MySQL Tutorial

1. MySQL Introduction

What MySQL is, InnoDB vs MyISAM storage engines, and connecting via the mysql CLI.

2. Data Types and Schema

MySQL data types, DECIMAL vs FLOAT for money, ENUM, TIMESTAMP vs DATETIME, and ALTER TABLE.

3. Indexes and Performance

Creating indexes, reading EXPLAIN output, and why composite index column order matters.

4. Transactions and Locking

START TRANSACTION, isolation levels, row-level locking, and diagnosing deadlocks.

5. Replication in Depth

Primary-replica setup, binlog-based replication, GTIDs, replication lag, and read/write splitting.

6. Backup and Recovery

mysqldump, physical backups conceptually, and point-in-time recovery using the binary log.

7. MySQL Interview Questions

Real MySQL interview questions and answers covering storage engines, isolation levels, and indexing.