This course teaches developers how to create applications using the SQL API and SDK of Azure Cosmos DB. Students will learn how to write effective queries, create indexes policies, manage and provision resources while performing common tasks using SDK.
You will learn how to:
- Create and configure an SQL API account, database, and container for Azure Cosmos DB.
- Use the .NET SDK to manage resources and implement functions.
- Create different queries.
- Design a data model and partitioning strategy.
- Optimize queries and indexes based on application performance.
- Use Azure Resource Manager to manage accounts and resources from the command line, with JSON or Bicep templates.Ā
Implementation: Class, Online
Length: 4 days
Starting dates: Ask for details: sales@sulava.com
Material: Microsoft English Material (MOC)
Audience profileSoftware engineers tasked with building 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. Application developers have experience with applications that interact with SQL and NoSQL platforms.Ā
WhyThis course prepares you for theĀ certification examĀ DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DBĀ to obtainĀ the Azure Cosmos DB Developer Specialty Certificate.Ā
Prerequisites
- Knowledge of Microsoft Azure and ability to navigate the Azure portal (AZ-900: Microsoft Azure Fundamentals 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)
Course contentModule 1: Get started with Azure Cosmos DB SQL APIĀ
- Introduction to Azure Cosmos DB SQL APIĀ
- Try Azure Cosmos DB SQL APIĀ
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Ā