Work with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Module 1: Design hybrid transactional and analytical processing using Azure Synapse Analytics

After completing this module, you'll be able to:

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
Understand well defined schemas
Design schemas to support type of analytics
Design writeback scenarios

Module 2: Configure Azure Synapse Link with Azure Cosmos DB

After completing this module, you'll be able to:

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

Module 3: Query Azure Cosmos DB with Apache Spark for Azure Synapse Analytics

After completing this module, you'll be able to:

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

Module 4: Query Azure Cosmos DB with SQL Serverless for Azure Synapse Analytics

After completing this module, you'll be able to:

Write basic queries against a single container
Perform cross dataset queries in Cosmos DB
Work with windowing function
Perform complex queries with JSON data