Logo

SQL Learning Roadmap

2025 Edition

Master SQL with Interview Master

Wherever you are in your SQL journey — we'll help you level up.

Level 1: Fundamentals

1. Basic SQL Syntax

2. Data Cleaning

  • DISTINCT to remove duplicates
  • Logical operators for combining conditions:
  • Pattern matching with LIKE and %
  • BETWEEN for range filtering
  • IN for set membership filtering
  • Case statements: CASE WHEN
  • Fill null values using COALESCE
  • Converting data types with CAST

3. Data Aggregation

Checkpoint 1

Practice with EASY questions on InterviewMaster.ai

Level 2: Table Relationships

Coming Soon!

4. Combining Tables

  • Learn relational databases
  • Basic joins:
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • FULL OUTER JOIN
    • SELF JOIN
    • CROSS JOIN for cartesian product
  • Combining datasets with:
    • UNION
    • UNION ALL
    • EXCEPT
    • INTERSECT

Checkpoint 2

Level 3: Advanced Analytics

Coming Soon!

5. Window Functions

  • Using OVER and PARTITION BY
  • Windows for precise calculations
  • ROWS BETWEEN for row ranges
  • RANGE BETWEEN for value ranges
  • Ranking functions:
    • ROW_NUMBER
    • RANK
    • DENSE_RANK
  • Navigation functions:
    • LAG
    • LEAD
    • FIRST_VALUE
    • LAST_VALUE
    • NTILE
    • PERCENT_RANK
  • Aggregation functions with windows, like SUM and AVG

6. Subqueries & CTEs

  • Simple and correlated subqueries
  • Recursive CTEs for iterations
  • Common Table Expressions (CTEs) using WITH

Checkpoint 3

  • Complete 10 HARD questions on InterviewMaster.ai
  • Build a complex SQL project: uncover insights & make recommendations

Level 4: Data Engineering

Coming Soon

7. Data Manipulation

  • INSERT data into tables
  • UPDATE existing records
  • DELETE records from table
  • Defining DEFAULT values
  • Understand difference between TRUNCATE vs. DELETE

Checkpoint 4

Build an end-to-end project that includes a data cleaning & data transformation pipeline

Interview Master: SQL Learning Roadmap © 2025