Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Data Engineering: dbt for SQL

via LinkedIn Learning

Write review

Coursera

AI, Data Science & Cloud Certificates from Google, IBM & Meta

University of the People

Earn Your CS Degree, Tuition-Free, 100% Online!

Overview

Google, IBM & Meta Certificates – 40% Off

One plan covers every Professional Certificate on Coursera.

Unlock All Certificates

Learn how you can use dbt (data build tool) to make managing your SQL code simpler and faster.

Syllabus

Introduction

Introduction
What you should know
Codespaces introduction

1. SQL for Data Engineers

SQL as a data engineer
The modern data stack and SQL
Schema design
Challenge: Schema design
Solution: Schema design

2. Modeling in SQL

Supply chain outage: SQL spaghetti
Data build tool (dbt)
Modeling in dbt
Running dbt
Challenge: Modeling taxi data
Solution: Modeling taxi data

3. Table Materializations

Crypto cost: Materializations
Materialization terminology
Incremental materializations
Challenge: Materializations
Solution: Materializations

4. Common Table Expressions vs. Subqueries

Construction planning: Query complexity
Common table expressions (CTEs) vs. subqueries
CTEs in dbt
Challenge: Implementing CTEs
Solution: Implementing CTEs

5. Testing SQL with dbt

Advertising: Testing SQL
Unit testing using dbt
Custom tests in dbt
Challenge: Testing SQL
Solution: Testing SQL

Conclusion

Looking ahead
Next steps

Taught by

Vinoo Ganesh

Reviews

4.6 rating at LinkedIn Learning based on 171 ratings

Start your review of Data Engineering: dbt for SQL