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

DataCamp

Introduction to dbt

via DataCamp

Overview

DataCamp Flash Sale:
50% Off - Build Data and AI Skills!
Grab it
This course introduces dbt for data modeling, transformations, testing, and building documentation.

dbt, or the data build tool, has taken the data world by storm. This course introduces you to the concepts, terminology, and methods of using dbt to implement an example data warehouse. You'll gain an understanding of what dbt is, when it should be used, and best practices when implementing data warehousing. You will work with real datasets and perform extract, load, and transform operations as implemented in data analyst, data engineering, and analytics engineering roles.

Learners will develop the skills to define a data warehouse from scratch, model and transform data, and build tests! This course will provide you with a solid foundation to build upon in your dbt journey, regardless of the type of data warehouse you intend to implement. Gain confidence about how and when to use dbt by working through exercises using SQL and shell commands.

Syllabus

  • Welcome to dbt
    • Learn about the reasons behind dbt's existence and how it's used to create data transformation projects.
  • dbt projects and models
    • Get into the true substance of dbt by working with data models and creating SQL based models within dbt. Learn about basic SQL models, define dependencies, update, and troubleshoot various model issues.
  • More on dbt models
    • Learn how to use Jinja templates to simplify dbt models and define hierarchical dependencies with the `ref` function to ensure correct model execution.

Taught by

Mike Metzger

Reviews

4.4 rating at DataCamp based on 22 ratings

Start your review of Introduction to 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.