|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dbt-data-build-tool/
课程评论：没有评论
课程名称：dbt（数据构建工具）：数据工程师的dbt 课程概述： dbt（数据构建工具）并不是传统的ETL工具，它不会从多个异构源提取数据、进行转换并最后加载到数据仓库中。简单来说，dbt是一个开源命令行工具，帮助分析师和工程师更有效率地在数据仓库中转换数据。作为现代数据栈工具，dbt用于分析数据，揭示新见解并提升工作效率。dbt的优势在于能够在数据库层面进行计算，而非在内存层面，这使得它更加安全、快速且易于维护。 数据工程师通过不同方式收集、管理和转换原始数据，以便于数据科学家和业务分析师进行解读。他们的主要目标是让企业能够及时、有效地做出决策。 学习dbt的理由： dbt在数据仓库行业日益受到欢迎，2023年全球有超过3000家公司在其数据仓库部门开始使用这一工具，包括IBM、Jet Blue、Dyson、Capgemini等大公司。如果你希望在数据仓库领域作为数据工程师、数据分析师或数据科学家发展你的职业生涯，那么掌握这个现代数据栈工具将非常重要。此课程的先决条件为基础SQL知识，无需深入的SQL或编程概念。 重要主题： - dbt（数据构建工具）简介 - dbt（数据构建工具）云及其核心配置和设置 - 数据仓库概念 - dbt模型及其部署到数据库 - 数据物化及其不同类型 - 缓慢变化维度 - dbt快照 - dbt（数据构建工具）来源和种子 - 宏和包 - Jinja模板语言基础概述及其在dbt模型中的应用 - 宏和dbt测试 - dbt（数据构建工具）文档及工作部署 课程结束后： 完成此课程后，您将对该工具有最大的了解，并能够看到使用该工具的实际示例。此外，您将获得实践知识，可以将这些概念应用于上述不同领域。祝您学习愉快！
What is dbt(data build tool)?dbt is not an ETL tool that you use in you warehouse to extract data from multiple heterogeneous sources and then transform it and then finally load the data in the data warehousedbt in simple words is an open-source command line tool that helps analysts and engineers transform data in their warehouse more effectively and more efficientlydbt is a modern data stack tool. Modern data stack tools are used to analyse data and uncover new insights and improve efficiencyWhat makes dbt more more secure,fast and easier to maintain is the ability to do all the calculation at the database level rather than memory levelData engineers work in different ways to collect, manage, and convert raw data into usable information for data scientists and business analysts to interpret.Their main goal is to make data available and accessible for the organisation so that timely and effective decisions are taken for the business.Why to Learn dbt(data buildTool):dbt(data build tool) is becoming the most popular tool in Data Warehouse industry.Many big companies like IBM,Jet Blue,Dyson, Capgemini etc are using this tool,around the world in 2023 over 3000 companies have started using this tool in their Data Warehouse department.Career Perspective:If you want to pursue a career in the field of Data Warehouse as a Data Engineer,Data Analyst or Data Scientist then you must learn this modern data stack tool.The pre-requisite of this course is basic SQL,no advance knowledge of SQL is required,neither any programming concepts are needed.Important topics:Introduction to dbt(data build tool)dbt(data build tool) Cloud and Core Configuration and SetupData Warehousing Conceptsdbt Models and it's deployment to databaseMaterialization and its different typesSlowly Changing DimensionSnapshot in dbtdbt(data build tool) Sources and SeedsMacros and PackagesBasic Overview of Jinja Templating language and it's usage in dbt modelsMacro and dbt Testingdbt(data build tool) documentation and Job deploymentAfter this CourseOnce you're done with the course,you will have maximum knowledge of this tool,plus you will get to see hands-On examples of using this tool.Moreover after attaining all the practical knowledge you can apply these concept in different field as mentioned above.Cheers..!!Having a Great Learning!
