Oreilly - Physical Data Modeling: A module from Steve Hoberman’s Data Modeling Master Class, a Best Practices Approach to Developing a Competency in Data Modeling
by Steve Hoberman | Publisher: Technics Publications | Release Date: January 2019 | ISBN: 9781634624831
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.
- Physical Data Modeling 1:18:14