Skip to main content
HomeData Engineering

Introduction to dbt

4.3+
21 reviews
Advanced

This course introduces dbt for data modeling, transformations, testing, and building documentation.

Start Course for Free
4 hours16 videos58 exercises9,959 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies


Course Description

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 and documentation! 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.
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.

In the following Tracks

Professional Data Engineer in Python

Go To Track
  1. 1

    Welcome to dbt

    Free

    Learn about the reasons behind dbt's existence and how it's used to create data transformation projects.

    Play Chapter Now
    What is dbt?
    50 xp
    Users of dbt
    100 xp
    Version of dbt
    100 xp
    dbt subcommands
    50 xp
    Creating a dbt project
    50 xp
    Initializing a dbt project
    100 xp
    Creating a project profile
    100 xp
    Working with a first project
    50 xp
    dbt project workflow
    100 xp
    Running a project
    100 xp
    Modifying a model
    100 xp
  2. 4

    Implementing dbt in production

    Utilize what you've learned about dbt with some added details to implement dbt in a production environment. We'll cover dbt seeds and snapshots, along with how to automate builds. Finally review what you've learned throughout the course and implement a dbt pipeline.

    Play Chapter Now
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

In the following Tracks

Professional Data Engineer in Python

Go To Track

collaborators

Collaborator's avatar
George Boorman
Collaborator's avatar
Arne Warnke

prerequisites

Data Warehousing ConceptsIntroduction to ShellJoining Data in SQL
Mike Metzger HeadshotMike Metzger

Data Engineer Consultant @ Flexible Creations

Mike is a consultant focusing on data engineering and analysis using SQL, Python, and Apache Spark among other technologies. He has a 20+ year history of working with various technologies in the data, networking, and security space.
See More

Don’t just take our word for it

*4.3
from 21 reviews
67%
19%
0%
14%
0%
  • Jono P.
    8 days

    Covers foundational topics well, and excellent practice exercises in the terminal.

  • Zweitze V.
    20 days

    Excellent. Although dbt has its own courses, this Datacamp course taught me a few new tricks!

  • Matthew M.
    about 1 month

    Great introduction to dbt

  • Julia R.
    3 months

    Great walk-through first steps in dbt with practical examples

  • Amit K.
    3 months

    To the point and good to start with

"Covers foundational topics well, and excellent practice exercises in the terminal."

Jono P.

"Excellent. Although dbt has its own courses, this Datacamp course taught me a few new tricks!"

Zweitze V.

"Great introduction to dbt"

Matthew M.

Join over 15 million learners and start Introduction to dbt today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.