Full Version 1-Day – ½ Day & Workshops Versions Available
Earn CDU and PDU Credits

Overview

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.

Approach

Our goal at Bob the BA is to help you think, learn and work differently so you can make an impact back on the job. If you always do what you have always done, you will end up right where you were before you were trained right?  So at Bob the BA we take a different approach because we know we learn best by doing and not through lecture. Our courses are always hands-on, practicing through exercises, activities, facilitated discussions, case studies, role play, workshops, printed materials and presentations.

Who Should Take This Course?

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

Building Customized Training Experiences as Unique as You

Bob the BA 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.

Let's Talk Today!