Operational Analytics with Microsoft Azure Synapse Analytics (Coursera)

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). You will take a practice exam that covers key skills measured by the certification exam.
This is the seventh 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).

What You Will Learn

• You will learn how to perform operational analytics against Azure Cosmos DB using the Azure Synapse Link feature within Azure Synapse Analytics.

Course 7 of 10 in the Microsoft Azure Data Engineering Associate DP-203 Exam Prep Specialization.

Syllabus

WEEK 1
Design hybrid transactional and analytical processing using Azure Synapse Analytics
After completing this module, you will be able to describe how hybrid transactional and analytical processing can help you perform operation analytics with Azure Synapse Analytics. During the module you will develop an understanding of transaction and processing patterns, analytical workloads, and learn how to design schemas and writeback scenarios.

WEEK 2
Configure Azure Synapse Link with Azure Cosmos DB
In this module you will learn how to configure and enable Azure Synapse Link to interact with Azure Cosmos Database. This includes creating a Cosmos database account and an analytical store enabled container, implementing Synapse Link, and validating connectivity.

WEEK 3
Query Azure Cosmos in Azure Synapse Analytics
In this module, you will learn how to perform analytics against Azure Cosmos Database using Azure Synapse Link and the Synapse Serverless SQL. During the module you will explore how to perform a range of queries, work with aggregations such as the windowing function, and read and write data to and from transactional stores.

WEEK 4
Practice exam on working with hybrid transactional and analytical processing solutions 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. After completing this module, you will be able to prepare for the Microsoft Certified: Azure Data Engineer Associate exam.