Data Modeling and Partitioning Patterns in Azure Cosmos DB

This course targets data professionals that need to learn data modeling strategies for Azure Cosmos DB, and how they differ from traditional methodologies.
Course info
Rating
(43)
Level
Intermediate
Updated
Mar 25, 2020
Duration
1h 47m
Table of contents
Description
Course info
Rating
(43)
Level
Intermediate
Updated
Mar 25, 2020
Duration
1h 47m
Description

While Azure Cosmos DB is easy to use, it’s very different compared to a traditional relational database. In this course, Data Modeling and Partitioning Patterns in Azure Cosmos DB, you’ll learn how to design effective data models for Cosmos DB, Microsoft’s horizontally partitioned, non-relational database platform on Azure. First, you’ll explore the step-by-step process of adapting a relational schema to a data model optimized for Cosmos DB based on the familiar AdventureWorks sample database. Next, you’ll discover core concepts such as partitioning and throughput needed to get your job done. Finally, you’ll delve into non-relational data modeling practices, like embedding vs. referencing, schema-free data structures, and data denormalization with the Change Feed API, Azure Functions, and transactionalized stored procedures. By the end of this course, you’ll have the necessary knowledge to achieve the optimal design for your data models in Azure Cosmos DB.

About the author
About the author

Leonard Lobel (Microsoft MVP, SQL Server) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner. Lenni is also a consultant, trainer, and frequent speaker at major industry conferences.

More from the author
Learning Azure Cosmos DB
Intermediate
6h 3m
Sep 25, 2019
More courses by Leonard Lobel
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi there. My name is Lenny Low Belle, and I'd like to welcome you to my course data modelling in partitioning patterns in azure cosmos D B I'm a Microsoft data platform in VP and chief technology officer at Sleek Technologies in New York City. And I love databases. Cosmos D B is a massively scalable cloud database for Microsoft that's very easy to use, but also very different than your traditional relation A LL database. So this course will teach you everything you need to know so that you can answer such critical questions as How should you structure your model? When should you combine multiple entity types in a single container? How should you de normalize your entities? What's the best partition key for your data? We'll start in familiar territory using a relational e commerce workload based on the sequel Server Adventure Works database. And then we'll re factor that data model for Cosmos TV. Along the journey, you learn when to embed and went to reference and had have achieved the best performance for your most common queries. By de normalizing the data model, you'll see how to use azure functions to consume the change. Feed as well as transactional store procedures. Two powerful features in cosmos D B that help you achieve the optimal design for your data model. So dive right in and get ready to have fun learning all about data modelling and partitioning patterns in azure cosmos d B.