microsoft partner logo color
8173  Reviews star_rate star_rate star_rate star_rate star_half

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

This course teaches developers how to create application using the NoSQL API and SDK for Azure Cosmos DB. Students will learn how to write efficient queries, create indexing policies, manage and...

Read More
$2,595 USD GSA  $1,960.96
Course Code DP-420T00
Duration 4 days
Available Formats Classroom

This course teaches developers how to create application using the NoSQL 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 for NoSQL 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.

Skills Gained

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

Prerequisites

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 Details

Outline

  • Introduction to Azure Cosmos DB for NoSQL
    • What is Azure Cosmos DB for NoSQL
    • How does Azure Cosmos DB for NoSQL work
    • When should you use Azure Cosmos DB for NoSQL
    • Knowledge check
  • Try Azure Cosmos DB for NoSQL
    • Explore resources
    • Review basic operations
    • Exercise: Create an Azure Cosmos DB for NoSQL account
    • Knowledge check
  • Plan Resource Requirements
    • Understand throughput
    • Evaluate throughput requirements
    • Evaluate data storage requirements
    • Time-to-live (TTL)
    • Plan for data retention with time-to-live (TTL)
    • Knowledge check
  • Configure Azure Cosmos DB for NoSQL
    • Serverless
    • Compare serverless vs. provisioned throughput
    • Autoscale throughput
    • Compare autoscale vs. standard (manual) throughput
    • Migrate between standard (manual) and autoscale throughput
    • Exercise: Configure throughput for Azure Cosmos DB for NoSQL with the Azure portal
    • Knowledge check
  • Move data into and out of Azure Cosmos DB for NoSQL
    • Move data by using Azure Data Factory
    • Move data by using a Kafka connector
    • Move data by using Stream Analytics
    • Move data by using the Azure Cosmos DB Spark connector
    • Exercise: Migrate existing data using Azure Data Factory
    • Knowledge check
  • Use the Azure Cosmos DB for NoSQL SDK
    • Understand the SDK
    • Import from package manager
    • Connect to an online account
    • Implement client singleton
    • Configure connectivity mode
    • Exercise: Connect to Azure Cosmos DB for NoSQL with the SDK
    • Knowledge check
  • Configure the Azure Cosmos DB for NoSQL SDK
    • Enable offline development
    • Handle connection errors
    • Implement threading and parallelism
    • Configure logging
    • Exercise: Configure the Azure Cosmos DB for NoSQL SDK for offline development
    • Knowledge check
  • Implement Azure Cosmos DB for NoSQL point operations
    • Understand point operations
    • Create documents
    • Read a document
    • Update documents
    • Configure time-to-live (TTL) value for a specific document
    • Delete documents
    • Exercise: Create and update documents with the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Perform cross-document transactional operations with the Azure Cosmos DB for NoSQL
    • Create a transactional batch with the SDK
    • Review batch operation results with the SDK
    • Exercise: Batch multiple point operations together with the Azure Cosmos DB for NoSQL SDK
    • Implement optimistic concurrency control
    • Knowledge check
  • Process bulk data in Azure Cosmos DB for NoSQL
    • Create bulk operations with the SDK
    • Review bulk operation caveats
    • Implement bulk best practices
    • Exercise: Move multiple documents in bulk with the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Query the Azure Cosmos DB for NoSQL
    • Understand NoSQL query language
    • Create queries with NoSQL
    • Project query results
    • Implement type-checking in queries
    • Use built-in functions
    • Execute queries in the SDK
    • Exercise: Execute a query with the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Author complex queries with the Azure Cosmos DB for NoSQL
    • Create cross-product queries
    • Implement correlated subqueries
    • Implement variables in queries
    • Paginate query results
    • Exercise: Paginate cross-product query results with the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Define indexes in Azure Cosmos DB for NoSQL
    • Understand indexes
    • Understand indexing policies
    • Review indexing policy strategies
    • Exercise: Review the default index policy for an Azure Cosmos DB for NoSQL container with the portal
    • Knowledge check
  • Customize indexes in Azure Cosmos DB for NoSQL
    • Customize the indexing policy
    • Evaluate composite indexes
    • Exercise: Configure an Azure Cosmos DB for NoSQL container's index policy with the portal
    • Knowledge check
  • Consume an Azure Cosmos DB for NoSQL change feed using the SDK
    • Understand change feed features in the SDK
    • Implement a delegate for the change feed processor
    • Implement the change feed processor
    • Implement the change feed estimator
    • Exercise: Process change feed events using the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Handle events with Azure Functions and Azure Cosmos DB for NoSQL change feed
    • Understand Azure Function bindings for Azure Cosmos DB for NoSQL
    • Configure function bindings
    • Develop function
    • Exercise: Process Azure Cosmos DB for NoSQL data using Azure Functions
    • Knowledge check
  • Search Azure Cosmos DB for NoSQL data with Azure Cognitive Search
    • Create an indexer for data in Azure Cosmos DB for NoSQL
    • Implement a change detection policy
    • Manage a data deletion detection policy
    • Exercise - Search data using Azure Cognitive Search and Azure Cosmos DB for NoSQL
    • Knowledge check
  • Implement a non-relational data model
    • What's the difference between NoSQL and relational databases?
    • Identify access patterns for your app
    • When to embed or reference data
    • Exercise: Measure performance for customer entities
    • Choose a partition key
    • Model small lookup entities
    • Knowledge check
  • Design a data partitioning strategy
    • Denormalize data in your model
    • Manage referential integrity by using change feed
    • Combine multiple entities in the same container
    • Denormalize aggregates in the same container
    • Finalize the data model
    • Exercise advanced modeling patterns
    • Knowledge check
  • Configure replication and manage failovers in Azure Cosmos DB
    • Understand replication
    • Distribute data across regions
    • Evaluate the cost of distributing data globally
    • Define automatic failover policies
    • Perform manual failovers
    • Configure SDK region
    • Exercise: Connect different regions with the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Use consistency models in Azure Cosmos DB for NoSQL
    • Understand consistency models
    • Configure default consistency model in the portal
    • Change consistency model with the SDK
    • Use session tokens
    • Exercise: Configure consistency models in the portal and the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Configure multi-region write in Azure Cosmos DB for NoSQL
    • Understand multi-region write
    • Configure multi-region support in the SDK
    • Understand conflict resolution policies
    • Create custom conflict resolution policy
    • Exercise: Connect multi-region write account with the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Customize an indexing policy in Azure Cosmos DB for NoSQL
    • Index usage
    • Review read-heavy index patterns
    • Review write-heavy index patterns
    • Exercise - Optimize an Azure Cosmos DB for NoSQL container's index policy for common operations
    • Knowledge check
  • Measure index performance in Azure Cosmos DB for NoSQL
    • Enable indexing metrics
    • Analyze indexing metrics results
    • Measure query cost
    • Measure point operation cost
    • Exercise - Optimize an Azure Cosmos DB for NoSQL container's index policy for a specific query
    • Knowledge check
  • Implement integrated cache in Azure Cosmos DB for NoSQL
    • Review workloads that benefit from the cache
    • Enable integrated cache
    • Configure cache staleness
    • Knowledge check
  • Measure performance in Azure Cosmos DB for NoSQL
    • Understand Azure Monitor
    • Measure throughput
    • Observe rate-limiting events
    • Query logs
    • Exercise: Use Azure Monitor to analyze an Azure Cosmos DB for NoSQL account
    • Knowledge check
  • Monitor responses and events in Azure Cosmos DB for NoSQL
    • Review common response codes
    • Understand transient errors
    • Review rate-limiting errors
    • Configure Alerts
    • Audit security
    • Exercise: Troubleshoot an application using the Azure Cosmos DB for NoSQL SDK
    • Knowledge check
  • Implement backup and restore for Azure Cosmos DB for NoSQL
    • Evaluate periodic backup
    • Configure continuous backup and recovery
    • Perform a point-in-time recovery
    • Exercise - Recover a database or container from a recovery point
    • Knowledge check
  • Implement security in Azure Cosmos DB for NoSQL
    • Implement network-level access control
    • Review data encryption options
    • Use role-based access control (RBAC)
    • Access account resources using Microsoft Entra ID
    • Understand Always Encrypted
    • Exercise: Store Azure Cosmos DB for NoSQL account keys in Azure Key Vault
    • Knowledge check
  • Write management scripts for Azure Cosmos DB for NoSQL
    • Create resources
    • Manage index policies
    • Configure database or container-provisioned throughput
    • Migrate between standard and autoscale throughput
    • Change region failover priority
    • Initiate failovers
    • Exercise: Adjust provisioned throughput using an Azure CLI script
    • Knowledge check
  • Create resource template for Azure Cosmos DB for NoSQL
    • Understand Azure Resource Manager resources
    • Author Azure Resource Manager templates
    • Configure database or container resources
    • Configure throughput with an Azure Resource Manager template
    • Manage index policies through Azure Resource Manager templates
    • Exercise: Create an Azure Cosmos DB for NoSQL container using Azure Resource Manager templates
    • Knowledge check
  • Build multi-item transactions with the Azure Cosmos DB for NoSQL
    • Understand transactions in the context of JavaScript SDK
    • Author Stored procedures
    • Rollback transactions
    • Create stored procedures with the JavaScript SDK
    • Exercise: Create a stored procedure with the Azure portal
    • Knowledge check
  • Expand query and transaction functionality in Azure Cosmos DB for NoSQL
    • Create user-defined functions
    • Create user-defined functions with the SDK
    • Add triggers to an operation
    • Create and use triggers with the SDK
    • Exercise: Implement and use user defined functions with the Azure Cosmos DB SDK
    • Knowledge check