Advanced NoSQL Operations

Introduction

Cosmos DB SQL syntax is rich and full of features specific to JSON documents. We lose some operations and gain a lot more compared to traditional SQL. To efficiently query the database, we must know what we can use with this specific implementation. This lesson will show a few examples of what the Cosmos DB SQL syntax can offer.

For the query examples below, we can use documents that look like the following. It represents a user of an online shop containing their whole purchase history.