Design hybrid transactional and analytical processing using Azure Synapse Analytics-Welcome to the course
Introduction to the course
()
Course syllabus
How to be successful in this course
Design hybrid transactional and analytical processing using Azure Synapse Analytics-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
()
Lesson summary
()
Configure Azure Synapse Link with Azure Cosmos DB-Make operational data stored in Azure Cosmos DB available for analytical query
Lesson 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
Lesson summary
()
Query Azure Cosmos in Azure Synapse Analytics-Query Azure Cosmos DB with Apache Spark for Azure Synapse Analytics
Lesson 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
Summary
()
Query Azure Cosmos in Azure Synapse Analytics-Query Azure Cosmos DB with SQL Serverless for Azure Synapse Analytics
Lesson 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
Lesson summary
()
Practice exam on working with hybrid transactional and analytical processing solutions using Azure Synapse Analytics-Course Practice Exam
Course recap
()
About the practice exam
Practice exam on working with hybrid transactional and analytical processing solutions using Azure Synapse Analytics-Course Wrap Up
Course summary
()
Next steps