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

Creating Programmatic SQL Database Objects
Microsoft via edX
Developing SQL Databases
Microsoft via edX
Advanced Relational Database and SQL
Coursera Project Network via Coursera
SQL Functions
Coursera Project Network via Coursera
Master C# And SQL By Building Applications
Udemy