Mastering Cosmos DB with the SQL API

Purchase a Subscription!

Watch the first few minutes on us! If you'd like to watch the entire video and hundreds more like it, download code samples, access offline videos and skills assessments, and use the discussion forums, log in or purchase a subscription.


Instructor

Scott Peterson

Description

Azure Cosmos DB is Microsoft's globally distributed, multi-model database service for mission-critical applications. The SQL API model combines the flexibility of a NoSQL database with the power to perform SQL queries over JSON data. Familiarize yourself with Cosmos DB and the SQL API, and learn how to use them to build planet-scale applications.

Table of Contents

00:00:00 Introduction
00:01:23 Azure Cosmos DB
00:02:11 Agenda
00:04:20 NoSQL/Cosmos DB Concepts
00:06:48 Comparing APIs
00:08:07 Provisioning a Cosmos DB + SQL API Database (Demo)
00:14:51 Understanding Costs
00:16:30 The SQL API Query Language
00:24:00 Querying Documents (Demo)
00:34:54 Supported SDKs
00:35:39 The .NET SDK
00:36:23 CRUD Operations
00:37:25 Direct Queries
00:38:32 Demo: App and Service Integration (Demo)
01:03:00 Optimizing Queries
01:04:20 Planning for Changes
01:06:15 Tips, Tricks, and Lessons Learned (Demo)
01:12:42 Next Steps

Related Links

  • Cosmos DB + SQL API Code Samples (requires a paid subscription)

Series

This course is part of the following series: