image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

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:
Creating consistent aggregations for your analysis in a single location
Consistently testing your transformations and underlying data
Running your data transformations on a schedule
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.
Who this course is for:
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

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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Introduction
2
1.1-Introduction
1.2-How to Succeed in this Course
2-Connect DBT and Snowflake
6
2.1-Introduction
2.2-Setup Part 1
2.3-Setup Part 2
2.4-Start Querying Data
2.5-Creating a Transformation
2.6-Create Your Own Transformation
3-Getting Started with Models & Tests
11
3.1-Introduction
3.2-Types of Materializations
3.3-Tables and Views
3.4-Incremental Models
3.5-Ephemeral Models
3.6-Types of Materializations
3.7-Configuring Your Own Incremental Model
3.8-Advanced Configurations
3.9-Testing
3.10-Custom Tests
3.11-Setting Up Your Own Tests
4-Deploying and DBT Cloud
4
4.1-Introduction
4.2-Deploying Using the Command Line
4.3-Setting up DBT Cloud Part 1
4.4-Setting up DBT Cloud Part 2
5-Advanced Topics
6
5.1-Introduction
5.2-Hooks
5.3-Snapshots
5.4-Sources
5.5-Macros
5.6-Macros 2
6-Best Practices
6
6.1-Introduction
6.2-Environment
6.3-Styling with Common Table Expressions
6.4-Tags
6.5-Limiting Data
6.6-Continuous Integration with Github