8 lessons
SQL, the way you wished you were taught
Eight lessons. We build a small Swiggy-style database from zero and end with the kind of queries seniors write at 2 AM.
- 01
Why SQL still rules in 2026
A short, opinionated case for the language that refuses to die.
9 min read - 02
SELECT, the polite way to ask questions
Your first conversation with a database.
10 min read - 03
WHERE, ORDER BY, LIMIT, narrowing the noise
How to find one row in ten lakh without losing your mind.
10 min read - 04
JOINs without the panic
Tables are LEGO. JOINs are how you click them together.
12 min read - 05
GROUP BY and aggregates, counting like a manager
How much did each restaurant earn today? In one query.
11 min read - 06
Indexes, the IRCTC Tatkal moment
Why one well-placed index turns a 4-second query into 4ms.
12 min read - 07
Transactions & ACID, the UPI rule
A debit without a credit gets people fired. Here is how to never let it happen.
11 min read - 08
Window functions, the elegant stuff
Running totals, top-3-per-category, the queries that make seniors smile.
12 min read