|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dbt-core-from-scratch-build-your-first-project-in-2-hours/
课程评论：没有评论
**课程名称：** dbt Core 从零开始 - 2小时内构建你的第一个项目 **课程概述：** 本课程是一门全面且快节奏的 dbt Core 入门课程，旨在帮助你掌握这个彻底改变现代数据栈中数据团队数据转换和管理方式的关键工具。在约2小时的时间里，课程将一步一步地指导你完成开始使用 dbt Core 所需了解的一切，从安装和配置到高级建模和文档编写。 **课程内容摘要：** 1. **dbt Core 简介：** * 理解 ELT 和 ETL 过程的关键区别。 * 了解 dbt 是什么，以及它为何是数据转换的“游戏规则改变者”。 2. **环境设置：** * 详细的安装指南，涵盖 Windows 和 Linux。 * 配置关键的 `profiles.yaml` 文件，用于连接 dbt 到你的数据仓库。 3. **核心概念与实践：** * **Sources：** 管理原始数据，包括新鲜度检查和测试以确保数据可靠性。 * **Models：** 高效地构建、组织和物化 SQL 模型，包括优化性能的增量模型。 * **Macros：** 自动化重复任务，简化 dbt 工作流程。 * **Seeds：** 将 CSV 数据加载到你的数据仓库。 * **Documentation：** 为你的项目生成清晰、有用的文档。 **目标学员：** 数据分析师、数据工程师，以及任何希望拥抱现代数据转换最佳实践的人。 **课程价值：** 本课程将为你提供实用的技能和信心，加速你的 dbt Core 之旅，并提升你团队数据管道的质量和可维护性。
Welcome to a comprehensive yet fast-paced onboarding course for dbt Core - the essential tool revolutionizing how data teams transform and manage data in the modern analytics stack. Over approximately 2 hours, this course will guide you step-by-step through everything you need to know to confidently start working with dbt Core, from installation and configuration to advanced modeling and documentation.You will begin by understanding the key differences between ELT and ETL processes, and learn exactly what dbt is and why it's a game-changer for data transformation. Next, we'll cover how to set up your environment, including detailed installation instructions for both Windows and Linux, and configuration of the critical profiles.yaml file to connect dbt to your data warehouse.The course dives deep into working with Sources to manage your raw data, including freshness checks and tests to ensure data reliability. You'll master Models - learning how to build, organize, and materialize SQL models efficiently, including incremental models that optimize performance.Macros will be demystified so you can automate repetitive tasks and streamline your dbt workflows. Finally, you'll explore Seeds and Documentation, learning to load CSV data into your warehouse and generate clean, useful documentation for your projects.Whether you're a data analyst, engineer, or anyone eager to embrace modern data transformation best practices, this fast onboarding course will equip you with practical skills and confidence to accelerate your dbt Core journey and improve your team's data pipeline quality and maintainability.
