SQL for Analytics Engineering — Analytics Engineering (dbt & Data War…
The SQL patterns used constantly in modeling
Steps in SQL for Analytics Engineering
- SQL Patterns for Analytics Engineering — beginner · Window functions, CTEs and other SQL techniques used constantly in modeling
- Writing Readable, Maintainable SQL — beginner · Style conventions that keep large dbt projects manageable
- Common Table Expressions and Modularity — beginner · Structuring complex queries as a sequence of readable steps
- Window Functions for Analytics — beginner · Ranking, running totals and other window function patterns
- Performance-Aware SQL Writing — beginner · Writing SQL that the warehouse's query optimizer can execute efficiently
Part of
- Analytics Engineering (dbt & Data Warehousing) roadmap — the full learning path