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

0
Microsoft Learn
Free Online Course
English
2-3 hours worth of material
selfpaced

Overview

  • 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

Syllabus

  • Module 1: Design hybrid transactional and analytical processing using Azure Synapse Analytics
    • 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
  • Module 2: Configure Azure Synapse Link with Azure Cosmos DB
    • 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
  • Module 3: Query Azure Cosmos DB with Apache Spark for Azure Synapse Analytics
    • 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
  • Module 4: Query Azure Cosmos DB with SQL Serverless for Azure Synapse Analytics
    • 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