Data Science SQL Roadmap
Data scientists turn raw database rows into business predictions. Master descriptive statistics, cohorts grouping, non-equi bucket segmentation, rank partitions, and CTE metrics compilation.
SQL SELECT & Projection
Master the entry point of data extraction: querying columns and renaming with AS.
WHERE Filters & Conditional Logic
Learn to surgically extract specific rows of data using conditional filtering.
ORDER BY & LIMIT Sorting
Sort your query results and cap outputs to show top rankings easily.
SQL Aggregations & COUNT
Compile high-level math summaries like sums and averages over row matrices.
GROUP BY & HAVING Aggregations
Segment your summaries across specific categories and filter aggregated stats.
INNER JOIN Table Relations
Unlock the power of relational databases: link multiple tables together.
LEFT OUTER Joins
Preserve left-hand records and locate missing or orphaned data relationships.
Subqueries & Nested Compiles
Write queries inside query blocks to form complex in-memory compilers.
Common Table Expressions (CTEs)
Write clean, highly readable, multi-stage pipelines using the WITH clause.
Advanced Window Functions
Compute moving averages, cumulative sums, and department rankings.
Inner & Outer Joins Review
Master the fundamental differences between strict intersection and outer preservation.
Set Operators (UNION vs UNION ALL)
Stack query results vertically and evaluate deduplication performance overhead.
Non-Equi Joins & Theta Joins
Link tables across unequal thresholds, date ranges, or salary grade brackets.