|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mastering-dbt-data-build-tool-bootcamp/
课程评论:没有评论
2025 dbt (Data Build Tool) 精通课程 - 从入门到精通 这门课程旨在帮助所有具备基础 SQL 技能的学习者,掌握 dbt——分析工程领域的重要工具。课程内容涵盖 dbt 的理论基础,并从零开始构建一个高级 dbt 项目,最终将其部署到 dbt Cloud。 讲师拥有超过 9 年的分析、分析工程和数据科学经验,其中包括 5 年的 dbt 日常使用经验。课程将讲师在 dbt 领域的五年学习和实战经验进行浓缩,旨在以最快速度将具备 SQL 基础的学习者提升到 dbt 高级水平。 课程的教学方法强调实践成果,避免过多地讲解数据库理论或特定的示例数据集细节,而是专注于快速提升学习者在 dbt 方面的能力。对于所有涉及代码编写的视频,都提供了最终成果的附件,学习者可以选择同步编码或在观看视频后参考讲义。讲义中还包含理论知识,以加深对视频内容的理解。课程还提供了一个公共 GitHub 仓库,其中包含一个可供参考的最终项目模型。课程内容将根据反馈持续更新。 课程结构: 课程首先讲解 dbt 解决的问题,接着构建一个基础的 dbt 项目,然后逐步深入高级概念,最后通过 dbt Cloud 完成项目部署。 主要内容包括: - dbt 的理论基础 - 构建基础 dbt 项目 - 应用 dbt 的高级功能,如创建自定义测试和宏 - 使用 dbt Cloud 进行项目部署
A complete course to help anyone with basic SQL skills learn advanced dbt, a key tool for Analytics Engineering!Welcome to the 2025 Mastering dbt (data build tool) course! This course runs through everything from the theory behind dbt to building an advanced dbt project (from scratch) and deploying it on dbt Cloud.I have over 9 years of experience across Analytics / Analytics Engineering / Data Science, including 5 years using dbt on a daily basis. I was also involved in the rollout of dbt in my time at Monzo Bank! In this course I've taken everything I've learnt over the past 5 years, and what I use on a daily basis, and condensed it to take anyone who knows SQL to an advanced level of dbt as quickly as possible.MY APPROACH TO THIS COURSE:We'll cover everything you need to know about dbt: from the basic data modelling right through to all of the advanced features such as creating custom tests and macros. We'll be doing this step by step, and build from the basics upwards.It's focused on practical outcomes - we won't be spending ages on database theory, or going into lots of detail on the eCommerce dataset we'll be using, instead we'll be aiming to get you up to advanced dbt levels as quickly as possible.For every video where we're writing code, I've created lesson attachments with the final outputs. This means you can either code as you go along, or watch the videos and look at the handouts afterwards! I've also included some theory with these handouts to help hammer home the points made in the videos.There's also a public GitHub repository (which you'll be using for this course) that contains a model final project you can reference throughout.This course isn't static! I'd love to hear your feedback and will be updating this course on an ongoing basis.COURSE STRUCTURE:This course focuses on first getting a good understanding of what problems dbt solves, then building a basic dbt project, before layering on more advanced concepts and finally deploying our project with dbt Cloud.IntroductionSome theory (