Overview
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.
Taught by
Microsoft Developer