O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Physical Data Modeling: A module from Steve Hoberman’s Data Modeling Master Class, a Best Practices Approach to Developing a Competency in Data Modeling

Video Description

The Data Modeling Master Class is a complete data modeling course, containing three days of practical techniques for producing conceptual, logical, and physical relational and dimensional and NoSQL data models. This video contains the physical data modeling module. For more on the Data Modeling Master Class, please visit SteveHoberman.com.

Learn all about physical data modeling. The techniques of denormalizing, indexing, building views, and creating partitions are covered. Learn about the five different types of denormalization: standard, FUBES, repeating attributes, aggregation, and summarization. Understand both horizontal and vertical partitioning. Master several dimensional modeling concepts including star schemas, snowflakes, degenerate dimensions, junk dimensions, and slowly changing dimensions.

Table of Contents

  1. Physical Data Modeling 1:18:14