CloudTeam

Main menu

Contact

Choose your language

TrainingData & analytics / Data & AIDP-420

DP-420Microsoft · authorised trainingLeads to an exam

Build AI applications with Azure Cosmos DB

This course teaches developers how to create applications using the NoSQL API and SDK for Azure Cosmos DB. Participants learn how to design, build and optimise high-performance, scalable AI applications with Azure Cosmos DB. The course covers, among other things, writing efficient queries, defining indexing policies, managing and provisioning resources, and performing common operations with the SDK.

Duration
4 days
Level
Intermediate
Provider
Microsoft
Topic
Data & analytics / Data & AI

Course outline

  • Introduction to Azure Cosmos DB SQL API
  • Try Azure Cosmos DB SQL API
  • Lab: Exercise: Create an Azure Cosmos DB SQL API account
  • 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
  • Use the Azure Cosmos DB SQL API SDK
  • Configure the Azure Cosmos DB SQL API SDK
  • 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
  • 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
  • Query the Azure Cosmos DB SQL API
  • Author complex queries with the Azure Cosmos DB SQL API
  • 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
  • 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
  • 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: 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
  • 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
  • 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: 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
  • 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
  • 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: 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
  • 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
  • Build multi-item transactions with the Azure Cosmos DB SQL API
  • Expand query and transaction functionality in Azure Cosmos DB SQL API
  • Lab: Exercise: Implement and then use a UDF using the SDK
  • Lab: Exercise: Create a stored procedure with the Azure Portal

Skills you will gain

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

Who should attend

  • Software engineers building cloud-native solutions with Azure Cosmos DB for NoSQL and its SDKs
  • Developers familiar with C#, Python, Java or JavaScript
  • Developers experienced in writing code that interacts with SQL or NoSQL databases

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)

Certification

Exam

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

This course prepares you for this exam.

Exam details