Learn dbt (data build tool)

person icon Jim Macaulay

Learn dbt (data build tool)

Learn dbt (data build tool) in Cloud from basic to advanced, scenarios, test cases, deployment, document generation ,etc

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Jim Macaulay

architecture icon Development,Data Science,dbt


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

This course provides detailed lectures on dbt Cloud, applying transformations using Sql Statements, performing the test cases during development and deploying the project into Production environment.

Topics covered in the course are,

  • Models

  • Materializations 

  • Tests 

  • Variables

  • Sources

  • Seeds

  • Snapshots

  • Hooks

  • Jinja

  • Macros

  • Deployments

In detail the course includes, Introduction of Models and implementation, Materializations (Table, View, Incremental and Ephemeral) , Tests cases with various scenarios using schema.yml file as well as within Sources , creating Seeds and Sources, managing Snapshots, creating Hooks, utilizing Jinja and Macros, Deployment process, defining connection with AWS RDS PostgreSql instance, various methods to develop a model, referencing the models, deep understanding of dbt_project.yml and schema.yml files, reusability models and functions, efficient way of transformations using Sql, defining global and local variables, defining the variables during run time, interacting with PostgreSql, dynamic schema generation, dynamic, database object creation   .etc,.

By the end of the course, you will have a proficient knowledge on dbt Cloud, transforming the data in a data warehouse using simple Sql statements, managing the test cases and deploying the project into production environment.

This course is meant for Data Engineers, ETL Architects, ETL Developers, Data Analysts, Data Scientists, BI Developers, Database Developers, Data Integration Specialists, Data Architects and whoever need to enhance their skill in the field of data engineering and analytics.

Who this course is for:

  • Data Engineers, ETL Architects, Data Analysts, Data Scientists and BI Developers


What will you learn in this course:

  • dbt Cloud from basic to advanced

  • Transformations using Select statements in SQL

  • Connecting dbt Cloud to AWS RDS PostgreSql

  • Materialization - Table, View, Incremental and Ephemeral

  • SCD's using Snapshot

  • Test Cases using Test functionality

  • Jinja and Macros

  • Deployment (CD/CI) - Running in Production


What are the prerequisites for this course?

  • Proficient in SQL and basic knowledge in Git

Learn dbt (data build tool)


Check out the detailed breakdown of what’s inside the course

2 Lectures
  • play icon What will you learn? 01:00 01:00
  • play icon About the Course? 00:43 00:43
2 Lectures
4 Lectures
5 Lectures
Tests, Variables, Sources and Seeds
4 Lectures
Snapshots and Hooks
4 Lectures
Jinja and Macros
4 Lectures
1 Lectures

Instructor Details

Jim Macaulay

Jim Macaulay

Senior Software Development Architect

My self Jim, am an experienced Software and Robotics Engineer with a demonstrated history of working in the financial services industry. Passionate about teaching and blogging. Am also a YouTuber and an Instructor. Skilled in Data Engineering with various ETL, Database and Cloud Technologies, and a Robotics Engineer. Strong consulting professional with a Master’s degree focused in Software Systems (Data Analytics) from Birla Institute of Technology and Science, Pilani.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best




Hello sir, please provide few more info for beginners to crack on interview

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us