|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/data-warehousing-with-microsoft-azure-synapse-analytics
课程评论:没有评论
课程名称:使用Microsoft Azure Synapse Analytics的数据仓库 概述:本课程旨在帮助学员掌握在Azure Synapse Analytics中高效和安全地使用现代数据仓库的工具和技术。学员将学习如何利用现代架构模式构建数据仓库,以及在数据仓库中如何实现通用架构。课程还将介绍数据加载的最佳实践,以及在Azure Synapse Analytics中优化查询性能的技巧。 该课程是一个专项课程的一部分,适合想要展示在设计和实施数据解决方案方面专家水平的数据工程师和开发者,特别是为准备DP-203考试:Microsoft Azure上的数据工程(测试版)的人士。 本课程是10门课程中的第五门,旨在帮助学员准备考试,以便在使用Microsoft Azure数据服务设计和实施数据解决方案方面获得专长。DP-203考试是一个认证机会,考核学员在整合、转换和整合来自不同的结构化和非结构化数据系统的数据,以构建适合分析解决方案的数据结构的知识和专长。每门课程都会教授考试中测评的概念和技能。 课程大纲: 1. 设计现代数据仓库使用Azure Synapse Analytics - 学习如何利用Azure Synapse Analytics构建使用现代架构模式的数据仓库。 2. 设计多维架构以优化分析工作负载 - 学习如何在数据仓库中实现通用架构。 3. 在Azure Synapse Analytics中加载和查询数据 - 了解加载数据到数据仓库的最佳实践,以及优化Azure Synapse Analytics中查询性能的技术。 4. 在Azure Synapse Analytics中集成池和开发工具 - 学习如何在Azure Synapse Analytics中集成SQL和Apache Spark池,并了解可用于创建数据仓库的语言能力。 5. 管理、优化和保护数据仓库 - 学习如何管理和监控Azure Synapse Analytics,分析用于优化数据仓库的信息,以及实施安全措施以保护数据。 6. 使用Azure Synapse Analytics进行数据仓库的实践考试 - 参加一场涵盖DP-203考试中关键技能的实践考试。 通过本专项课程的学习,您将为参加DP-203考试做好准备并能够注册参加考试。
Name:Design a Modern Data Warehouse using Azure Synapse Analytics
Description:In this module, you will learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns.
Name:Design a multidimensional schema to optimize analytical workloads
Description:In this module, you will learn about how the common schema is implemented in a data warehouse.
Name:Data loading and querying in Azure Synapse Analytics
Description:In this module, you will learn the best practices you need to adopt to load data into a data warehouse and the techniques that you can use to optimize query performance within Azure Synapse Analytics.
Name:Integrating pools and developer tools in Azure Synapse Analytics
Description:In this module, you will learn how to integrate SQL and Apache Spark pools in Azure Synapse Analytics. You will also learn about the language capabilities that are available to create data warehouses in Azure Synapse Analytics.
Name:Manage, optimize and secure a data warehouse
Description:In this module, you will learn how to manage and monitor Azure Synapse Analytics. You will learn to analyze information used to optimize a data warehouse in Azure Synapse Analytics and how to approach and implement security to protect your data with Azure Synapse Analytics.
Name:Practice Exam on Work with Data Warehouses using Azure Synapse Analytics
Description:In this module, you will take a practice exam that covers key skills measured in the Exam DP-203: Data Engineering on Microsoft Azure.
In this course, you will explore the tools and techniques that can be used to work with Modern Data Warehouses productively and securely within Azure Synapse Analytics. You will learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns and how the common schema is implemented in a data warehouse. You'll learn the best practices you need to adopt to load data into a data warehouse and the techniques that you can use to optimize query performance within Azure Synapse Analytics. This course is part of a Specialization intended for Data engineers and developers who want to demonstrate their expertise in designing and implementing data solutions that use Microsoft Azure data services for anyone interested in preparing for the Exam DP-203: Data Engineering on Microsoft Azure (beta). This is the fifth course in a program of 10 courses to help prepare you to take the exam so that you can have expertise in designing and implementing data solutions that use Microsoft Azure data services. The Data Engineering on Microsoft Azure exam is an opportunity to prove knowledge expertise in integrating, transforming, and consolidating data from various structured and unstructured data systems into structures that are suitable for building analytics solutions that use Microsoft Azure data services. Each course teaches you the concepts and skills that are measured by the exam. By the end of this Specialization, you will be ready to take and sign-up for the Exam DP-203: Data Engineering on Microsoft Azure (beta).