Data Engineering: dbt for SQL
Offered By: LinkedIn Learning
Course Description
Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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
- 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
Related Courses
Achieving Advanced Insights with BigQuery - FrançaisGoogle Cloud via Coursera Database Administration and SQL Language Basics
A Cloud Guru SQL Deep Dive
A Cloud Guru Using Python for Data Management and Reporting
A Cloud Guru نمذجة البيانات المتقدمة
Meta via Coursera