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, Class (in Finnish), Online (in Finnish)
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Â