Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB

After completing this course, students will be able to:

• Create and configure Azure Cosmos DB SQL API account, database, and container
• Use the .NET SDK to manage resources and perform operations
• Perform queries of varying complexity
• Design a data modeling and partitioning strategy
• Optimize queries and indexes based on characteristics of an application
• Use the Azure Resource Manager to manage accounts and resources with CLI or JSON and Bicep templates

Software engineers tasked with authoring cloud-native solutions that leverage Azure Cosmos DB SQL API and its various SDKs. They are familiar with C#, Python, Java, or JavaScript. They also have experience writing code that interacts with a SQL or NoSQL database platform.
 

Before attending this course, students must have:
• Knowledge of Microsoft Azure and ability to navigate the Azure portal
• Experience writing in an Azure-supported language at the intermediate level. (C#, JavaScript, Python, or Java)
• Ability to write code to connect and perform operations on a SQL or NoSQL database product. (SQL Server, Oracle, MongoDB, Cassandra or similar)

Module 1: Get started with Azure Cosmos DB SQL API

• Introduction to Azure Cosmos DB SQL API
• Try Azure Cosmos DB SQL API
• Lab : Exercise: Create an Azure Cosmos DB SQL API account

Module 2: Plan and implement Azure Cosmos DB SQL API

• Plan Resource Requirements
• Configure Azure Cosmos DB SQL API database and containers
• Moving data into and out of Azure Cosmos DB SQL API
• Lab : Exercise: Configure throughput for Azure Cosmos DB SQL API with the Azure portal
• Lab : Exercise: Migrate existing data using Azure Data Factory

Module 3: Connect to Azure Cosmos DB SQL API with the SDK

• Use the Azure Cosmos DB SQL API SDK
• Configure the Azure Cosmos DB SQL API SDK
• Lab : Exercise: Connect to Azure Cosmos DB SQL API with the SDK
• Lab : Exercise: Configure the Azure Cosmos DB SQL API SDK for offline development

Module 4: Access and manage data with the Azure Cosmos DB SQL API SDKs

• Implement Azure Cosmos DB SQL API point operations
• Perform cross-document transactional operations with the Azure Cosmos DB SQL API
• Process bulk data in Azure Cosmos DB SQL API
• Lab : Exercise: Create and update documents with the Azure Cosmos DB SQL API SDK
• Lab : Exercise: Batch multiple point operations together with the Azure Cosmos DB SQL API SDK
• Lab : Exercise: Move multiple documents in bulk with the Azure Cosmos DB SQL API SDK

Module 5: Execute queries in Azure Cosmos DB SQL API

• Query the Azure Cosmos DB SQL API
• Author complex queries with the Azure Cosmos DB SQL API
• Lab : Exercise: Execute a query with the Azure Cosmos DB SQL API SDK
• Lab : Exercise: Paginate cross-product query results with the Azure Cosmos DB SQL API SDK

Module 6: Define and implement an indexing strategy for Azure Cosmos DB SQL API

• Define indexes in Azure Cosmos DB SQL API
• Customize indexes in Azure Cosmos DB SQL API
• Lab : Exercise: Review the default index policy for an Azure Cosmos DB SQL API container with the portal
• Lab : Exercise: Configure an Azure Cosmos DB SQL API container's index policy with the portal

Module 7: Integrate Azure Cosmos DB SQL API with Azure services

• Consume an Azure Cosmos DB SQL API change feed using the SDK
• Handle events with Azure Functions and Azure Cosmos DB SQL API change feed
• Search Azure Cosmos DB SQL API data with Azure Cognitive Search
• Lab : Exercise: Process change feed events using the Azure Cosmos DB SQL API SDK
• Lab : Exercise: Archive Azure Cosmos DB SQL API data using Azure Functions
• Lab : Exercise: Archive data using Azure Functions and Azure Cosmos DB SQL API

Module 8: Implement a data modeling and partitioning strategy for Azure Cosmos DB SQL API

• Model and partition your data in Azure Cosmos DB
• Optimize databases by using advanced modeling patterns for Azure Cosmos DB
• Lab : Exercise: Measure performance for customer entities
• Lab : Exercise: Advanced modeling patterns

Module 9: Design and implement a replication strategy for Azure Cosmos DB SQL API

• Configure replication and manage failovers in Azure Cosmos DB
• Use consistency models in Azure Cosmos DB SQL API
• Configure multi-region write in Azure Cosmos DB SQL API
• Lab : Exercise: Connect to different regions with the Azure Cosmos DB SQL API SDK
• Lab : Exercise: Configure consistency models in the portal and the Azure Cosmos DB SQL API SDK
• Lab : Exercise: Connect to a multi-region write account with the Azure Cosmos DB SQL API SDK

Module 10: Optimize query performance in Azure Cosmos DB SQL API

• Choosing indexes in Azure Cosmos DB SQL API
• Optimize queries in Azure Cosmos DB SQL API
• Implement integrated cache
• Lab : Exercise: Optimize an Azure Cosmos DB SQL API container's index policy for common operations
• Lab : Exercise: Optimize an Azure Cosmos DB SQL API container's index policy for a specific query

Module 11: Administrating and Monitoring tasks for an Azure Cosmos DB SQL API solution

• Measure performance in Azure Cosmos DB SQL API
• Monitor responses and events in Azure Cosmos DB SQL API
• Implementing backup and restore for Azure Cosmos DB SQL API
• Implement security in Azure Cosmos DB SQL API
• Lab : Exercise: Use Azure Monitor to analyze an Azure Cosmos DB SQL API account
• Lab : Exercise: Troubleshoot an application using the Azure Cosmos DB SQL API SDK
• Lab : Exercise: Recover a database or container from a recovery point
• Lab : Exercise: Store Azure Cosmos DB SQL API account keys in Azure Key Vault

Module 12: Manage an Azure Cosmos DB SQL API solution using DevOps practices

• Write scripts for Azure Cosmos DB SQL API
• Create resource template for Azure Cosmos DB SQL API
• Lab : Exercise: Adjust provisioned throughput using an Azure CLI script
• Lab : Exercise: Create an Azure Cosmos DB SQL API container using Azure Resource Manager templates

Module 13: Create server-side programming constructs in Azure Cosmos DB SQL API

• Build multi-item transactions with the Azure Cosmos DB SQL API
• Expand query and transaction functionality in Azure Cosmos DB SQL API
• Lab : Exercise: Create a stored procedure with the Azure Portal
• Lab : Exercise: Implement and then use a UDF using the SDK