DBT(data build tool) Basic to Advanced Course

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

Topics covered in the course are:

• Models

• Materializations 

• Tests 

• Variables

• Sources

• Seeds

• Snapshots

• Hooks

• Jinja

• Macros

• Deployments

In detail, the course includes the introduction of Models and implementation, Materializations (Table, View, Incremental, and Ephemeral), Test 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 proficient knowledge of dbt Cloud, transforming the data in a data warehouse using simple SQL statements, managing the test cases, and deploying the project into the 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 needs 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
• BI Developers