Learn DBT from Scratch

Learn DBT from Scratch, available at $69.99, has an average rating of 4.36, with 31 lectures, 1 quizzes, based on 2108 reviews, and has 11303 subscribers.

You will learn about Connect DBT to Snowflake or another database Create SQL transformations that use consistent logic Test SQL transformations and underlying data Run transformations on a schedule Add snapshots for slowly changing dimensional tables Test your code in a dev environment Learn DBT Best Practices Advanced DBT Topics This course is ideal for individuals who are Data Analysts and Scientists looking to improve their data pipeline or Prospective Data Scientists and Analysts interested in learning data engineering or Data Analytics Managers looking to understand the capabilities of DBT It is particularly useful for Data Analysts and Scientists looking to improve their data pipeline or Prospective Data Scientists and Analysts interested in learning data engineering or Data Analytics Managers looking to understand the capabilities of DBT.

Enroll now: Learn DBT from Scratch

Summary

Title: Learn DBT from Scratch

Price: $69.99

Average Rating: 4.36

Number of Lectures: 31

Number of Quizzes: 1

Number of Published Lectures: 31

Number of Published Quizzes: 1

Number of Curriculum Items: 35

Number of Published Curriculum Objects: 35

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Connect DBT to Snowflake or another database

Create SQL transformations that use consistent logic

Test SQL transformations and underlying data

Run transformations on a schedule

Add snapshots for slowly changing dimensional tables

Test your code in a dev environment

Learn DBT Best Practices

Advanced DBT Topics

Who Should Attend

Data Analysts and Scientists looking to improve their data pipeline

Prospective Data Scientists and Analysts interested in learning data engineering

Data Analytics Managers looking to understand the capabilities of DBT

Target Audiences

Data Analysts and Scientists looking to improve their data pipeline

Prospective Data Scientists and Analysts interested in learning data engineering

Data Analytics Managers looking to understand the capabilities of DBT

What you’ll learn

Welcome to this course, Learn DBT from Scratch. DBT lets you build a system of transformations on your data, with tests, scheduled runs, multiple environments, flexibility, and more all without needing a team of engineers to set up and manage your workflow. By the end of this course, you will have:

set up DBT locally and on the cloud

connected DBT to Snowflake (or a data warehouse of your choice)

create your own SQL transformations on data

test your transformations

snapshot your data to keep track of how your data changes over time

learn DBT best practices

In this course, you’ll be presented with the summarized information you need so that you can quickly get DBT implemented in your data pipeline (or in a brand new, data warehouse).

Why you should learn DBT

DBT is not one of the first technical skills most Data Scientists or Analysts think to learn. It’s not as exciting as machine learning algorithms, and it’s not as easy to show off as a fancy data visualization.

But DBT is an absolutely fundamental skill for any Data Scientist or Analyst due to all of its capabilities. Because DBT is so flexible, there are almost an endless amount of ways you can integrate DBT into your data architecture. Some features that DBT provides you that all Data Scientists and Analysts should be using in their work include:

1. Creating consistent aggregations for your analysis in a single location

2. Consistently testing your transformations and underlying data

3. Running your data transformations on a schedule

4. Test your code in a DEV environment

About DBT

DBT is pioneering modern analytics engineering. DBT applies the principles of software engineering to analytics code, an approach that dramatically increases your leverage as a data analyst. They believe that data analysts are the most valuable employees of modern, data-driven businesses and they build tools that empower analysts to own the entire analytics engineering workflow.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: How to Succeed in this Course

Chapter 2: Connect DBT and Snowflake

Lecture 1: Introduction

Lecture 2: Setup Part 1

Lecture 3: Setup Part 2

Lecture 4: Start Querying Data

Lecture 5: Creating a Transformation

Chapter 3: Getting Started with Models & Tests

Lecture 1: Introduction

Lecture 2: Types of Materializations

Lecture 3: Tables and Views

Lecture 4: Incremental Models

Lecture 5: Ephemeral Models

Lecture 6: Advanced Configurations

Lecture 7: Testing

Lecture 8: Custom Tests

Chapter 4: Deploying and DBT Cloud

Lecture 1: Introduction

Lecture 2: Deploying Using the Command Line

Lecture 3: Setting up DBT Cloud Part 1

Lecture 4: Setting up DBT Cloud Part 2

Chapter 5: Advanced Topics

Lecture 1: Introduction

Lecture 2: Hooks

Lecture 3: Snapshots

Lecture 4: Sources

Lecture 5: Macros

Lecture 6: Macros 2

Chapter 6: Best Practices

Lecture 1: Introduction

Lecture 2: Environment

Lecture 3: Styling with Common Table Expressions

Lecture 4: Tags

Lecture 5: Limiting Data

Lecture 6: Continuous Integration with Github

Instructors

Jeremy Holtzman
Data Analyst / Engineer

Rating Distribution

1 stars: 22 votes

2 stars: 47 votes

3 stars: 235 votes

4 stars: 832 votes

5 stars: 975 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!