Work with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics
- Offered byMicrosoft
Work with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics at Microsoft Overview
Duration | 3 hours |
Total fee | Free |
Mode of learning | Online |
Schedule type | Self paced |
Difficulty level | Intermediate |
Official Website | Explore Free Course  |
Credential | Certificate |
Work with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics at Microsoft Course details
- Design hybrid transactional and analytical processing using Azure Synapse Analytics
- Configure Azure Synapse Link with Azure Cosmos DB
- Query Azure Cosmos DB with Apache Spark for Azure Synapse Analytics
- Query Azure Cosmos DB with SQL Serverless for Azure Synapse Analytics
- Learn how hybrid transactional and analytical processing can help you perform operational analytics
- Know how to configure and enable Azure Synapse Link to interact with Azure Cosmos DB
- Learn how you can perform analytics against Azure Cosmos DB using Azure Synapse Link
Work with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics at Microsoft Curriculum
MODULE:1 Design hybrid transactional and analytical processing using Azure Synapse Analytics
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
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
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
Write basic queries against a single container
Perform cross container queries
Perform complex queries with JSON data
Work with windowing functions and other aggregations
Work with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics at Microsoft Entry Requirements
- Prerequisites: It is recommended that students have completed Data Fundamentals
- Not mentioned
Other courses offered by Microsoft
Student Forum
Anything you would want to ask experts?
ManagementBusiness AnalyticsData AnalysisWork with Hybrid Transactional and Analytical Processing Solutions using Azure Synapse Analytics