Prerequisite: None
Three-Day Course
Featuring data models for healthcare, insurance, manufacturing, telecommunications, financial services, banking, investments, travel, professional services, and other common models
There are fundamental, underlying patterns that affect more than 50 percent of most data models. This course provides reusable data models and patterns, tailored to your specific industry, that can jump-start and quality-assure your data modeling or data design effort.
In this course, participants will receive a toolkit of proven models, as well as alternative ways to model common constructs and share the pros and cons of each alternative. These re-usable models and patterns, developed and continuously refined by Mr. Silverston and other top data modelers in the industry, have been widely used by organizations around the world to jump-start and/or quality-assure all types of data modeling efforts. The models, hints, and techniques learned in this course could save your organization hundreds or thousands of hours by avoiding unnecessary modeling, redesign, or mistakes, and by providing ways to develop consistent models.
You Will Learn
- “Universal” data model constructs that can help jump-start your data modeling effort and are specific to your industry
- Data model templates for your industry (versions of this course are available for healthcare, insurance, manufacturing, telecommunications, financial services, banking, investments, travel, or professional services)
- Powerful patterns for modeling common types of data such as roles, statuses, categories, hierarchies, and rules, using both specific and generalized styles of modeling
- Pros and cons of specific versus generalized ways to model and when to use different styles
- Pitfalls in data modeling and “war stories” illustrating consequences of incorrect modeling; examples and experiences of how organizations have applied these models and patterns
- How to apply these models and patterns through hands-on exercises
Geared To
- Data modelers, data warehouse designers, data analysts, data administrators, database designers, database administrators, database consultants, and any other information systems professionals who need to be involved in data warehouse designs, data models, database designs, and data integration issues