Concepts
Learn a concept by watching it work, then practice it. Each guide is one idea, shown with a runnable demo. More arrive as we build them out.
Single-table basics
- Row Filteringsoon
- Sorting and Limitingsoon
- NULL Handlingsoon
- Select and Projectionsoon
- Column and Table Aliasessoon
- Comparison and Logical Predicatessoon
- Distinct Rowssoon
Expressions and functions
- Conditional Logicsoon
- Date and Time Manipulationsoon
- String Functionssoon
- Numeric Functionssoon
- Type Castingsoon
- Pattern Matchingsoon
Aggregation
- Group By and Aggregationsoon
- Filtering Groups with HAVINGsoon
- Deduplicationsoon
- Conditional Aggregationsoon
- Grouping Sets, Rollup, and Cubesoon
Joins
- Inner Joins
- Outer Joins
- Anti-Joinssoon
- Semi-Joinssoon
- Self Joins
- Set Operationssoon
- Cross Joinsoon
- Non-Equi Joinssoon
Subqueries and CTEs
- Subqueriessoon
- Common Table Expressionssoon
- Scalar Subqueriessoon
- Correlated Subqueriessoon
- Recursive CTEssoon
- Lateral Joinssoon
Window functions
- Window Functionssoon
- Window Rankingsoon
- Running Totals and Moving Aggregatessoon
- Period-over-Period with LAG and LEADsoon
- Window Value Functionssoon
- Window Framessoon
Advanced and specialized
- Pivot and Unpivotsoon
- JSON and Semi-Structured Datasoon
- Arrays and Unnestsoon
- Upsert and Mergesoon