Programming Study日本語

Disclosure: We earn a commission from Udemy when you buy a course through links on this page.

dbt + Snowflake: Complete Analytics Engineering Course

dbt + Snowflake: Complete Analytics Engineering Course

Udemy · English

About this course

Language
English
Category
Provider
Udemy
Data updated

You will build production analytics pipelines using dbt and Snowflake, from your first model to a fully tested, incrementally loaded, CI/CD-deployed stack. Every concept comes with real SQL and YAML you can run immediately — not slides, not pseudocode. This course follows Priya, a senior analyst who inherited 47 undocumented stored procedures and a Monday-morning Slack message that never stops: "the revenue dashboard is wrong again." You'll watch her (and Lumen Retail, the running case study threaded through all 22 modules) replace that fragile pipeline with a version-controlled, tested, documented dbt project — and then build your own. You'll start from zero: installing dbt-snowflake, configuring `profiles.yml` with key-pair authentication, and running your first model. From there, the course goes deep on everything a working analytics engineer actually needs — the layered model architecture (staging, intermediate, marts) built around `ref()`, a full testing pyramid (generic tests, singular tests, source freshness), incremental models that cut compute cost by 80%+, snapshots for slowly changing dimensions, Jinja macros and packages to eliminate repeated SQL, the dbt Semantic Layer, model contracts and versioning for safe breaking changes, CI/CD with GitHub Actions and Slim Builds, and Snowflake-specific patterns like dynamic tables, zero-copy clones, warehouse routing, and clustering keys for cost control. The course closes with a guided capstone — build the same Lumen Retail pipeline yourself, project structure through deployment — plus a portfolio-grade open challenge where you design (not just code) a complete architecture for a SaaS or Finance/CRM brief, graded on a real architect's rubric. Finish with a 50-point production checklist and exam-readiness coverage for the dbt Analytics Engineer certification. By the end, you won't just know dbt syntax — you'll have the judgment to lead your team's dbt adoption, with a working reference project to prove it.

Courses in the same category