Developer Dive into Azure Cosmos DB
2023TL; DR
Dive into Azure Cosmos DB with data modeling, geo-replication, partitioning, tunable consistency, custom indexing, migration, client development, event-driven microservices, and more.
Session Details
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!
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!
3 things you'll get out of this session
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.
Speakers
Leonard Lobel's previous sessions
Securing Azure Cosmos DB
Implement network security with the IP firewall, VNet access, and private endpoints, understand the various authentication options using master keys, resource tokens and Azure AD integration, learn about built-in server-side encryption, and how to configure client-side encryption using Always Encrypted.
Geospatial Data Types in SQL Server 2012
The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, learn how to integrate location-awareness into your own applications with the geometry and geography data types.
Native File Streaming with SQL Server 2012
This dynamic session will teach you how to use FILESTREAM and FileTable using T-SQL and the OpenSqlFileStream API. We’ll also cover the hierarchyid data type, full-text search improvements and the new Statistical Semantic Search.