Getting Started with Cosmos DB NoSQL Development (DP-3015) Virtual Classroom Live November 25, 2024

Course Overview

1 - 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

2 - Try Azure Cosmos DB for NoSQL

• Explore resources
• Review basic operations

3 - 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)

4 - Configure Azure Cosmos DB for NoSQL database and containers

• Serverless
• Compare serverless vs. provisioned throughput
• Autoscale throughput
• Compare autoscale vs. standard (manual) throughput
• Migrate between standard (manual) and autoscale throughput

5 - 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

6 - 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

7 - Configure the Azure Cosmos DB for NoSQL SDK

• Enable offline development
• Handle connection errors
• Implement threading and parallelism
• Configure logging

8 - 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

9 - 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
• Implement optimistic concurrency control

10 - Process bulk data in Azure Cosmos DB for NoSQL

• Create bulk operations with the SDK
• Review bulk operation caveats
• Implement bulk best practices

11 - Query the Azure Cosmos DB for NoSQL

• Understand SQL query language
• Create queries with SQL
• Project query results
• Implement type-checking in queries
• Use built-in functions
• Execute queries in the SDK

12 - Author complex queries with the Azure Cosmos DB for NoSQL

• Create cross-product queries
• Implement correlated subqueries
• Implement variables in queries
• Paginate query results

13 - Define indexes in Azure Cosmos DB for NoSQL

• Understand indexes
• Understand indexing policies
• Review indexing policy strategies

14 - Customize indexes in Azure Cosmos DB for NoSQL

• Customize the indexing policy
• Evaluate composite indexes

15 - 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

16 - 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

17 - 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

18 - 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
• Choose a partition key
• Model small lookup entities

19 - 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

20 - 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

21 - 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

22 - 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

23 - Customize an indexing policy in Azure Cosmos DB for NoSQL

• Index usage
• Review read-heavy index patterns
• Review write-heavy index patterns

24 - Measure index performance in Azure Cosmos DB for NoSQL

• Enable indexing metrics
• Analyze indexing metrics results
• Measure query cost
• Measure point operation cost

25 - Implement integrated cache in Azure Cosmos DB for NoSQL

• Review workloads that benefit from the cache
• Enable integrated cache
• Configure cache staleness

26 - Measure performance in Azure Cosmos DB for NoSQL

• Understand Azure Monitor
• Measure throughput
• Observe rate-limiting events
• Query logs

27 - 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

28 - Implement backup and restore for Azure Cosmos DB for NoSQL

• Evaluate periodic backup
• Configure continuous backup and recovery
• Perform a point-in-time recovery

29 - 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

30 - 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

31 - 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

32 - 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

33 - 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

 

Prerequisites

• Familiarity with C# programming.
• Experience writing code that interacts with a SQL or NoSQL database platform.