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

LinkedIn Learning

Data Engineering: dbt for SQL

via LinkedIn Learning

Overview

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

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.