data build tool in Cloud(dbt Cloud)

data build tool in Cloud(dbt Cloud), available at $44.99, has an average rating of 4.4, with 26 lectures, 4 quizzes, based on 66 reviews, and has 1789 subscribers.

You will learn about 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 SCDs using Snapshot Test Cases using Test functionality Jinja and Macros Deployment (CD/CI) – Running in Production This course is ideal for individuals who are Data Engineers, ETL Architects, Data Analysts, Data Scientists and BI Developers It is particularly useful for Data Engineers, ETL Architects, Data Analysts, Data Scientists and BI Developers.

Enroll now: data build tool in Cloud(dbt Cloud)

Summary

Title: data build tool in Cloud(dbt Cloud)

Price: $44.99

Average Rating: 4.4

Number of Lectures: 26

Number of Quizzes: 4

Number of Published Lectures: 26

Number of Published Quizzes: 4

Number of Curriculum Items: 30

Number of Published Curriculum Objects: 30

Original Price: ?3,999

Quality Status: approved

Status: Live

What You Will Learn

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

SCDs using Snapshot

Test Cases using Test functionality

Jinja and Macros

Deployment (CD/CI) – Running in Production

Who Should Attend

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

Target Audiences

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

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: About the Course

Chapter 2: dbt Cloud

Lecture 1: Introduction to dbt

Lecture 2: dbt Cloud Account Creation, Git Repository and Project Overview

Chapter 3: Models

Lecture 1: Introduction of Models

Lecture 2: Creating First Model

Lecture 3: Creating Models and Transformations

Lecture 4: Lineage, Compile, dbt run and logs

Chapter 4: Materializations

Lecture 1: Introduction of Materializations

Lecture 2: Table

Lecture 3: View

Lecture 4: Incremental

Lecture 5: Ephemeral

Chapter 5: Tests, Variables, Sources and Seeds

Lecture 1: Tests

Lecture 2: Variables

Lecture 3: Sources

Lecture 4: Introduction of Seeds

Lecture 5: Seeds

Chapter 6: Snapshots and Hooks

Lecture 1: Introduction of Snapshot

Lecture 2: Snapshot

Lecture 3: Introduction of Hook

Lecture 4: Hook

Chapter 7: Jinja and Macros

Lecture 1: Introduction of Jinja

Lecture 2: Jinja

Lecture 3: Introduction of Macros

Lecture 4: Macros

Chapter 8: Deployment

Lecture 1: Deployment/ Running in Production

Instructors

Jim Macaulay
Software Development Architect

Rating Distribution

1 stars: 4 votes

2 stars: 4 votes

3 stars: 17 votes

4 stars: 16 votes

5 stars: 25 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!