Operational Analytics with Microsoft Azure Synapse Analytics

Give your career the gift of Coursera Plus with $160 off, billed annually. Save today.

Operational Analytics with Microsoft Azure Synapse Analytics

This course is part of Microsoft Azure Data Engineering Associate (DP-203) Professional Certificate

Instructor: Microsoft

5,870 already enrolled

Included with Coursera Plus

Learn more

4 modules

Gain insight into a topic and learn the fundamentals.

4.4

(26 reviews)

Intermediate level

Recommended experience

11 hours to complete

3 weeks at 3 hours a week

Flexible schedule

Learn at your own pace

4 modules

Gain insight into a topic and learn the fundamentals.

4.4

(26 reviews)

Intermediate level

Recommended experience

11 hours to complete

3 weeks at 3 hours a week

Flexible schedule

Learn at your own pace

What you'll learn

How to perform operational analytics against Azure Cosmos DB using the Azure Synapse Link feature within Azure Synapse Analytics
How to query Azure Cosmos DB with SQL Serverless/Apache Spark for Azure Synapse Analytics
How to configure and enable Azure Synapse Link to interact with Azure Cosmos DB
How to use hybrid transactional and analytical processing to perform operational analytics with Azure Synapse Analytics

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

7 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Build your Data Analysis expertise

This course is part of the Microsoft Azure Data Engineering Associate (DP-203) Professional Certificate

When you enroll in this course, you'll also be enrolled in this Professional Certificate.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Microsoft

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

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

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.

What's included

8 videos3 readings1 assignment1 discussion prompt

8 videosTotal 21 minutes

Introduction to the course3 minutesPreview module
Understand hybrid transactional and analytical processing patterns4 minutes
Describe the supported analytical workloads1 minute
Explain HTAP scenarios in the context of Synapse Link2 minutes
Describe the analytical store4 minutes
Design schemas to support type of analytics3 minutes
Design writeback scenarios0 minutes
Lesson summary0 minutes

3 readingsTotal 25 minutes

Course syllabus10 minutes
How to be successful in this course5 minutes
Understand well defined schemas10 minutes

1 assignmentTotal 15 minutes

Knowledge check15 minutes

1 discussion promptTotal 10 minutes

Meet and greet10 minutes

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.

What's included

2 videos5 readings2 assignments

2 videosTotal 2 minutes

Lesson introduction1 minutePreview module
Lesson summary0 minutes

5 readingsTotal 125 minutes

Enable Cosmos DB account to use Azure Synapse Link5 minutes
Create an analytical store enabled container30 minutes
Implement Synapse Link for Cosmos DB30 minutes
Validate connectivity from Spark30 minutes
Validate connectivity from SQL Serverless30 minutes

2 assignmentsTotal 33 minutes

Test prep18 minutes
Knowledge check15 minutes

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.

What's included

4 videos11 readings3 assignments

4 videosTotal 3 minutes

Lesson introduction1 minutePreview module
Summary0 minutes
Lesson introduction0 minutes
Lesson summary0 minutes

11 readingsTotal 330 minutes

Query the Azure Cosmos DB analytical store30 minutes
Perform simple aggregations with analytical store data30 minutes
Perform cross container queries in Azure Cosmos DB30 minutes
Perform complex queries with JSON data30 minutes
Work with the windowing function and other aggregations30 minutes
Write data back to the Azure Cosmos DB transactional store30 minutes
Read data from the transactional store30 minutes
Write basic queries against a single container30 minutes
Perform cross container queries30 minutes
Perform complex queries with JSON data30 minutes
Work with windowing functions and other aggregations30 minutes

3 assignmentsTotal 72 minutes

Test prep24 minutes
Knowledge check18 minutes
Knowledge check30 minutes

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.

What's included

2 videos2 readings1 assignment1 discussion prompt

Instructor

Microsoft

196 Courses1,047,818 learners

Offered by

Microsoft

Recommended if you're interested in Data Analysis

Microsoft
Connect Your Services with Microsoft Azure Service Bus
Course
Microsoft
Microsoft Azure SQL
Course
ESSEC Business School
Strategic Business Analytics
Specialization
EDUCBA
Automation and Optimization in Azure
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 26

4.4

26 reviews

5 stars
61.53%
4 stars
23.07%
3 stars
11.53%
2 stars
3.84%
1 star
0%

Reviewed on Sep 16, 2024

View more reviews

New to Data Analysis? Start here.

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

If you subscribed, you get a 7-day free trial during which you can cancel at no penalty. After that, we don’t give refunds, but you can cancel your subscription at any time. See our full refund policy.

Operational Analytics with Microsoft Azure Synapse Analytics

What you'll learn

Skills you'll gain

Details to know

See how employees at top companies are mastering in-demand skills

Build your Data Analysis expertise

Earn a career certificate

There are 4 modules in this course

Design hybrid transactional and analytical processing using Azure Synapse Analytics

What's included

Configure Azure Synapse Link with Azure Cosmos DB

What's included

Query Azure Cosmos in Azure Synapse Analytics

What's included

Practice exam on working with hybrid transactional and analytical processing solutions using Azure Synapse Analytics

What's included

Instructor

Offered by

Recommended if you're interested in Data Analysis

Connect Your Services with Microsoft Azure Service Bus

Microsoft Azure SQL

Strategic Business Analytics

Automation and Optimization in Azure

Why people choose Coursera for their career

Learner reviews

New to Data Analysis? Start here.

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

When will I have access to the lectures and assignments?

What will I get if I subscribe to this Certificate?

What is the refund policy?

More questions