Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Cosmos DB: Import, Manipulate, Index and Query

via LinkedIn Learning

Go to class Write review

This course may be unavailable.

Coursera

Coursera Plus Annual Nearly 45% Off

Datacamp

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

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

Taught by

Chander Dhall

Reviews

Start your review of Cosmos DB: Import, Manipulate, Index and Query