PLAN-101 Career OS
All Levels Estimated: 12 Weeks 9 Topics

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.

  1. 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.
  2. 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.
  3. 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.

  1. 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.
  2. 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.
  3. 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.

  1. 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.
  2. 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.
  3. 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:

3-Year CSE Roadmap → Frontend Developer → Backend Developer → Full-Stack Developer →

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