Beginner 4 chapters
1 🗄️
Rahul discovers why databases exist
What MySQL is, how to install it, and your first working database in one session
→
2 🔍
Rahul asks the right questions
WHERE, ORDER BY, LIMIT, COUNT, GROUP BY — the complete SELECT toolkit
→
3 🔗
Rahul connects his tables with JOINs
INNER JOIN, LEFT JOIN, aliases — combining two tables in one query
→
4 ✏️
Rahul writes, updates and deletes safely
INSERT, UPDATE, DELETE, ALTER TABLE — changing data without destroying it
→
Intermediate 5 chapters
5 ⚡
Rahul speeds up the app with indexes
CREATE INDEX, EXPLAIN, slow query log — finding and fixing slow queries
→
6 🔒
Rahul makes operations atomic with transactions
START TRANSACTION, COMMIT, ROLLBACK, SAVEPOINT — all-or-nothing data changes
→
7 🔁
Priya stops writing the same query twice
Stored procedures, parameters, IF/ELSE — reusable database programs
→
8 👁️
Priya creates windows into the data
Views, triggers — saving complex queries and automating audit logging
→
9 🐛
Arjun learns to read error messages
Error 1045, 1064, 1062, 1452 — what every common MySQL error means and how to fix it
→
Advanced 5 chapters
10 🚑
Priya diagnoses the production crisis
SHOW PROCESSLIST, KILL, EXPLAIN ANALYZE, InnoDB status — live performance debugging
→
11 🔬
Arjun debugs the procedure that gave wrong answers
Debug selects, log tables, NULL traps, parameter shadowing — systematic procedure debugging
→
12 🏛️
Priya scales the database and locks it down
Users and grants, read replicas, backups, my.cnf tuning — production-ready MySQL
→
13 🏎️
Priya masters advanced query optimisation
Covering indexes, query rewriting, partitioning — the craft of making queries fast
→
14 📐
Priya explains the data types developers get wrong
DECIMAL vs FLOAT, ENUM, TIMESTAMP vs DATETIME, JSON, timezone traps
→
Expert 4 chapters
15 💰
Priya cuts the database bill by 60 percent
Unused indexes, fragmentation, connection pooling, Redis caching, my.cnf tuning
→
16 🚨
Priya survives five production MySQL crises
MySQL won't start, too many connections, accidental delete, broken replication, table corruption
→
17 🏛️
Rahul teaches the thinking behind good database design
Normalisation, when to denormalise, migrations, the optimisation decision tree
→
18 🏆
The team resolves a production incident using everything they know
Locks, deadlocks, bulk migration gone wrong — a real end-to-end incident resolution
→