Description: This course is an introduction to data modeling principles and processes.  This course assists in taking requirements and translating them into data requirements by using graphical data modeling notation.  This course explains how to normalize data and handle complex relationships between data concepts (classes/entities).  This course will provide a practical approach for analyzing and modeling data requirements making them ready to be transformed into a relational database.

Length: 1-2 Days

CDU/PDU: Earn 7-14 CDU/PDU for both IIBA and PMI certification

Prerequisites: We recommend the Introduction to Business Analysis course or equivalent experience.

Intended Audience: Business Analysts or other team members who need to understand how to read, modify, create data diagrams and models for development and database teams. 

Objectives

• Benefits of Data Modeling

• Definition of conceptual, logical and physical Data Modeling

• Understanding the difference between data model types

• Utilize a framework for logical data modeling

• Identify the components of the logical data model and how they are used

• Identify and explore data relationships

• Understanding normalization of data

• Understanding de-normalization of data

• Applying normalization to a data model

Course Topics

• Definition of conceptual, logical and physical Data Modeling

• Benefits of data modeling

• Approaches to data modeling

• Understanding data entities - Validation of data entities

• Entities versus attributes

• Naming conventions for attributes

• Symbols used for modeling attributes

• Understanding data relationships and cardinality: one to one, one to many, many to many, ranges

• Resolving many to many relationships – simplification

• Optional versus mandatory relationships

• Application of primary keys, foreign keys

• Referential integrity

• Symbols used to document relationships

• Walking users through the Entity Relationship or Class diagram

• Define data normalization and why it’s used

• Understanding normalization levels and their applications

• Understanding de-normalization and its applications

• Moving from a logical data model to a physical data model

Instructors

Building Customized Training Experiences as Unique as You

The Uncommon League delivers training experiences that focus on topics you need and that are relevant for your organization.  Buy only what you need - no customization fees, ever.  Our training is flexible with onsite or virtual course options.  We got your back.

Enterprise Solutions Instructor - Bob Prentiss is our fearless leader and innovator. Bob is passionate about helping you think, learn and work differently. Bob is an awesome trainer, speaker, mentor, coach, and author. Collector of all things dragon related and Dr. Who fan. Bob is CBAP certified with 25+ years of experience in corporate America; with a background in managing BA centers of excellence, assessing and managing BA maturity, quality, and competency. Bob is an award winning curriculum developer. Bob has presented numerous keynote, workshops, seminars, conferences, and training sessions across North America. Bob is a founding member and past President of the IIBA MSP Chapter.