Search⌘ K
Home
Courses
Mastering Cosmos DB through Basic and Advanced Concepts with C#

Introduction to the NoSQL API

Explore the Cosmos DB NoSQL API fundamentals, including how SQL syntax is applied to query JSON documents. Understand its role as the primary querying method, the use of basic clauses like SELECT, ORDER BY, and GROUP BY, and get introduced to setting up and querying containers in Cosmos DB. This lesson helps you grasp the core concepts needed to work effectively with Cosmos DB's native querying capabilities.

We'll cover the following...

SQL in a NoSQL database

For those unfamiliar with the terminology, using SQL in a NoSQL database might sound strange. However, NoSQL means Not Only SQL, and even if databases like MongoDB ditched it for a custom query language, Cosmos DB embraces it as its primary query language.

What is it?

The Cosmos DB NoSQL API is the primary way to query the database. It closely represents the underlying document architecture, while other APIs must project it.

Microsoft has complete control over the interface, service, and SDKs, so every new feature is first available on this API.

As said above, the NoSQL API uses SQL syntax, the most popular query language. However, the lack of relationships and the nature of JSON documents make it impossible to support the SQL we might ...