|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/become-a-data-warehouse-engineer-dwsqletlssisazure/
课程评论：没有评论
课程名称：成为数据仓库工程师 - (DW, SQL, ETL/SSIS, Azure) 课程概述：本课程旨在帮助您掌握数据仓库的概念和实践，SQL编程，使用SQL Server集成服务（SSIS）进行ETL流程，以及Azure Synapse分析。课程旨在为您提供理论知识和实践技能，使您成为一名熟练的数据仓库工程师。 在课程中，您将学习如何为数据仓库使用配置专用SQL池，这是管理和运行大规模分析处理的关键。您还将获得在Azure Synapse Analytics工作区中进行实践的经验，这是微软的集成分析服务，可以加快您在数据仓库和大数据系统中的洞察时间。 课程将指导您设计和构建数据摄取系统，并通过管道进行操作。您将获得使用无服务器SQL池分析数据的实际技能，使您能够按需查询数据而无需设置基础设施。 您将学习如何有效地构建数据仓库，以便优化数据检索和分析。这包括学习如何配置数据仓库的数据库设置以及设计维度表，这是构建功能全面、高效数据仓库的重要方面。 除了这些，您还将深入学习如何使用SSIS创建稳健的ETL解决方案，管理和自动化数据转换过程。这包括实现数据流、调试SSIS包以及了解如何实现增量ETL过程，以保持您的数据仓库始终更新而不给系统带来压力。 课程还涵盖SSIS的配置和部署，使您能够在不同的环境中有效管理ETL解决方案，确保数据质量是任何数据仓库系统的重要方面。您将学习在数据仓库中强制执行数据质量的策略，以确保从数据中获得可靠和准确的洞察。 最后，课程将训练您如何在数据仓库中使用数据。除了提取数据，您还将学习如何将数据转化为有用的洞察和可视化，并通过Synapse Studio创建这些可视化。 完成本课程后，您将具备坚实的数据仓库工程基础，准备在这一激动人心和快速发展的领域中担任相关角色。
This course is designed to equip you with an understanding of Data Warehousing concepts and practices, SQL programming, ETL processes using SQL Server Integration Services (SSIS), and Azure Synapse Analytics. This course aims to provide you with both theoretical knowledge and practical skills to become a proficient Data Warehouse Engineer.As a part of this course, you will learn how to provision a dedicated SQL Pool for data warehouse use, critical for managing and running large scale analytical processing. You will also get hands-on experience in provisioning Azure Synapse Analytics workspace, Microsoft's integrated analytics service that accelerates your time to insight across data warehouses and big data systems.The course will guide you through designing and building data ingestion systems using a pipeline. You will acquire practical skills on using a Serverless SQL Pool to analyze data, providing you the ability to query data on-demand with no infrastructure setup.You will learn to effectively structure your data warehouse for optimal data retrieval and analysis. This includes learning how to configure database settings for a data warehouse and designing dimension tables - crucial aspects of building a functional, efficient data warehouse.You will also dive deep into creating robust ETL solutions with SSIS, allowing you to manage and automate your data transformation processes. This includes learning to implement data flows, debug SSIS packages, and understand how to implement an incremental ETL process, keeping your data warehouse up-to-date without overloading your systems.The course covers SSIS configuration and deployment, enabling you to effectively manage your ETL solutions in different environments. Ensuring data quality is a crucial aspect of any data warehouse system. You will learn strategies to enforce data quality in a data warehouse, ensuring reliable and accurate insights from your data.Lastly, the course will also train you on how to consume data in a data warehouse. This involves not just extracting data, but also transforming it into useful insights and visualizations, which you will learn to create using Synapse Studio.By the end of this course, you will have a solid foundation in data warehouse engineering, and be ready to take on roles in this exciting and growing field.
