Cosmos DB: Import, Manipulate, Index and Query

Take a coding deep dive into development with Azure Cosmos DB, a multi-model database that's globally distributed, and scales remarkably well.

Introduction

• Welcome
• What you should know
• How to use the exercise files

1. Data Import Scenarios

• Create database
• Create partitioned collection
• Create partitioned collection with custom indexing
• Change collection performance
• Add typed documents from file
• Add JSON from file

2. Data Manipulation

• Simple stored procedure query
• Import documents with stored procedure
• Execute ImportDocument stored procedure
• User-defined functions (UDFs)
• Trigger

3. Indexing Deep Dive

• Exclude indexing at document level
• Manual indexing at collection level
• Exclude paths from index
• Force range scan on a hash index
• Range indexing on strings
• Alter indexing strategy dynamically

4. Querying

• Multiple ways to select all
• Parallel query
• Query with SQL parameters
• Query with filter and projection
• Query with equality and inequality
• Range operations

Conclusion

• Teardown video
• Next steps