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.