Cosmos DB: Import, Manipulate, Index and Query

Go to class
Write Review

Free Online Course: Cosmos DB: Import, Manipulate, Index and Query provided by LinkedIn Learning is a comprehensive online course, which lasts for 2-3 hours worth of material. The course is taught in English and is free of charge. Upon completion of the course, you can receive an e-certificate from LinkedIn Learning. Cosmos DB: Import, Manipulate, Index and Query is taught by Chander Dhall.

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

Syllabus
  • 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