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

Corporate Finance Institute

Build the Finance Skills That Lead to Promotions — Not Just Certificates

CodeSignal

Learn the Skills Netflix, Meta, and Capital One Actually Hire For

Overview

Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off

One annual plan covers every course and certificate on Coursera. 40% off for a limited time.

Get Full Access

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 91 ratings

Start your review of Data Engineering: dbt for SQL