Data Engineering
dbt in Production: Transform Data Like a Pro Team
Models, tests, documentation and incremental loads: the dbt workflow that turns a warehouse into something a team can trust.
Models, tests, documentation and incremental loads: the dbt workflow that turns a warehouse into something a team can trust.
Part of Data Engineering: The Complete, Job-Ready Program
Taught by Sharuk Shaik
Enterprise data engineering trainer with 10+ years of experience and 3000+ students trained
- Lessons
- 16
- Length
- 5h 7m
- Live classes
- 2
- Level
- Intermediate
₹7,999
New here? Create an account
- 16 recorded lessons, yours for the life of the enrollment
- 2 live classes with your instructor
- 2 downloadable resources
- Verifiable certificate on completion
What you will be able to do
- Structure a dbt project that stays organised past the first ten models
- Write tests that catch real data problems before a stakeholder does
- Choose the right materialization and build performant incremental models
- Run dbt as part of a real, scheduled production workflow
About this course
dbt did not invent SQL transformation. It made it possible to test it, document it, and review it the way software has been reviewed for years — and that discipline is the actual point of this course.
We cover models, sources and tests, then macros and incremental models for performance, and finish with the production workflow: environments, scheduled runs, and what a good dbt pull request actually looks like. The final project models a subscription business's revenue end to end.
Who it is for
- Data analysts moving into analytics engineering
- Data engineers adding a disciplined transformation layer to existing pipelines
- Teams currently transforming data with untested, undocumented stored procedures
What you need
- Working SQL knowledge (the SQL for Data Engineering course, or equivalent)
- Access to a warehouse (a free-tier Snowflake or BigQuery account works)
Curriculum
4 modules · 16 lessons · 5h 7m
Lessons marked Preview are free to watch.
- What dbt actually does, and does not do Preview 14m
- Setting up a project and connecting a warehouse Preview 19m
- Models: your first SELECT-as-a-table 22m
- Project structure that scales past ten models 18m
- Declaring sources and freshness checks 17m
- Writing tests that catch real problems 24m
- Generating documentation your team will read 16m
- A model naming convention that survives a team of five 10m
- Jinja and macros: don't repeat yourself 21m
- Incremental models: only processing new data 26m
- Choosing a materialization 19m
- Snapshots for slowly changing dimensions 20m
- Environments: dev, staging and production 17m
- Orchestrating dbt runs on a schedule 18m
- Reviewing a dbt pull request 16m
- Real-world project: modelling a subscription business's revenue 30m
Your instructor
Sharuk Shaik
Enterprise data engineering trainer with 10+ years of experience and 3000+ students trained
Sharukh Sir is a seasoned data engineering professional with over a decade of experience building and managing enterprise data platforms across multiple industries including banking, insurance, retail, and healthcare.
Having worked with organizations ranging from fast-growing startups to Fortune 500 companies, he brings a unique perspective that blends deep technical knowledge with practical business understanding.
His teaching philosophy is simple: theory without practice is incomplete. Every concept is taught with real-world context, every module ends with hands-on exercises, and every student graduates with production-grade project experience.
His mission is to make every student industry-ready from day one — not just in tools and technology, but in mindset, problem-solving, and professional communication.
Student reviews
No reviews yet — be the first once you are enrolled.
Common questions
Anything else, just ask.
dbt in Production: Transform Data Like a Pro Team
16 lessons, 5h 7m of instruction , plus 2 live sessions.
₹7,999
Sign in to enroll