Data Warehousing with Microsoft Azure Synapse Analytics

0
Join & Subscribe
Coursera
Free Online Course (Audit)
English
Paid Certificate Available
6 weeks long, 15 hours worth of material
selfpaced

Overview

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).

Syllabus

  • 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.

Taught by

Microsoft