DBT For Data Engineers
In this hands-on training course we will go from beginner to implementing advanced data pipelines with clean, maintainable models using DBT.
Course Overview
DBT is the popular open source tool that is used to implement _transformations_ as part of the Modern Data Stack.
In this course we will learn how to build data pipelines that implement the best practices typically associated with Software Engineers.
Sign Up To Access The Full Course Content
Timeflow Academy is a free online, hands-on platform for learning about Cloud Data Engineering using modern, open source tools and platforms. Please register with us for full access to our content.
Introduction To DBT
In this lesson we will introduce DBT and the value it brings to data teams.
Benefits Of DBT
In this lesson we will explain the benefits of DBT and the problems with the existing approach;
Using The DBT Command Line Interface
In this lesson we will use the DBT Command Line Interface to create and configure our first DBT project.
Creating A DBT Project
In this lesson we will use the DBT Command Line Interface to create and configure our first DBT project.
Configuring DBT Profiles
In this lesson we will explain the DBT profile system and best practices for managing profiles for maintainable code.
Executing Your First Transformations
In this lesson we will create and run our first transformations using DBT models that build both tables and views.
Materialisation Options and Considerations
Describing the options and considerations when materialising models in DBT.
Materialising As Views and Tables
In this lesson we will use DBT to materialise to tables and views, and the associated incremental and ephemeral options.
Seed Data
In this lesson we will use DBTs seed data feature to reliably populate our database with static data for use as part of DBT transformations.
Testing With DBT
In this lesson we will use the testing features of DBT to validate data transformations and pipelines.
Incremental Views
In this lesson we will learn about DBTs incremental updates and incremental views.
Ethemeral Views
In this lesson we will learn about DBTs ethemeral view feature to improve your pipeline readability.
Sources and Exposures
In this lesson we will learn about DBTs source and exposure features to capture better metadata regarding your pipelines.
Documenting Your Models
In this lesson we will learn about DBTs features for automatically generating documentation.
DBT and DevOps
In this lesson we will explain how DBT helps Data Engineers work like software engineers.
