Domain

Advanced SQL

Composable techniques for recursion, analytics, per-row derivation, multidimensional aggregation, and temporal questions.

1. Common Table Expressions
2. Recursive Queries
3. Window Functions
4. Advanced Window Patterns
5. Lateral Joins And Apply
6. Grouping Sets Rollup And Cube
7. Pivot Unpivot And Conditional Aggregation
8. Gaps Islands And Relational Division
9. Temporal And Versioned Queries