English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 1h 31m | 202 MB
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.
Table of Contents
Introduction
1 Introduction
2 What you should know
3 Codespaces introduction
SQL for Data Engineers
4 SQL as a data engineer
5 The modern data stack and SQL
6 Schema design
7 Challenge Schema design
8 Solution Schema design
Modeling in SQL
9 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
Table Materializations
15 Crypto cost Materializations
16 Materialization terminology
17 Incremental materializations
18 Challenge Materializations
19 Solution Materializations
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
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
Resolve the captcha to access the links!