DataCamp
FreeIntroduction to dbt
4.7(2,522)31k studentsINTERMEDIATEEnglish
Korshub's take
Course Overview
dbt (data build tool) modernizes the transformation layer in data warehousing by bringing software engineering practices to SQL. This intermediate course covers data modeling, ELT workflows, transformation logic, testing, and CLI execution across real-world data warehouse scenarios.
Who Should Enroll?
Targeted at intermediate data analysts, analytics engineers, and data engineers wanting to build modular SQL transformations and automated data tests.
Key Takeaways
- ELT & Data Modeling: Design data warehouse structures and implement in-warehouse SQL transformations.
- dbt Workflows: Create, manage, and execute dbt models using SQL and shell commands.
- Data Testing & Quality: Define automated testing protocols to validate schema integrity and data quality across transformations.
About this course
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.
Price
Advertisement
