All roadmaps

SQL Mastery — 6 Weeks

From basics to window functions and query optimization.

Progress
0% (0/13)

SQL Basics

0/3 done
  • SELECT, WHERE, ORDER BY1h
  • Aggregates & GROUP BY1.5h
  • HAVING vs WHERE1h

Joins

0/3 done
  • INNER & OUTER joins1.5h
  • Self join1h
  • CROSS join30m

Subqueries

0/2 done
  • Scalar & correlated2h
  • EXISTS vs IN1h

Window Functions

0/2 done
  • ROW_NUMBER, RANK, DENSE_RANK2h
  • LAG / LEAD1.5h

Optimization

0/2 done
  • Indexes1.5h
  • EXPLAIN plans1.5h

Practice

0/1 done
  • LeetCode SQL 505h