Optimize query and operation performance in Azure Cosmos DB SQL API

Go to class
Write Review

Free Online Course: Optimize query and operation performance in Azure Cosmos DB SQL API provided by Microsoft Learn is a comprehensive online course, which lasts for 1-2 hours worth of material. The course is taught in English and is free of charge.

Overview
    • Module 1: Tune the indexing policy based on your SQL queries in Azure Cosmos DB SQL API.
    • After completing this module, you'll be able to:

      • Customize an indexing policy for read-heavy workloads
      • Customize an indexing policy for write-heavy workloads
    • Module 2: Measure the performance of an indexing policy in Azure Cosmos DB SQL API.
    • After completing this module, you'll be able to:

      • Tune an indexing policy for specific queries
      • Measure the cost for a query or operation
    • Module 3: Implement, configure, and monitor integrated cache in Azure Cosmos DB SQL API.
    • After completing this module, you'll be able to:

      • Implement the integrated cache
      • Configure integrated cache options

Syllabus
    • Module 1: Customize an indexing policy in Azure Cosmos DB SQL API
      • Introduction
      • Index usage
      • Review read-heavy index patterns
      • Review write-heavy index patterns
      • Exercise - Optimize an Azure Cosmos DB SQL API container's index policy for common operations
      • Knowledge check
      • Summary
    • Module 2: Measure index performance in Azure Cosmos DB SQL API
      • Introduction
      • Enable indexing metrics
      • Analyze indexing metrics results
      • Measure query cost
      • Measure point operation cost
      • Exercise - Optimize an Azure Cosmos DB SQL API container's index policy for a specific query
      • Knowledge check
      • Summary
    • Module 3: Implement integrated cache in Azure Cosmos DB SQL API
      • Introduction
      • Review workloads that benefit from the cache
      • Enable integrated cache
      • Configure cache staleness
      • Knowledge check
      • Summary