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

Type
Virtual
Classroom ILT
Skill Level

Available dates
Learning Path
Virtual
Duration
1 Day

TYPE
Virtual
Classroom ILT
LEARNING PATH
SKILL LEVEL

DURATION
AVAILABLE DATES
Choose date
R9 700,00
Price excluding VAT
Introduction:
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.
Audience profile:
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.
Job role: Developer
Pre-requisites:
Before attending this course, students must have:
- 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)
Course Objectives:
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
Course content
Module 1: Get started with Azure Cosmos DB SQL API |
Modern apps thrive on real-time data from different sources and shaped in different forms. These apps require a modern database that can handle the variety and velocity of data that will be thrown at it. In this module, we will explore Azure Cosmos DB and how the SQL API can solve some of the problems presented by modern applications.
Lessons: |
|
Lab: Exercise: Create an Azure Cosmos DB SQL API account |
After completing this module, students will be able to: |
|
Module 2: Plan and implement Azure Cosmos DB SQL API |
Creating a new Azure Cosmos DB account often requires making a lot of configuration choices that can, at first, be daunting. While the defaults fit a lot of scenarios, it makes the most sense to familiarize yourself with the configuration options to ensure that your account and resources are optimally configured for your solution. In this module, you will learn how to prepare and configure an Azure Cosmos DB account and resources for a new solution.
Lessons: |
|
Lab: Exercise: Configure throughput for Azure Cosmos DB SQL API with the Azure portal
Lab: Exercise: Migrate existing data using Azure Data Factory |
After completing this module, students will be able to |
|
Module 3: Connect to Azure Cosmos DB SQL API with the SDK |
There are various SDKs available to connect to the Azure Cosmos DB SQL API from many popular programming languages including, but not limited to .NET (C#), Java, Python, and JavaScript (Node.js). In this module, you will get hands-on with with the .NET SDK for the Azure Cosmos DB SQL API.
Lessons: |
|
Lab: Exercise: Configure the Azure Cosmos DB SQL API SDK for offline development
Lab: Exercise: Connect to Azure Cosmos DB SQL API with the SDK |
After completing this module, you will be able to: |
|
Module 4: Access and manage data with the Azure Cosmos DB SQL API SDKs |
The SQL API SDK for Azure Cosmos DB is used to perform various point operations, perform transactions, and to process bulk data. In this module, you will use the SDK to manipulate documents either individually or in groups.
Lessons: |
|
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 |
After completing this module, students will be able to: |
|
Module 5: Execute queries in Azure Cosmos DB SQL API |
The Azure Cosmos DB SQL API supports Structured Query Language (SQL) as a JSON query language. In this module, you will learn how to create efficient queries using the SQL query language.
Lessons: |
|
Lab: Exercise: Paginate cross-product query results with the Azure Cosmos DB SQL API SDK
Lab: Exercise: Execute a query with the Azure Cosmos DB SQL API SDK |
After completing this module, students will be able to: |
|
Module 6: Define and implement an indexing strategy for Azure Cosmos DB SQL API |
By default, Azure Cosmos DB automatically indexes all paths of documents stored using the SQL API. This is great for developing new applications as you can create complex queries almost immediately. As your application matures, you can customize your indexing policy to better match the needs of your solution. In this module, you will learn how to create a custom indexing policy.
Lessons: |
|
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 |
After completing this module, students will be able to: |
|
Module 7: Integrate Azure Cosmos DB SQL API with Azure services |
Azure Cosmos DB has tight integration available with many other Azure servicers such as Azure Functions, Azure Cognitive Search, Azure Event Hubs, Azure Storage, Azure Data Factory, and Azure Stream Analytics. Going even further, you can use the change feed to integrate Azure Cosmos DB with many other services both in and out of Azure. In this module, we will integrate Azure Cosmos DB with both Azure Functions and Azure Cognitive Search. We will also explore the change feed using the SDK.
Lessons: |
|
Lab: Exercise: Archive Azure Cosmos DB SQL API data using Azure Functions
Lab: Exercise: Process change feed events using the Azure Cosmos DB SQL API SDK Lab: Exercise: Archive data using Azure Functions and Azure Cosmos DB SQL API |
After completing this module, students will be able to: |
|
Module 8: Implement a data modeling and partitioning strategy for Azure Cosmos DB SQL API |
Azure Cosmos DB is both horizontally scalable and nonrelational. To achieve this level of scalability, users need to understand the concepts, techniques, and technologies unique to NoSQL databases for modeling and partitioning data. In this module, you will model and partition data appropriately for a NoSQL database such as Azure Cosmos DB SQL API.
Lessons: |
|
Lab: Exercise: Measure performance for customer entities
Lab: Exercise: Advanced modeling patterns |
After completing this module, students will be able to: |
|
Module 9: Design and implement a replication strategy for Azure Cosmos DB SQL API |
Today’s applications are required to be highly responsive and always online. To achieve low latency and high availability, instances of these applications need to be deployed in datacenters that are close to their users. In this module, you will explore how to replicate data and manage consistency across the globe using Azure Cosmos DB SQL API.
Lessons: |
|
Lab: Exercise: Configure consistency models in the portal and the Azure Cosmos DB SQL API SDK
Lab: Exercise: Connect to different regions with the Azure Cosmos DB SQL API SDK Lab: Exercise: Connect to a multi-region write account with the Azure Cosmos DB SQL API SDK |
After completing this module, students will be able to: |
|
Module 10: Optimize query performance in Azure Cosmos DB SQL API |
Azure Cosmos DB offers a rich set of database operations that operate on the items within a container. The cost associated with each of these operations varies based on the CPU, IO, and memory required to complete the operation. In this module, you will explore how to manage indexing policies and edit queries to minimize per-query request unit (RU) cost.
Lessons: |
|
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 |
After completing this module, students will be able to: |
|
Module 11: Administrating and Monitoring tasks for an Azure Cosmos DB SQL API solution |
When you have critical applications and business processes relying on Azure resources such as Azure Cosmos DB, you want to monitor those resources for their availability, performance, and operation. In this module, you will explore how to monitor events and performance of an Azure Cosmos DB account. You will also learn how to implement common security measures along with backup and restore in Azure Cosmos DB.
Lessons: |
|
Lab: Exercise: Troubleshoot an application using the Azure Cosmos DB SQL API SDK
Lab: Exercise: Use Azure Monitor to analyze an Azure Cosmos DB SQL API account 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 |
After completing this module, students will be able to: |
|
Module 12: Manage an Azure Cosmos DB SQL API solution using DevOps practices |
Once an Azure Cosmos DB SQL API account is ready to go through a release lifecycle, it’s not uncommon for an operations team to attempt to automate the creation of Azure Cosmos DB resources in the cloud. Automation makes it easier to deploy new environments, restore past environments, or scale a service out. In this module, you will explore how to use Azure Resource Manager to manage an Azure Cosmos DB account and its child resources using JSON templates, Bicep templates, or the Azure CLI.
Lessons: |
|
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 |
After completing this module, students will be able to: |
|
Module 13: Create server-side programming constructs in Azure Cosmos DB SQL API |
Azure Cosmos DB provides language-integrated, transactional execution of JavaScript. When using the SQL API in Azure Cosmos DB, you can write stored procedures, triggers, and user-defined functions (UDFs) in the JavaScript language. In this module, you will author JavaScript logic that executes directly inside the database engine.
Lessons: |
|
Lab: Exercise: Implement and then use a UDF using the SDK
Lab: Exercise: Create a stored procedure with the Azure Portal |
After completing this module, students will be able to: |
|
Associated certifications and exam:
This course prepares students to write Exam DP-420: Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB.
On successful completion of this course students will receive a Torque IT attendance certificate.

Microsoft Overview
Skilled Microsoft engineers add significant value to the marketplace by reducing the cost of technology solutions whilst improving efficiency and fuelling innovation. Through authorized Microsoft training, Torque IT empowers engineers, developers and end-users to realise their full potential by providing them with the necessary knowledge and skills to optimise the adoption and use of Microsoft solutions.
Torque IT considers authorised Microsoft training to be an integral part of any Microsoft implementation. Microsoft authorised training, and associated certification, ensures that you get the most from your technology investment and that you are able to operate above the technology curve. Microsoft career certifications are universally recognised as demonstrating a high level of expertise and credibility for individuals and the organisations that employ them.
Authorized Microsoft training and certification is the industry standard for any solution that includes designing, selling, implementing, upgrading, managing, and operating Microsoft solutions.
For 19 years, Torque IT has maintained the status of Gold Learning Partner for Microsoft in South Africa. This is the highest level of accreditation that Microsoft awards to Learning Partners that specialize in technical, product, sales, development, end-user and solutions training.
These achievements reflect our commitment to providing our customers with quality skills development, enablement, training, and certification solutions that demonstrate exceptional depth, breadth, and expertise across Windows Server, Windows Client, Microsoft Virtualization, Microsoft Azure, Office 365, Exchange Server, SharePoint Server, Skype for Business, System Centre Server, Visual Studio and Microsoft Office technologies.
Torque is recognized by Microsoft, and the industry, as having met rigorous standards for educational competency, service, customer satisfaction and investment in Microsoft technologies that will prepare the next generation of IT industry professionals.