Work with Hybrid Transactional and Analytical Processing Solutions 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

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

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

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

• Introduction
• 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
• Knowledge check
• Summary

• Introduction
• 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
• Knowledge check
• Summary

• Introduction
• 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
• Knowledge check
• Summary

• Introduction
• Write basic queries against a single container
• Perform cross container queries
• Perform complex queries with JSON data
• Work with windowing functions and other aggregations
• Knowledge check
• Summary