Learn how you can use dbt (data build tool) to make managing your SQL code simpler and faster.
Overview
Syllabus
Introduction
- Introduction
- What you should know
- Codespaces introduction
- SQL as a data engineer
- The modern data stack and SQL
- Schema design
- Challenge: Schema design
- Solution: Schema design
- Supply chain outage: SQL spaghetti
- Data build tool (dbt)
- Modeling in dbt
- Running dbt
- Challenge: Modeling taxi data
- Solution: Modeling taxi data
- Crypto cost: Materializations
- Materialization terminology
- Incremental materializations
- Challenge: Materializations
- Solution: Materializations
- Construction planning: Query complexity
- Common table expressions (CTEs) vs. subqueries
- CTEs in dbt
- Challenge: Implementing CTEs
- Solution: Implementing CTEs
- Advertising: Testing SQL
- Unit testing using dbt
- Custom tests in dbt
- Challenge: Testing SQL
- Solution: Testing SQL
- Looking ahead
- Next steps
Taught by
Vinoo Ganesh