This course runs for a duration of 4 Days.
The class will run daily from 9 AM PT to 5 PM PT.
Class Location: Virtual LIVE Instructor Led - Virtual Live Classroom.
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
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.
Objectives
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
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 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 NoSQL query language
Create queries with NoSQL
Project query results
Implement type-checking in queries
Use built-in functions
Execute queries in the SDK
12 - Author Complex Queries with Azure Cosmos DB for NoSQL
Create cross-product queries
Implement correlated subqueries
Implement variables in queries
Paginate query results
13 - Build Generative AI Applications with Azure Cosmos DB
Configure the Vector Search and Storage feature of Azure Cosmos DB NoSQL
Generate embeddings using Azure OpenAI Service
Build Generative AI applications with Azure Cosmos DB NoSQL and Python
Perform vector searches using Azure Cosmos DB for NoSQL from a Generative AI application
Integrate LangChain orchestration to improve efficiency and code maintainability in a Python Generative AI application
14 - Define Indexes in Azure Cosmos DB for NoSQL
Understand indexes
Understand indexing policies
Review indexing policy strategies
15 - Customize Indexes in Azure Cosmos DB for NoSQL
Customize the indexing policy
Evaluate composite indexes
16 - 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
17 - 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
18 - 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
19 - 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
20 - 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
21 - 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
22 - 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
23 - 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
24 - Customize an Indexing Policy in Azure Cosmos DB for NoSQL
Index usage
Review read-heavy index patterns
Review write-heavy index patterns
Module assessment
25 - Measure Index Performance in Azure Cosmos DB for NoSQL
Enable indexing metrics
Analyze indexing metrics results
Measure query cost
Measure point operation cost
26 - Implement Integrated Cache in Azure Cosmos DB for NoSQL
Review workloads that benefit from the cache
Enable integrated cache
Configure cache staleness
27 - Measure Performance in Azure Cosmos DB for NoSQL
Understand Azure Monitor
Measure throughput
Observe rate-limiting events
Query logs
28 - 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
29 - Implement Backup and Restore for Azure Cosmos DB for NoSQL
Evaluate periodic backup
Configure continuous backup and recovery
Perform a point-in-time recovery
Module assessment
30 - 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
31 - 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
Module assessment
32 - Create Resource Templates 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
33 - Build Multi-Item Transactions with 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
34 - 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
