SQL Roadmap
Comprehensive 3-phase roadmap for SQL covering 9 key topics with practical deliverables.
Original PLAN-101 Career Guide
SQL is the language for asking precise questions of relational data. This roadmap moves beyond memorising SELECT syntax: you will reason about join keys, missing rows, aggregation, constraints and query plans.
A trustworthy query is one whose result you can predict on a five-row test dataset before running it on a million-row table. Every phase includes a correctness exercise, and the final project requires both an explanation of your schema and evidence that its queries answer the intended question.
Hands-on Projects and Acceptance Goals
- Course Submission Database: Model students, courses, assignments and submissions with foreign keys. Produce an overdue-work report that includes students with no submissions. Tools: PostgreSQL, SQL, constraints, joins
- Campus Event Attendance Analytics: Build an attendance summary by event, correctly counting zero-attendance events and avoiding duplicate joins. Tools: SQL, GROUP BY, LEFT JOIN, CTEs
- Query Performance Notebook: Generate sample rows, compare a filtered lookup before and after an index, and save actual EXPLAIN evidence and limitations. Tools: PostgreSQL, EXPLAIN ANALYZE, indexes
Frequently Asked Questions
Should I learn SQL before an ORM? Yes. Understanding keys, joins, transactions and the actual generated queries makes any ORM easier and safer to use.
Is DISTINCT a good solution to duplicate rows? Sometimes, but first verify whether the join intentionally produces one-to-many results or whether the join keys are wrong.
Curriculum Syllabus & Milestones
Phase 1: Foundations
Focus area covering 3 core topics in Foundations.
-
SELECT Basics
Practice SELECT, WHERE, ORDER BY and LIMIT on a sample database.
- Study primary concepts for: SELECT Basics
- Actionable guide: Practice SELECT, WHERE, ORDER BY and LIMIT on a sample database.
- Build or test a practical mini-project applying SELECT Basics.
-
Joins
Practice INNER/LEFT/RIGHT joins across at least 3 related tables.
- Study primary concepts for: Joins
- Actionable guide: Practice INNER/LEFT/RIGHT joins across at least 3 related tables.
- Build or test a practical mini-project applying Joins.
-
Aggregation
Use GROUP BY, HAVING and aggregate functions to summarize data.
- Study primary concepts for: Aggregation
- Actionable guide: Use GROUP BY, HAVING and aggregate functions to summarize data.
- Build or test a practical mini-project applying Aggregation.
Phase 2: Core Skills
Focus area covering 3 core topics in Core Skills.
-
Subqueries & CTEs
Rewrite a complex query using a CTE for readability.
- Study primary concepts for: Subqueries & CTEs
- Actionable guide: Rewrite a complex query using a CTE for readability.
- Build or test a practical mini-project applying Subqueries & CTEs.
-
Window Functions
Use ROW_NUMBER, RANK and running totals with window functions.
- Study primary concepts for: Window Functions
- Actionable guide: Use ROW_NUMBER, RANK and running totals with window functions.
- Build or test a practical mini-project applying Window Functions.
-
Schema Design
Design normalized tables with primary/foreign keys and constraints.
- Study primary concepts for: Schema Design
- Actionable guide: Design normalized tables with primary/foreign keys and constraints.
- Build or test a practical mini-project applying Schema Design.
Phase 3: Applied Practice
Focus area covering 3 core topics in Applied Practice.
-
Indexing & Performance
Use EXPLAIN to find and fix a slow query with an index.
- Study primary concepts for: Indexing & Performance
- Actionable guide: Use EXPLAIN to find and fix a slow query with an index.
- Build or test a practical mini-project applying Indexing & Performance.
-
Transactions
Practice BEGIN/COMMIT/ROLLBACK to keep multi-step writes consistent.
- Study primary concepts for: Transactions
- Actionable guide: Practice BEGIN/COMMIT/ROLLBACK to keep multi-step writes consistent.
- Build or test a practical mini-project applying Transactions.
-
Real Dataset Project
Load a real dataset and answer 5 analytical questions with SQL.
- Study primary concepts for: Real Dataset Project
- Actionable guide: Load a real dataset and answer 5 analytical questions with SQL.
- Build or test a practical mini-project applying Real Dataset Project.
Related Career Paths & Cross-Skill Roadmaps
Expand your engineering versatility by exploring interconnected role roadmaps:
Track Your SQL Roadmap Progress
Sign in with Google to check off completed topics, save code notes, and monitor your placement readiness score.
Start Tracking Roadmap