data build tool in Cloud(dbt Cloud)

data build tool in Cloud(dbt Cloud)

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

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

Url: View Details

What you will learn

• dbt Cloud from basic to advanced
• Transformations using Select statements in SQL
• Connecting dbt Cloud to AWS RDS PostgreSql

Rating: 3.6

Level: All Levels

Duration: 2.5 hours

Instructor: Jim Macaulay