SQL Bootcamp
A 30-day plan to take you from "SELECT * is scary" to "I can design and query a small production schema".
Week 1 — Read
| Day | Lessons |
|---|---|
| 1 | Intro, syntax, SELECT |
| 2 | WHERE, comparison operators, NULL |
| 3 | ORDER BY, LIKE, IN, BETWEEN |
| 4 | AND / OR / NOT, parens for precedence |
| 5 | DISTINCT, TOP / LIMIT |
| 6–7 | Practice on a sample DB — re-write 10 queries from memory |
Week 2 — Aggregate & Join
| Day | Lessons |
|---|---|
| 8–9 | COUNT, SUM, AVG, MIN/MAX |
| 10 | GROUP BY, HAVING |
| 11 | INNER JOIN |
| 12 | LEFT JOIN, anti-joins |
| 13 | RIGHT JOIN, FULL JOIN, self-join |
| 14 | UNION, CASE, COALESCE |
Week 3 — Design
| Day | Lessons |
|---|---|
| 15–16 | CREATE TABLE, types, primary keys |
| 17 | Foreign keys, constraints |
| 18 | NOT NULL, UNIQUE, CHECK, DEFAULT |
| 19 | ALTER TABLE, ADD/DROP columns |
| 20 | Indexes — what to add, what not |
| 21 | Views, sub-queries |
Week 4 — Beyond the basics
| Day | Topic |
|---|---|
| 22 | Window functions (ROW_NUMBER, RANK, SUM(…) OVER) |
| 23 | CTEs (WITH …) and recursive CTEs |
| 24 | Transactions, isolation levels |
| 25 | SQL injection & parameterised queries |
| 26 | Reading EXPLAIN plans |
| 27 | Backups & restore |
| 28–30 | Capstone — model an e-commerce schema, load fake data, build 10 reports |
Tip: Don't skip the capstone. Doing this end-to-end against a real engine teaches you ten times what reading alone does.
Example
Example
-- 30-day SQL bootcamp: -- Week 1: SELECT, WHERE, ORDER BY -- Week 2: aggregation, joins -- Week 3: design, constraints, indexes -- Week 4: capstone projectTry it Yourself »
Exercise
The bootcamp lasts…
days
Two digits.
Discussion
Loading…