Query the Azure Cosmos DB SQL API

Explore querying techniques for the Azure Cosmos DB SQL API in this comprehensive video tutorial. Learn to create and execute SQL queries, project results, and utilize built-in functions. Understand the differences between point reads and queries, work with arrays, implement type-checking, and handle date and time using system functions. Practice executing queries with the Azure Cosmos DB SQL API SDK through a hands-on exercise. Gain insights into best practices and reinforce your knowledge with a quiz. Presented by Azure experts Alex Mang and Marilag Dimatulac, this tutorial is part of a larger series on Azure Cosmos DB certification preparation.

Syllabus

- Introduction.
- Learning objectives.
- Understand the difference between point reads and queries in Azure Cosmos DB.
- Understand SQL query language.
- Create queries with SQL.
- Project query results.
- Querying arrays.
- Implement type-checking in queries.
- Use built-in functions.
- Handling date and time using system functions.
- Execute queries in the SDK.
- Exercise: Execute a query with the Azure Cosmos DB SQL API SDK.
- Some best practices.
- Knowledge Check.
- Summary and conclusion.