This course helps you advance your skills in analytics engineering and gives you the practical abilities required to build scalable and reliable dbt projects. You will begin by strengthening your understanding of reusable SQL development with Jinja and macros and learn how to organize transformation logic for large data systems. From there, you will explore incremental models, snapshots, testing strategies, documentation practices, and core observability concepts that support trustworthy analytics workflows. The course concludes with collaboration techniques and workflow automation, where you will implement Git based version control, continuous integration pipelines, and scheduled dbt jobs.
只需 199 美元(原价 399 美元)即可通过 Coursera Plus 学习更高水平的技能。立即节省
您将学到什么
Create reusable SQL logic with Jinja and macros to simplify and standardize complex transformations.
Design efficient incremental models and build snapshots that track historical changes for reliable analytics.
Implement schema and custom tests, add rich documentation, and use dbt Docs to strengthen data quality and clarity.
Work with Git based workflows, pull requests, and structured reviews to support team driven development.
您将获得的技能
要了解的详细信息
了解顶级公司的员工如何掌握热门技能

该课程共有3个模块
This module focuses on building reusable SQL logic and creating scalable transformation patterns. It introduces Jinja, macros, incremental processing, snapshots, and project refactoring. Learners implement cleaner SQL queries, optimize performance, and maintain a well structured DAG for long term project growth.
涵盖的内容
14个视频6篇阅读材料4个作业3个讨论话题
This module teaches how to ensure accuracy, reliability, and clarity in analytics workflows. It covers schema tests, custom SQL tests, metadata management, documentation practices, and essential observability concepts. Learners interpret test results, review run logs, and improve data trust across their projects.
涵盖的内容
11个视频4篇阅读材料4个作业2个讨论话题
This module explores team oriented development practices and automated analytics workflows. It covers Git based collaboration, pull requests, branching strategies, continuous integration, and scheduled dbt jobs. Learners implement automated testing, inspect CI artifacts, and set up reliable production pipeline scheduling.
涵盖的内容
13个视频5篇阅读材料5个作业3个讨论话题
人们为什么选择 Coursera 来帮助自己实现职业发展




常见问题
This course is designed for analytics engineers, data analysts, BI developers, and data professionals who already have basic experience with dbt and want to advance their skills. It is ideal for learners who understand core dbt concepts and are ready to build scalable projects, automate workflows, and work in collaborative production environments.
The course covers advanced dbt development techniques, including Jinja templating, macros, incremental models, and snapshots. It also focuses on refactoring dbt projects for scale, implementing robust testing strategies, maintaining documentation and metadata, and building observability into data pipelines. In addition, the course introduces Git-based collaboration, CI workflows, and automated scheduling for dbt runs.
Yes. You will learn Jinja fundamentals, macro patterns for reusable SQL, parameterization techniques, and how to apply macros across multiple models. Hands-on exercises guide you through creating and using macros to reduce duplication and standardize transformations across your project.
更多问题
提供助学金,
¹ 本课程的部分作业采用 AI 评分。对于这些作业,将根据 Coursera 隐私声明使用您的数据。






