← Back to Mind Maps
SQL Learning Roadmap
A structured progression for mastering SQL, from basic queries to advanced analytical functions used in Data Engineering.
Fundamentals
The building blocks of SQL
SELECT & FROMWHERE ClauseAND / OR / NOTORDER BYLIMIT / TOPAliases (AS)Data Types
Data Aggregation
Summarizing and grouping data
GROUP BYHAVINGCOUNT, SUM, AVGMIN / MAXDISTINCT
Joins & Relationships
Combining multiple tables
INNER JOINLEFT / RIGHT JOINFULL OUTER JOINCROSS JOINSelf JoinUNION & UNION ALL
Advanced Filtering & Logic
Complex data extraction
CASE WHENCOALESCENULLIFEXISTS / NOT EXISTSIN / NOT INLIKE / ILIKEString FunctionsDate Functions
Subqueries & CTEs
Modular and nested queries
Subqueries in SELECTSubqueries in WHERECorrelated SubqueriesCTEs (WITH)Recursive CTEs
Window Functions
Advanced analytics and running totals
OVER() ClausePARTITION BYROW_NUMBER()RANK() & DENSE_RANK()LEAD() & LAG()Running Totals
Performance & Optimization
Writing efficient queries
EXPLAIN / Query PlanIndexesPartitioningAvoiding Cartesian JoinsSARGable Queries