- 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