learning path

A Practical Dive Into Data Build Tool (dbt)

Intermediate
15h 50m
431
5/5
Build hands-on tech skillsImprove theoretical and practical skills needed in real-world scenarios.
Stay focused, stay committedSupercharge your learning journey by enrolling, empowering you to stay focused, motivated, 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 learning path 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 learning path, 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 learning path, you should have basic knowledge of SQL. Please consider taking our Learn SQL - From Newbie to Ninja learning path 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,363
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