Udemy

dbt (Data Build Tool): The Analytics Engineering Guide

立即報名
  • 173 名學生
  • 更新於 1/2025
  • 可獲發證書
4.5
(24 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
5 小時 48 分鐘
教學語言
英語
授課導師
Wadson Guimatsa
證書
  • 可獲發
  • *證書的發放與分配,依課程提供者的政策及安排而定。
評分
4.5
(24 個評分)
3次瀏覽

課程簡介

dbt (Data Build Tool): The  Analytics Engineering Guide

Elevate Your Analytics Workflows: Transform data with dbt Cloud & dbt Core and Apply Software Engineering best practices

Take your skills as a data professional to the next level with this Hands-on Course course on dbt, the Data Build Tool.

Start your journey toward mastering Analytics Engineering by signing up for this course now!

This course aims to give you the necessary knowledge and abilities to effectively use dbt in your data projects and help you achieve your goals.

This course will guide you through the following:

  1. Understanding the dbt architecture: Learn the fundamental principles and concepts underlying dbt.

  2. Developing dbt models: Discover how to convert business logic into performant SQL queries and create a logical flow of models.

  3. Debugging data modeling errors: Acquire skills to troubleshoot and resolve errors that may arise during data modeling.

  4. Monitoring data pipelines: Learn to monitor and manage dbt workflows efficiently.

  5. Implementing dbt tests: Gain proficiency in implementing various tests in dbt to ensure data accuracy and reliability.

  6. Deploying dbt jobs: Understand how to set up and manage dbt jobs in different environments.

  7. Creating and maintaining dbt documentation: Learn to create detailed and helpful documentation for your dbt projects.

  8. Promoting code through version control: Understand how to use Git for version control in dbt projects.

  9. Establishing environments in data warehouses for dbt: Learn to set up and manage different environments in your data warehouse for dbt projects.

  10. Testing Data Models: Learn how to use built-in tests in dbt and create custom ones.

By the end of this course, you will have a solid understanding of dbt, be proficient in its use, and be well-prepared to take the dbt Analytics Engineering Certification Exam. Whether you're a data engineer, a data analyst, or anyone interested in managing data workflows, this course will provide valuable insights and practical knowledge to advance your career.

Please note that this course does not require any prior experience with dbt. However, familiarity with SQL and basic data engineering concepts will be helpful.


Disclaimer:
This course is not affiliated, associated, authorized, endorsed by, or in any way officially connected with dbt Labs, Inc. or any of its subsidiaries or its affiliates.  The name “dbt” and related names, marks, emblems, and images are registered trademarks of dbt Labs, Inc. Similarly; this course is not officially connected with any data platform or tools mentioned in the course. The course content is based on the instructor's experience and knowledge and is provided only for educational purposes.

課程章節

  • 7 個章節
  • 66 堂課
  • 第 1 章 Introduction and dbt setup
  • 第 2 章 Developing dbt models
  • 第 3 章 dbt Core
  • 第 4 章 Configuring dbt Project
  • 第 5 章 Analyses & Seeds
  • 第 6 章 Node Selection Syntax
  • 第 7 章 dbt Testing: How to test your dbt resources

課程內容

  • Managing dbt Projects: Learn to initiate, structure, and effectively manage dbt projects, including dbt profiles understanding.
  • Master dbt Models: Understand how to create and manage dbt models, including their dependencies, configurations.
  • Grasp dbt's Core Purpose: You will confidently articulate what dbt is and its crucial role in data engineering.
  • Implement Testing in dbt: Understand the different types of tests in dbt, and how to implement them effectively for different models and other dbt resources..
  • Understand dbt Packages: Gain knowledge on how to use dbt packages to modularize and reuse code across different dbt projects.
  • Deploy dbt Cloud Jobs: Learn how to configure and deploy dbt jobs in various environments, understanding the differences and requirements of each.
  • Create and Maintain dbt Documentation: Learn how to generate and maintain documentation within dbt, including descriptions of sources, tables, and columns.
  • Setting Up and Installing dbt: you should be able to navigate the process of installing dbt and setting it up whether that's a local machine or dbt cloud
  • Version Control: Understand how dbt integrates with platforms like GitHub to provide version control, ensuring you can track and manage changes effectively.
  • Streamlined Workflows: Instead of juggling multiple tools and platforms, learn how dbt serves as a one-stop solution for most of your data transformation needs.
  • dbt Cloud IDE: Master how to use dbt Cloud IDE to write, test, and deploy DBT models and other resources without needing to interact with the command line.


評價

  • D
    Data clicks
    3.0

    Veraltet und buggy teilweise

  • E
    Evgeny Chernoskutov
    3.0

    The audio is bad. It makes it hard to study this course.

  • I
    Ingo Klose
    4.5

    Very good course on dbt fundamentals. The instructor explains quite clearly.

  • L
    Laxman Timalsina
    4.5

    "Great course! The instructor is very talented, and the explanations are extremely helpful. I gained a lot of value from this course. There aren’t many DBT courses available in the market, but this one stands out. The instructor’s detailed explanations and comprehensive coverage of every aspect of DBT make it beneficial for both newcomers and professionals. Thank you for your help!"

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意