Data Engineering: dbt for SQL
1h 31mAdvanced2023-09-26
Authors
Vinoo Ganesh
CEO and founder of Stealth Startup
Course details
Are you looking for a better—and easier—way to manage SQL code? In this course, instructor Vinoo Ganesh shows you how to use dbt (data build tool) to operationalize SQL in powerful ways and make the process of transforming data simpler and faster. In each chapter, Vinoo presents a real-world situation or problem, and provides focused code examples explaining how to solve the problem. He shows you how to design and implement dbt models to solve basic and advanced challenges, covering topics like schema design, generating SQL model files, table materializations, implementing CTEs, and SQL unit tests. Join Vinoo in this course to advance your SQL skills and make your code management easier.
Skills covered
Data Build Tool (dbt)Data ModelingSQLDatabase AdministrationData EngineeringDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Introduction
- 02 - What you should know
- 03 - Codespaces introduction
1. SQL for Data Engineers
- 04 - SQL as a data engineer
- 05 - The modern data stack and SQL
- 06 - Schema design
- 07 - Challenge - Schema design
- 08 - Solution - Schema design
2. Modeling in SQL
- 09 - Supply chain outage - SQL spaghetti
- 10 - Data build tool (dbt)
- 11 - Modeling in dbt
- 12 - Running dbt
- 13 - Challenge - Modeling taxi data
- 14 - Solution - Modeling taxi data
3. Table Materializations
- 15 - Crypto cost - Materializations
- 16 - Materialization terminology
- 17 - Incremental materializations
- 18 - Challenge - Materializations
- 19 - Solution - Materializations
4. Common Table Expressions vs. Subqueries
- 20 - Construction planning - Query complexity
- 21 - Common table expressions (CTEs) vs. subqueries
- 22 - CTEs in dbt
- 23 - Challenge - Implementing CTEs
- 24 - Solution - Implementing CTEs
5. Testing SQL with dbt
- 25 - Advertising - Testing SQL
- 26 - Unit testing using dbt
- 27 - Custom tests in dbt
- 28 - Challenge - Testing SQL
- 29 - Solution - Testing SQL
Conclusion
- 30 - Looking ahead
- 31 - Next steps