YoVDO

Azure Cosmos DB: SQL API Deep Dive

Offered By: LinkedIn Learning

Tags

Microsoft Azure Courses Javascript Courses Azure Cosmos DB Courses Data Management Courses Stored Procedures Courses Geospatial Data Courses SQL API Courses

Course Description

Overview

Learn how to use SQL API to query and manage data stored in Cosmos DB with SQL and JavaScript.

Syllabus

Introduction
  • Explore the Azure Cosmos DB SQL API
  • What you should know
1. Overview of the SQL API
  • Azure Cosmos DB SQL API
  • SQL API SDKs
  • Data model
  • Data normalization
2. Common Operations
  • Manage documents
  • SQL query syntax
  • Time to live
  • Challenge: SQL document queries
  • Solution: SQL document queries
3. Server-Side Programming
  • Programming in the Data Explorer
  • Programming in the Data Explorer: Demo
  • Stored procedures
  • Advanced stored procedures
  • Pre- and post-triggers
  • User-defined functions
  • Challenge: JavaScript programming
  • Solution: JavaScript programming
4. Advanced Features
  • Geospatial data
  • Optimistic concurrency
Conclusion
  • Next steps

Taught by

Sidney Andrews

Related Courses

Developing Planet-Scale Applications in Azure Cosmos DB
Microsoft via edX
Using Non-Relational Data in SQL Server
Microsoft via edX
Azure Architect Technologies
Udemy
Data Modeling and Partitioning Patterns in Azure Cosmos DB
Pluralsight
Microsoft Azure Database Monitoring Playbook
Pluralsight