All roadmaps
Core CS
SQL & Data Engineering
SQL mastery from basics to window functions, query optimization, and ETL pipelines.
Duration
6 weeks
Difficulty
Easy-Medium
Goal
Data Analyst/Engineer
Modules
8 • 38 topics
Full Syllabus
Every module and topic in this roadmap.
1
SQL Basics
SELECT, WHERE, ORDER BYINSERT, UPDATE, DELETEData TypesDISTINCT, LIMITAliases
2
Filtering & Aggregation
AND/OR/NOT/IN/BETWEENLIKEGROUP BY & HAVINGCOUNT/SUM/AVG/MIN/MAXNULL Handling
3
Joins & Subqueries
INNER/LEFT/RIGHT JOINFULL OUTER, CROSSSelf JoinCorrelated SubqueriesEXISTS vs IN
4
Advanced SQL
Window FunctionsLEAD/LAG/NTILECTEsRecursive CTEsCASE & Pivoting
5
Query Optimization
EXPLAINIndexingOptimization TechniquesPartitioningDenormalization
6
Database Design
ER ModelingNormalizationStar/Snowflake SchemaSCDs
7
ETL & Pipelines
ETL ConceptsData WarehousingAirflow IntroBatch vs StreamData Quality
8
Practice & Projects
Top 100 Interview QsE-commerce DashboardEmployee DB AnalysisReal-time Pipeline
Prerequisites
Basic programming
Related resources
Start learning today
Unlock the Premium Vault to get curated problems, quizzes, and mentor-crafted notes for every module.