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

Offered By: Microsoft via Microsoft Learn

Tags

Microsoft Azure Courses Data Analysis Courses Apache Spark Courses Azure Cosmos DB Courses Azure Synapse Analytics Courses Schema Design Courses Data Aggregation Courses

Course Description

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

Tags

united states

Related Courses

Crea un app de Machine Learning con Spark, Synapse Analytics
Coursera Project Network via Coursera Working with Relational Data Stores in Azure
Coursera Project Network via Coursera Trabajando con Azure Synapse Analytics
Coursera Project Network via Coursera Bases de Datos SQL en Azure
Coursera Project Network via Coursera Microsoft Future Ready: Azure Cloud Fundamentals
Cloudswyft via FutureLearn