Cosmos DB: Import, Manipulate, Index and Query

Course details

Azure Cosmos DB is a multi-model database that's globally distributed, and scales remarkably well. In addition to boasting 99.99 % availability within a region, Cosmos DB offers several well-defined consistency models: strong, bounded-staleness, session, eventual, and consistent prefix. In this course, take a coding deep dive into development with Azure Cosmos DB. Instructor Chandler Dhall discusses data import scenarios and data manipulation with stored procedures, as well as querying and indexing.

Learning objectives
Data import scenarios
Creating a database
Creating a partitioned collection
Data manipulation
Importing documents with a stored procedure
User-defined functions
Excluding indexing at a document level
Range indexing on strings
Querying with SQL parameters
Range operations

Concepts

0. Introduction

01 - Welcome
02 - What you should know
03 - How to use the exercise files

1. Data Import Scenarios

04 - Create database
05 - Create partitioned collection
06 - Create partitioned collection with custom indexing
07 - Change collection performance
08 - Add typed documents from file
09 - Add JSON from file

2. Data Manipulation

10 - Simple stored procedure query
11 - Import documents with stored procedure
12 - Execute ImportDocument stored procedure
13 - User-defined functions (UDFs)
14 - Trigger

3. Indexing Deep Dive

15 - Exclude indexing at document level
16 - Manual indexing at collection level
17 - Exclude paths from index
18 - Force range scan on a hash index
19 - Range indexing on strings
20 - Alter indexing strategy dynamically

4. Querying

21 - Multiple ways to select all
22 - Parallel query
23 - Query with SQL parameters
24 - Query with filter and projection
25 - Query with equality and inequality
26 - Range operations

Conclusion

27 - Teardown video
28 - Next steps