Skip to main content
Mykyta Pushenko avatar

Mykyta Pushenko has completed

Introduction to dbt

Start course For Free
4 hr
2,250 XP
Statement of Accomplishment Badge

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! 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.
  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
    Foundations of dbt
    50 xp
    Running the dbt command
    100 xp
    Introducing dbt
    50 xp
    Version of dbt
    100 xp
    Getting help
    100 xp
    Users of dbt
    100 xp
    Creating a dbt project
    50 xp
    Initializing a dbt project
    100 xp
    Creating a project profile
    100 xp
  2. 2

    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.

    Play Chapter Now
    Working with a first project
    50 xp
    dbt project workflow
    100 xp
    Running a project
    100 xp
    What is a dbt model?
    50 xp
    Features of a data model
    100 xp
    Creating a dbt model
    100 xp
    Updating dbt models
    50 xp
    Config files
    100 xp
    Updating a dbt model
    100 xp
  3. 3

    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.

    Play Chapter Now
    Creating and generating dbt documentation
    50 xp
    dbt docs Command Options
    50 xp
    dbt documentation flow
    100 xp
    Creating dbt documentation
    100 xp
    Jinja templates
    50 xp
    What can Jinja do?
    50 xp
    Process a Jinja template
    100 xp
    Hierarchical models in dbt
    50 xp
    Hierarchical model creation
    100 xp
    Updating model hierarchies
    100 xp
For Business

Training 2 or more people?

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

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

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

Create Your Free Account

or

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