Course Duration: 2 days
Professional Development Units (PDU’s): 14
Course Description: This course extends participants knowledge of data modeling by exploring advanced concepts such as sub-types, recursive and network relationships, denormalization and when to apply it, and other considerations for transforming a logical model into a physical design. It picks up where our introductory course on Data Modeling leaves off. It assumes participants have grasped or have experience with the fundamental concepts of data modelling and builds on them. Depending on the level of experience and knowledge of the participants, this course can be reduced to a 1-day class (by eliminating the sub-types/super-types and recursive relationships sections of the course).
Key Learning Objectives:
- normalize entities to fifth normal form
- handle complex relationships
- sub-types and super-types
- recursive hierarchies
- recursive networks
- apply various data modelling guidelines to improve the quality of data models, and therefore the data requirements of an enterprise
- refine a data model in order to best prepare it for physical database design
- describe the issues involved with denormalization and explain 2-3 strategies for deciding on; if, when and how to accomplish it. This skill will be useful to work with data analysts and database administrators
- use two practical methods to balance your data model with processes or use cases, to ensure that all needed data and only needed data is present
- use State Transition Diagrams to uncover missing data and processes
Audience: This course is designed for business analysts, application developers/analysts, project leaders and data/database administrators
Course Prerequisites: A basic knowledge of data modeling concepts and techniques is required
Course Price: For on-site courses please contact Mindavation on 1-866-888-MIND(6463) or e-mail: info@mindavation.com For public course availability please see Public Course Schedule.
PMBOK® Guide Knowledge Areas:
- Project Scope Management
- Project Quality Management
BABOK® Knowledge Areas:
- Requirements Analysis
Click here to view course content.