This course teaches developers how to create application using the SQL API and SDK for Azure Cosmos DB. Students will learn how to write efficient queries, create indexing policies, manage and provisioned resources, and perform common operations with the SDK.
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.
Student Testimonials
Instructor did a great job, from experience this subject can be a bit dry to teach but he was able to keep it very engaging and made it much easier to focus.
Student
Excellent presentation skills, subject matter knowledge, and command of the environment.
Student
Instructor was outstanding. Knowledgeable, presented well, and class timing was perfect.
Student
Click here to print this page »
Prerequisites
Knowledge of Microsoft Azure and ability to navigate the Azure portal (AZ-900 equivalent)
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)
Detailed Class Syllabus
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
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
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
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
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
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
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
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
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
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
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
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