Querying with SQL and Server-Side Programming
Lecture
Ryan Casey
Intermediate
0 h 30 m
2020-04-03
Lecture Overview
In this course, you will learn how to use the SQL API to write T-SQL like queries against your Cosmos DB collections. We’ll explore how partitioning and partition keys affect query performance and how to tune for faster results. This course will also explore how to write server-side queries, such as stored procedures, triggers, and user-defined functions.

Related Learning Path(s):
Developing Solutions with Azure Cosmos DB
Objectives
  • Understand how to query an Azure Cosmos DB using SQL API
  • How to author Azure Cosmos DB stored procedures using JavaScript
Pre-Requisites
  • Fundamental knowledge of Azure Cosmos DB
  • Basic knowledge of a supported programming language: .NET, Java
  • Basic knowledge of databases
Lecture Modules
In this course, you will learn how to use the SQL API to write T-SQL like queries against your Cosmos DB collections. We’ll explore how partitioning and partition keys affect query performance and how to tune for faster results. This course will also explore how to write server-side queries, such as stored procedures, triggers, and user-defined functions. 
Try Risk Free

Start a free trial

Skill Me Up subscriptions include unlimited access to on-demand courses with live lab lab environments with our Real Time Labs feature for hands-on lab access.

Subscription Benefits
  • Access to Real Time Lab environments and lab guides
  • Course Completion Certificates when you pass assessments
  • MUCH MORE!