Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Intermediate dbt

via DataCamp

Overview

DataCamp Flash Sale:
50% Off - Build Data and AI Skills!
Grab it
Take your dbt skills to the next level with this hands-on course designed for data engineers and analytics professionals.

Master dbt Workflows


Take your dbt skills to the next level and learn how to implement robust, scalable data transformation workflows in a production environment. This course is designed for data engineers, analysts, and analytics engineers who want to move beyond the basics and gain hands-on experience with advanced dbt functionality.



Ensure Data Quality with Advanced Testing


Building reliable data pipelines starts with validation. You'll explore advanced testing techniques to catch data inconsistencies, create custom reusable tests to standardize validation across models, and apply tests to sources and seeds for better governance and data lineage tracking.



Leverage dbt Sources, Seeds, and Snapshots


Discover how dbt sources can improve documentation and lineage while ensuring traceability of raw data. Learn to use dbt seeds for managing small, static datasets efficiently. Then, master slowly changing dimensions (SCD2) with dbt snapshots, allowing you to track historical changes in your data warehouse with minimal effort.



Automate and Optimize with dbt Build


Efficiency is key in production environments. You’ll learn how to streamline workflows with dbt build, automating model execution, tests, and snapshots to ensure reliable transformations. By optimizing your pipeline, you'll enhance performance, maintainability, and scalability of your dbt projects.



Apply Your Skills in Real-World Scenarios


Through interactive exercises and hands-on practice, you’ll reinforce your knowledge and gain the confidence to apply dbt in real-world settings. By the end of the course, you'll be equipped to design, test, and automate production-ready dbt workflows, ensuring high-quality and well-documented transformations at scale.


Syllabus

  • Testing & Documentation
    • Learn how to ensure data quality with advanced testing techniques in dbt. Explore built-in, singular, and reusable tests to validate models, sources, and seeds. Understand how to define custom tests using Jinja, troubleshoot failures, and optimize your validation workflow to catch inconsistencies before they impact downstream analysis.
  • Implementing dbt in production
    • Take your dbt skills to the next level by implementing scalable, production-ready workflows. Learn how to use dbt sources and seeds to improve data lineage, implement snapshots for tracking historical changes, and automate your transformations with dbt build. By the end, you’ll be equipped to manage large-scale data pipelines with confidence.

Taught by

Mike Metzger

Reviews

Start your review of Intermediate dbt

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.