SQL Patterns for Analytics Engineering — Roadmap Step & Resources
Window functions, CTEs and other SQL techniques used constantly in modeling
- Level: beginner
- Estimated time: 1 days
- Roadmap: Analytics Engineering (dbt & Data Warehousing)
Before this step
Study resources
- Snowflake Documentation (Article) — Official documentation for the Snowflake cloud data warehouse. Background reading/viewing for: SQL Patterns for Analytics Engineering.
- freeCodeCamp (Video) — freeCodeCamp's data engineering course covers SQL modeling patterns. Relevant to: SQL Patterns for Analytics Engineering.
Part of
- SQL for Analytics Engineering — section
- Analytics Engineering (dbt & Data Warehousing) roadmap — the full learning path