Operational Analytics with Microsoft Azure Synapse Analytics
In this course, you will learn how to perform operational analytics against Azure Cosmos DB using the Azure Synapse Link feature within Azure Synapse Analytics. You will learn how hybrid transactional and analytical processing can help you perform operational analytics with Azure Synapse Analytics.
Monthly Subscription Starting at AED 99 + VAT
- Level Professional
- Duration 12 hours
- Course by Microsoft
-
Offered by
About
In this course, you will learn how to perform operational analytics against Azure Cosmos DB using the Azure Synapse Link feature within Azure Synapse Analytics. You will learn how hybrid transactional and analytical processing can help you perform operational analytics with Azure Synapse Analytics. You will also learn how to configure and enable Azure Synapse Link to interact with Azure Cosmos DB and how you can perform analytics against Azure Cosmos DB using Azure Synapse Link. 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).Modules
Welcome to the course
-
1
Videos
-
2
Readings
-
1
Discussion
1
Discussions
- Meet and greet
1
Videos
- Introduction to the course
2
Readings
- Course syllabus
- How to be successful in this course
Hybrid transactional and analytical processing using Azure Synapse Analytics
-
7
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Knowledge check
7
Videos
- Understand hybrid transactional and analytical processing patterns
- Describe the supported analytical workloads
- Explain HTAP scenarios in the context of Synapse Link
- Describe the analytical store
- Design schemas to support type of analytics
- Design writeback scenarios
- Lesson summary
1
Readings
- Understand well defined schemas
Make operational data stored in Azure Cosmos DB available for analytical query
-
2
Videos
-
5
Readings
-
2
Assignment
2
Assignment
- Knowledge check
- Test prep
2
Videos
- Lesson introduction
- Lesson summary
5
Readings
- Enable Cosmos DB account to use Azure Synapse Link
- Create an analytical store enabled container
- Implement Synapse Link for Cosmos DB
- Validate connectivity from Spark
- Validate connectivity from SQL Serverless
Query Azure Cosmos DB with Apache Spark for Azure Synapse Analytics
-
2
Videos
-
7
Readings
-
1
Assignment
1
Assignment
- Knowledge check
2
Videos
- Lesson introduction
- Summary
7
Readings
- Query the Azure Cosmos DB analytical store
- Perform simple aggregations with analytical store data
- Perform cross container queries in Azure Cosmos DB
- Perform complex queries with JSON data
- Work with the windowing function and other aggregations
- Write data back to the Azure Cosmos DB transactional store
- Read data from the transactional store
Query Azure Cosmos DB with SQL Serverless for Azure Synapse Analytics
-
2
Videos
-
4
Readings
-
2
Assignment
2
Assignment
- Knowledge check
- Test prep
2
Videos
- Lesson introduction
- Lesson summary
4
Readings
- Write basic queries against a single container
- Perform cross container queries
- Perform complex queries with JSON data
- Work with windowing functions and other aggregations
Course Practice Exam
-
1
Videos
-
1
Readings
-
1
Assignment
1
Assignment
- Course practice exam
1
Videos
- Course recap
1
Readings
- About the practice exam
Course Wrap Up
-
1
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Reflect on learning
1
Videos
- Course summary
1
Readings
- Next steps
Auto Summary
Unlock the power of big data and analytics with the "Operational Analytics with Microsoft Azure Synapse Analytics" course, designed to elevate your expertise in Azure data services. This comprehensive program, offered by Coursera, dives deep into performing operational analytics on Azure Cosmos DB using the innovative Azure Synapse Link. Guided by industry expert instructors, you will explore hybrid transactional and analytical processing techniques, learn to configure and enable Azure Synapse Link, and perform advanced analytics on Azure Cosmos DB. This course is an integral part of a meticulous 10-course specialization aimed at data engineers and developers aspiring to excel in designing and implementing sophisticated data solutions with Microsoft Azure. Spanning 720 minutes of intensive, hands-on learning, this professional-level course is your gateway to mastering the skills necessary for the Exam DP-203: Data Engineering on Microsoft Azure. It includes a practice exam to ensure you're well-prepared to showcase your capabilities in integrating, transforming, and consolidating data from diverse sources for robust analytics solutions. Available through flexible subscription options, this course is tailored for those committed to advancing their career in data engineering and analytics. By the end of this specialization, you will be equipped and ready to sign up for the certification exam, marking your proficiency in utilizing Microsoft Azure data services.
Microsoft