Prerequisite: This course assumes completion of the course TDWI Data Modeling: Data Analysis and Design for BI and Data Warehousing Systems or equivalent understanding of entity-relationship modeling, dimensional modeling, and DW terms and concepts.
Two-Day Course
Preview Course Materials | Course Outline
Whether you are a business data modeler who represents data requirements as entities and relationships or a physical data modeler more concerned with tables, columns, and indexes, you know that the hard stuff lies beneath the surface. Every data design, whether logical or technical, is challenged by one or more complex considerations—scalability, adaptability, performance, legacy and package databases, etc. Every data model raises questions. Advanced modeling techniques provide many of the answers.
You Will Learn
- When, where, and how to apply advanced modeling techniques, including:
- Normalization and denormalization
- Abstraction, patterns, and universal models
- Generalization, specialization, and inheritance
- Time and time-dependency in the data model
- States and state-dependency in the data model
- Recursion for lists, trees, and networks
- Complementary models—process, state-transition, use cases, and event maps
- Data model validation and testing
Geared To
- Data modelers with some practical experience
- Data architects
- Database developers