Advance Your SQL Skills with dbt for Data Engineering

Focused View

Vinoo Ganesh

1:31:18

76 View

01 - Introduction

01 - Introduction.mp4

00:48

02 - What you should know.mp4

01:27

03 - Codespaces introduction.mp4

02:59

02 - 1. SQL for Data Engineers

01 - SQL as a data engineer.mp4

02:38

02 - The modern data stack and SQL.mp4

03:40

03 - Schema design.mp4

03:19

04 - Challenge Schema design.mp4

02:03

05 - Solution Schema design.mp4

03:18

03 - 2. Modeling in SQL

01 - Supply chain outage SQL spaghetti.mp4

03:06

02 - Data build tool (dbt).mp4

02:52

03 - Modeling in dbt.mp4

05:34

04 - Running dbt.mp4

03:53

05 - Challenge Modeling taxi data.mp4

01:35

06 - Solution Modeling taxi data.mp4

02:44

04 - 3. Table Materializations

01 - Crypto cost Materializations.mp4

03:02

02 - Materialization terminology.mp4

03:58

03 - Incremental materializations.mp4

02:49

04 - Challenge Materializations.mp4

01:46

05 - Solution Materializations.mp4

03:46

05 - 4. Common Table Expressions vs. Subqueries

01 - Construction planning Query complexity.mp4

02:51

02 - Common table expressions (CTEs) vs. subqueries.mp4

03:36

03 - CTEs in dbt.mp4

02:51

04 - Challenge Implementing CTEs.mp4

02:00

05 - Solution Implementing CTEs.mp4

02:22

06 - 5. Testing SQL with dbt

01 - Advertising Testing SQL.mp4

02:56

02 - Unit testing using dbt.mp4

05:03

03 - Custom tests in dbt.mp4

04:07

04 - Challenge Testing SQL.mp4

02:14

05 - Solution Testing SQL.mp4

04:03

07 - Conclusion

01 - Looking ahead.mp4

01:46

02 - Next steps.mp4

02:12

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Data Science

Data Analysis

Data Mining

SQL

Microsoft SQL

Vinoo Ganesh

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.