Whether you are a business data modeler who represents data requirements and 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 
• Advanced indexing and outer join optimization 
• Data model validation and testing 

Geared To 

• Data modelers with some practical experience; data architects; database developers