Episode

Azure Cosmos DB Certification Study Hall Ep09: Query the Azure Cosmos DB SQL API

with Alex Mang, Marilag Dimatulac, Chris Hyde

Learn Live

Author queries for Azure Cosmos DB SQL API using the SQL query language.

Learning objectives

  • Create and execute a SQL query
  • Project query results
  • Use built-in functions in a query

Chapters

  • 00:00 - Introduction
  • 08:38 - Learning objectives
  • 11:30 - Understand the difference between point reads and queries in Azure Cosmos DB
  • 28:25 - Understand SQL query language
  • 30:45 - Create queries with SQL
  • 35:29 - Project query results
  • 46:38 - Querying arrays
  • 51:32 - Implement type-checking in queries
  • 01:00:08 - Use built-in functions
  • 01:02:20 - Handling date and time using system functions
  • 01:07:55 - Execute queries in the SDK
  • 01:10:58 - Exercise: Execute a query with the Azure Cosmos DB SQL API SDK
  • 01:19:50 - Some best practices
  • 01:22:56 - Knowledge Check
  • 01:27:57 - Summary and conclusion

Connect

Intermediate
Developer
Azure Cosmos DB