learning path

A Practical Dive Into Data Build Tool (dbt)

Intermediate
15h 50m
445
5/5
Enhance your skill setDevelop essential skills for thriving in real-world scenarios.
Stay focused, stay committedBoost your learning journey by enrolling: stay focused, consistent and achieve your goals with ease.
Earn a certificate of completionShow your skills and build your credibility when you include them in your resume and LinkedIn profile.
Training content
12
See all

This course is designed to give you practical, hands-on experience with the Data Build Tool so you can use it confidently for creating data modeling and transforming projects.

We start by looking at how to create a dbt project, configure it to communicate with a database, and look at the most crucial feature dbt offers: models. We will then move to more advanced concepts such as Jinja macros, seeds uploading, and testing practices. We will then discuss how to organize a dbt project in a clear and expressive way.

Finally, your newly acquired skills will be put to the test with a lab challenge in which you will be assessed on your ability to perform tasks to create and test models, define schemas, and organize a dbt project.

By the end of this course, you're going to be confident when using the Data Build Tool for building data transformation processes. As an added bonus, this path also includes a lab playground in which you can have a go at using Data Build Tool to do whatever you want, and experiment with the tool.

Learning Objectives

  • Understand basic principles of Data Build Tool
  • Work with dbt models
  • Define models' schemas and tests
  • Upload static CSVs (seeds)
  • Organize a dbt project

Intended Audience

  • Data engineers with a focus on data modeling and transformations methodologies
  • Data analysts and Analytics engineers that need to extract useful insights from raw data

Prerequisites

To get the most out of this course, you should have basic knowledge of SQL. Please consider taking our Learn SQL - From Newbie to Ninja course to brush up on your SQL skills, if necessary.

Your certificate for this learning path
About the Author
Avatar
Stefano Cascavilla
Junior Data Engineer
Students
39,696
Labs
106
Courses
2
Learning paths
10

Stefano studies Computer Science and is passionate about technology. He loves working with Cloud services and learning all the best practices for them. Google Cloud Platform and Amazon Web Services are the cloud providers he prefers. He is a Google Cloud Certified Associate Cloud Engineer. Node.js is the programming language he always uses to code. When he's not involved in studying or working, Stefano loves riding his motorbike and exploring new places.

Covered Topics