Common Table Expressions and Modularity — Roadmap Step & Resources
Structuring complex queries as a sequence of readable steps
- Level: beginner
- Estimated time: 1 days
- Roadmap: Analytics Engineering (dbt & Data Warehousing)
Before this step
Study resources
- dbt Documentation (Article) — Official documentation for dbt, covering modeling, testing, documentation and the semantic layer. Background reading/viewing for: Common Table Expressions and Modularity.
- freeCodeCamp (Video) — freeCodeCamp's data engineering course covers SQL modeling patterns. Relevant to: Common Table Expressions and Modularity.
Part of
- SQL for Analytics Engineering — section
- Analytics Engineering (dbt & Data Warehousing) roadmap — the full learning path