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.
Manage, optimize and secure a data warehouse
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.
Practice Exam on Work with Data Warehouses using Azure Synapse Analytics
In this module, you will take a practice exam that covers key skills measured in the Exam DP-203: Data Engineering on Microsoft Azure.