NoSQL Data Modeling Essential Training

1h 21mIntermediate2018-05-22

Authors

Robert Van Cleave

Data Architect and Consultant

Course details

NoSQL technologies have left even experienced data modelers scratching their heads, wondering how their valuable skills can transfer to future development activities. In this course, learn how to leverage your understanding of traditional data modeling to translate a conceptual data model into a NoSQL design. Instructor Robert Van Cleave discusses notation alternatives, access patterns, and the overall purpose of data modeling. He also covers several common design patterns, explaining how you can use each one. Learn about tree aggregation, anti-patterns, query-driven patterns, and more.

Learning objectives
Purpose of the data model
Notation alternatives
Determining access patterns
Transforming the conceptual model
Document style patterns
Columnar style patterns
Query-driven patterns

Skills covered

NoSQLData ModelingDatabase DevelopmentDatabase ManagementEssential TrainingData ScienceSoftware Development

Concepts

0. Introduction

01 - Welcome
02 - What you should know

1. The Basics

03 - The purpose of the data model
04 - Notation alternatives
05 - Analyze the data
06 - Determine access patterns
07 - Models vs. patterns

2. Transforming the Conceptual Model

08 - The transformation process
09 - Transformation - Customer 360
10 - Creating the JSON document
11 - Transformation - Product sales

3. Document Style Patterns

12 - Denormalization pattern
13 - Aggregation pattern
14 - Application side join pattern
15 - Tree aggregation
16 - Nested document flattening pattern
17 - Anti-patterns

4. Columnar Style Patterns

18 - Columnar database models
19 - Query-driven patterns
20 - Helper tables
21 - Handling arrays

Conclusion

22 - Additional design considerations
23 - Wrap up