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.
提供方
課程信息
Knowledge of data processing languages, such as SQL, Python, or Scala. An understanding of parallel processing and data architecture patterns.
您將學到的內容有
How to use Azure Synapse Analytics to build Data Warehouses using modern architecture patterns.
您將獲得的技能
- Design a Modern Data Warehouse using Azure Synapse Analytics
- Optimize and secure a data warehouse
- Design a multidimensional schema to optimize analytical workloads
- Manage a data warehouse
Knowledge of data processing languages, such as SQL, Python, or Scala. An understanding of parallel processing and data architecture patterns.
提供方

Microsoft
Our goal at Microsoft is to empower every individual and organization on the planet to achieve more.
授課大綱 - 您將從這門課程中學到什麼
Design a Modern Data Warehouse using Azure Synapse Analytics
In this module, you will learn how Azure Synapse Analytics enables you to build Data Warehouses using modern architecture patterns.
Design a multidimensional schema to optimize analytical workloads
In this module, you will learn about how the common schema is implemented in a data warehouse.
Data loading and querying in Azure Synapse Analytics
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.
Integrating pools and developer tools in Azure Synapse Analytics
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.
關於 Microsoft Azure Data Engineering Associate (DP-203) 專業證書
This Professional Certificate is intended for data engineers and developers who want to demonstrate their expertise in designing and implementing data solutions that use Microsoft Azure data services anyone interested in preparing for the Exam DP-203: Data Engineering on Microsoft Azure. This Professional Certificate will help you develop expertise in designing and implementing data solutions that use Microsoft Azure data services. You will learn how to integrate, transform, and consolidate data from various structured and unstructured data systems into structures that are suitable for building analytics solutions that use Microsoft Azure data services. This program consists of 10 courses to help prepare you to take Exam DP-203: Data Engineering on Microsoft Azure. Each course teaches you the concepts and skills that are measured by the exam. By the end of this Professional Certificate, you will be ready to take and sign-up for the Exam DP-203: Data Engineering on Microsoft Azure.

常見問題
我什么时候能够访问课程视频和作业?
我订阅此专项课程后会得到什么?
有助学金吗?
還有其他問題嗎?請訪問 學生幫助中心。