AI, Data, and Machine Learning

T11 Deep Dive on Cosmos DB

05/19/2020

1:30pm - 4:15pm

Level: Intermediate

Leonard Lobel

MVP

CTO

Sleek Technologies, Inc.

Part I - Introduction to Cosmos DB

Part I of this session presents an overview of Azure Cosmos DB, a globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service that is designed specifically for modern web and mobile applications. Like other NoSQL platforms, Cosmos DB supports a schema-free data model, built-in partitioning for sustained heavy-write ingestion, and replication for high availability. But only Cosmos DB offers turnkey global distribution, automatic indexing, and SLAs for guarantees on 99.99% availability, throughput, latency, and consistency.

We begin by explaining NoSQL databases in general, and how they compare with traditional relational database platforms. Then we tour the many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON documents (using either SQL or MongoDB APIs), graphs (Gremlin API), and key/value entities (table API). You'll learn about global distribution, scale-out partitioning, tunable consistency, custom indexing, and more. We'll also discuss client development using the many available SDKs. Attend this session, and get up to speed on Cosmos DB today!

You will learn:

  • Get familiar with NoSQL databases, and Microsoft Azure Cosmos DB
  • Understand the differences between NoSQL and relational database platforms, and when to choose one or the other for your next application
  • About the unique NoSQL features of Cosmos DB, including global distribution, server-side horizontal partitioning, multi-model support, rich query over schema-free data, client development, server-side programming, tunable consistency, and automatic indexing

Part II – Building Cosmos DB Applications

In Part II, you'll learn how to build applications for Cosmos DB. We'll start with the .NET SDK and build a Cosmos DB application from scratch in C#. Then you'll work with your data using interactive Jupyter notebooks and Python. You'll learn how to migrate data from SQL Server to Cosmos DB with Azure Data Factory, and how to write queries using Cosmos DB SQL. Explore data access code that creates and queries databases, containers, and documents. We'll also create, deploy, and execute server-side code, using the Cosmos DB JavaScript server-side programming model. Attend this session, and prepare to build Cosmos DB applications today!

You will learn:

  • How to write code to build Cosmos DB applications
  • Explore the special version of SQL designed for querying Cosmos DB
  • Use the Cosmos DB server-side programming model to run stored procedures, triggers, and user-defined functions