Session room

The Agenda

Agenda Home
SQLBits 2024 runs from Tuesday 19th – Saturday 23rd March.
Big Data & Data Engineering

Developer Dive into Azure Cosmos DB

Description

This full day workshop will ramp you up quickly on Azure Cosmos DB, Microsoft’s globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service 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.999% availability, throughput, latency, and consistency.

For many newcomers to Cosmos DB, the learning process starts with data modeling and partitioning. How should you structure your model? When should you combine multiple entity types in a single container? Should you de-normalize your entities? What’s the best partition key for your data? So we start off with the key strategies for modeling and partitioning data effectively in Cosmos DB. Using a real-world NoSQL example based on the AdventureWorks relational database, we explore key Cosmos DB concepts—request units (RUs), partitioning, and data modeling—and how their understanding guides the path to an optimal data model that yields the best performance and scalability.

Throughout the day, 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), and columnar (Cassandra API). You’ll learn about global distribution, multi-region conflict resolution, scale-out partitioning, tunable consistency, and custom indexing. Plus we’ll cover security, including V-Net with Private Link, authentication and authorization, and client-side encryption.

You’ll also learn client development, starting with the .NET SDK as we build a Cosmos DB application from scratch in C#. You’ll also learn how to how to query Cosmos DB using SQL, how to write data access code that creates and queries databases, containers, and documents. We’ll also create, deploy, and execute server-side transactional stored procedures, triggers, and user-defined functions, using the Cosmos DB JavaScript server-side programming model, and build event-driven microservices using the Azure Cosmos DB Change Feed. Attend this workshop, and get ready for Cosmos DB!

Learning Objectives

This training day will provide a comprehensive introduction and overview, combined with a deeper technical treatment of database architecture and design with Azure Cosmos DB.

Previous Experience

Although a strong understanding of relational databases is expected, no prior knowledge of Cosmos DB is required.

Tech Covered

Azure, security, Cosmos DB, Functions, Developing, Managing, Modelling, Big Data & Data Engineering, Developer, NoSQL/NewSQL