TDWI World Conference

Prerequisite: This course assumes basic knowledge of data modeling concepts.

Steve Hoberman

CBIP

Preview Course Materials | Course Outline

A successful modeling effort satisfies the current data requirements, enables efficient information retrieval, and evolves gracefully to support changing business needs over time.

This course presents both intermediate and advanced techniques that will lead you to greater successes with your data modeling deliverables. Techniques are explained with the help of numerous examples. Many of these techniques have been developed and fine-tuned through the instructor's own experiences. A very important goal of this course is for you to learn at least one new technique to take back to your own organization.

You Will Learn

• The Normalization Hike, where a series of 10 steps leads us to a fully normalized design
• An updated version of the Denormalization Survival Guide, which includes a question-and-answer approach to selectively introducing denormalization into your data model
• The Abstraction Safety Guide, which maximizes design flexibility
• When to use generic starter models
• How to use some powerful templates
• What to look for in reviewing a data model
• A number of challenging design situations, including when to use surrogate keys and variations of slowly changing dimensions

Geared To

• Data architects
• Analysts
• Modelers