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

Data Modeling Fundamentals: 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 a majority of the content from the first module in this course. For more on the Data Modeling Master Class, please visit SteveHoberman.com.

This video provides an introduction into the field of data modeling by defining data model concepts and terms, along with why the data modeling process is so important and warnings of pitfalls to avoid. Shortly after the video starts, you will complete a very important exercise illustrating the four important gaps filled by data models. Next, we will explain data modeling concepts and terminology including entities, attributes, relationships, candidate keys, and subtypes, and provide you with a set of questions you can ask to quickly and precisely build a data model. Demonstrate reading a data model of any size and complexity with the same confidence as reading a book. We will complete several exercises, including one on creating a data model based upon an existing set of data. You will be able to answer the following questions by the end of this video:

  • What is a data model and what characteristic makes the data model an essential wayfinding tool?
  • How does the 80/20 rule apply to data modeling?
  • What three critical skills must the data modeler possess?
  • What six questions must be asked to translate ambiguity into precision?
  • Why is precision so important?
  • What three situations can ruin a data model’s credibility?
  • What are three key skills every data modeler should possess?
  • What are entities, attributes, and relationships?
  • Why subtype and how do exclusive and non-exclusive subtypes differ?
  • How do different modeling notations represent subtypes?
  • What are candidate, primary, natural, alternate, and foreign keys?
  • What are the perceived and actual benefits of surrogate keys?
  • What is cardinality and referential integrity and how do they improve data quality?
  • How do you “read” a data model?
  • What are the different ways to model hierarchies and networks?
  • What is recursion and why is it such an emotional topic?