Exploring the Cosmos DB SQL API

Azure Cosmos DB supports multiple APIs models, which makes it possible for you to select the ideal API for your application. In this section, we will specifically drill down into this SQL API. The Cosmos DB SQL API is the default Azure Cosmos DB API. You can store data using JSON documents to represent your data. Even though we are using the SQL API, we will still get to take advantage of all of the core features of Cosmos DB that are universal across all APIs.

The Core API for Cosmos DB is recommended when you’re building new solutions. This API uses SQL as a query language, along with JavaScript as its programming language. Both of these languages are pretty universal and popular, making it more likely that you already have experience with both.

Talking about the SQL query language specifically, you can write queries against Cosmos DB using the same SQL syntax you would use with products such as Microsoft SQL Server. Even though you are...