YoVDO

Data Engineering: dbt for SQL

Offered By: LinkedIn Learning

Tags

SQL Courses Data Warehousing Courses Version Control Courses dbt (Data build tool) Courses Data Transformation Courses Data Modeling Courses Data Engineering Courses ETL Courses

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
1. SQL for Data Engineers
  • SQL as a data engineer
  • The modern data stack and SQL
  • Schema design
  • Challenge: Schema design
  • Solution: Schema design
2. Modeling in SQL
  • Supply chain outage: SQL spaghetti
  • Data build tool (dbt)
  • Modeling in dbt
  • Running dbt
  • Challenge: Modeling taxi data
  • Solution: Modeling taxi data
3. Table Materializations
  • Crypto cost: Materializations
  • Materialization terminology
  • Incremental materializations
  • Challenge: Materializations
  • Solution: Materializations
4. Common Table Expressions vs. Subqueries
  • Construction planning: Query complexity
  • Common table expressions (CTEs) vs. subqueries
  • CTEs in dbt
  • Challenge: Implementing CTEs
  • Solution: Implementing CTEs
5. Testing SQL with dbt
  • Advertising: Testing SQL
  • Unit testing using dbt
  • Custom tests in dbt
  • Challenge: Testing SQL
  • Solution: Testing SQL
Conclusion
  • Looking ahead
  • Next steps

Taught by

Vinoo Ganesh

Related Courses

Achieving Advanced Insights with BigQuery - Français
Google 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