Fill fields, review the preview, then copy or open elsewhere.
Leave a field empty to keep its placeholder in the preview.
Design a SQL learning plan.
My current SQL level: {{current_level}}
My goal: {{goal}} (data analysis, backend dev, DBA, interviews)
Daily time: {{daily_time}}
Database I'll focus on: {{db}}
Return:
1. Foundations: SELECT, WHERE, ORDER BY, LIMIT — the right mental model
2. Joins (INNER, LEFT, RIGHT, FULL) — when to use each, the common trap with NULLs
3. Aggregation: GROUP BY, HAVING, the difference between WHERE and HAVING
4. Subqueries vs CTEs (WITH) — when to reach for each
5. Window functions — what unlocks them (ROW_NUMBER, RANK, LAG, LEAD, partitions, frames)
6. Indexes — the mental model for "why is this query slow"
7. Transactions, isolation levels — the conceptual basics
8. EXPLAIN / EXPLAIN ANALYZE — reading query plans
9. Realistic practice datasets and project ideas
10. The 10 SQL questions interview rounds always touch on