YoVDO

Cosmos DB: Import, Manipulate, Index and Query

Offered By: LinkedIn Learning

Tags

Microsoft Azure Courses Azure Cosmos DB Courses Data Manipulation Courses Database Administration Courses Stored Procedures Courses User-Defined Functions Courses

Course Description

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

Taught by

Chander Dhall

Related Courses

MongoDB for DBAs
MongoDB University
MongoDB Advanced Deployment and Operations
MongoDB University
内存数据库管理
openHPI
Data Cleansing with Data Quality Services (DQS)
Microsoft via edX
Recovering Data in Azure and SQL Server
Microsoft via edX