Data Engineering with dbt

سرفصل های دوره

Data Build Tool (dbt) has quickly become an essential tool in many data stacks ranging from startups to big tech for managing data transformations. In this course, data engineer Mark Freeman helps you get started with setting up, running, and managing a dbt project via the open-source offering dbt Core. Learn how to install dbt Core, configure an environment for dbt, create and manage a dbt project, and deploy a dbt project in production. If you’re a data professional tasked with implementing dbt within your organization, recently joined a team utilizing dbt and need to upskill, or just want to learn about dbt to increase your competitiveness within the data job market, check out this course.

01 - Introduction

01 - Build your first dbt project

02 - Introducing the dbt project

03 - The project in GitHub Codespaces

02 - 1. Prepare Your Coding Environment

01 - Install the dbt Core via pip

02 - Install the dbt connector to DuckDB

03 - Install DuckDB via pip

04 - Update your requirements.txt file within your project

03 - 2. Prepare Your Database Environment

01 - Create your database file

02 - Import CSV data into your new database

04 - 3. Create a dbt Project

01 - Start your project with dbt init

05 - 4. Prepare Your dbt Environment

01 - Understand the dbt project.yml file

02 - Create your profiles YAML file

03 - Connect your profiles and project YAML files

06 - 5. Your First dbt Model

01 - Create your first dbt model file

02 - Using the dbt CLI commands

07 - 6. Introduction to dbt Ref Function

01 - Create your dbt model utilizing ref

02 - Run your dbt models with the ref syntax

03 - View your dbt project data lineage

08 - 7. Implementing Medallion Architecture with dbt

01 - Planning your medallion architecture project

02 - Medallion architecture Bronze data

03 - Medallion architecture Silver data

04 - Medallion architecture Gold data

09 - 8. Materialization of dbt Models

01 - Materialization in your dbt project

02 - Implement materialization in your dbt project.yml file

10 - 9. Documentation as Code via dbt

01 - Further documentation via schema.yml file

02 - The docs blocks.md file

11 - 10. Implementing Tests within Your dbt Project

01 - Creating custom singular tests

02 - Implementing tests within the schema.yml file

12 - 11. Deploying Your dbt Project

01 - Utilizing multiple dbt profiles

02 - Deploying with GitHub workflows

13 - Conclusion

01 - Next steps

54,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)