DP-3015: Getting Started with Cosmos DB NoSQL Development

Course: DP-3015 Getting Started with Cosmos DB NoSQL Development

This course teaches developers how to use the Azure Cosmos DB for NoSQL API and SDK . Students will learn how to run queries, configure resources, perform SDK operations, and design strategies for non-relational data modeling and data partitioning.

Intermediate - Azure - Developer

Addressed to

Software engineers responsible for building cloud-native solutions that leverage Azure Cosmos DB for NoSQL and its various SDKs. They are familiar with C# programming and have experience writing code that interacts with SQL and NoSQL database platforms.

Objectives of the DP-3015 training

• Evaluate whether Azure Cosmos DB for NoSQL is the right database for the application.
• Describe why the features of Azure Cosmos DB for NoSQL are suitable for modern applications.

Course content DP-3015

Module 1: Introduction to Azure Cosmos DB for NoSQL

• What is Azure Cosmos DB for NoSQL
• How Azure Cosmos DB for NoSQL works
• When should you use Azure Cosmos DB for NoSQL

Module 2: Testing Azure Cosmos DB for NoSQL

• Resource exploration
• Review of basic operations
• Exercise: Creating an Azure Cosmos DB for NoSQL account

Module 3 Planning the necessary resources

• Performance description
• Performance requirements assessment
• Assessment of data storage requirements
• Time to Life (TTL)
• Data retention planning with a time-to-life (TTL) period

Module 4: Configuring an Azure Cosmos DB for NoSQL database and containers

• Comparison between provisioned and serverless performance
  
• Automatic performance scalability
  
• Comparison between standard (manual) performance and automatic scalability performance
  
• Migration between standard (manual) performance and automatic scalability performance
  
• Exercise: Configuring performance for the Azure Cosmos DB SQL API using the Azure Portal

Module 5: Configuring the Azure Cosmos DB for NoSQL SDK

• SDK Description
• Import from the package manager
• Connecting to an online account
• Client singleton implementation
• Connectivity mode settings
• Exercise: Connecting to Azure Cosmos DB for NoSQL with the SDK

Module 6: Implementing Azure Cosmos DB for NoSQL point operations

• Description of point operations
  
• Document creation
  
• Reading a document
  
• Document Update
  
• Setting the Time to Live (TTL) value for a specific document
  
• Document Deletion
  
• Exercise: Creating and updating documents with the Azure Cosmos DB for NoSQL SDK

Module 7: Azure Cosmos DB for NoSQL Query

• Description of the SQL query language
• Creating queries with SQL
• Projecting query results
  
• Implementation of type checking queries
  
• Use of built-in functions
  
• Running queries in the SDK
  
• Exercise: Executing a query with the Azure Cosmos DB for NoSQL SDK

Module 8: Creating complex queries with Azure Cosmos DB for NoSQL

• Creating cross-product queries
  
• Implementation of correlated subqueries
  
• Implementation of variables in queries
  
• Pagination of query results
  
• Exercise: Pagination of cross-product query results using the Azure Cosmos DB for NoSQL SDK

Module 9: Implementing a non-relational data model

• What is the difference between NoSQL and relational databases?
  
• Identifying access patterns for the application
  
• When to insert or reference data
  
• Exercise: Measuring the performance of client entities
  
• Choose a partition key
  
• Modeling small search entities

Module 10: Designing a data partitioning strategy

• Data denormalization in the model
  
• Managing referential integrity through the change source
  
• Combining multiple entities in the same container
  
• Denormalization of aggregates in the same container
  
• Data model completion
  
• Advanced modeling pattern exercise

Prerequisites

• Previous experience in programming with C#
• Knowledge of SQL and NoSQL databases
• Understanding cloud-native database concepts

Language

• Course: English / Spanish