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.
What you'll learn
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.
Table of contents
- Modeling Product Categories 3m
- Demo: Querying for Product Categories 2m
- Modeling Product Tags 1m
- Many-to-many Relationships 1m
- Partitioning Products 2m
- Introducing Denormalization 1m
- Denormalizing Category and Tag Names 1m
- Introducing the Change Feed 2m
- Demo: Using the Change Feed for Denormalization 9m
- Summary 1m
About the author
Leonard Lobel (Microsoft MVP, SQL Server) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., one of only 40 Microsoft National Systems Integrators in the United States. For more than 25 years, Tallan has been providing cutting-edge custom web/application development, business intelligence, customer relationship management, and int... more