Business Analysis Training: Professional Data Modeling


Course Delivery

Live Instructor-Led Training

Course Description

The course Professional Data Modeling (Business Analysis Training) explores modern data modeling for relational data. The course begins with a discussion of business analysis for requirements elicitation and of normal forms for relational data. The course then explores relational database terminology including tables, fields, constraints, primary & foreign keys in the context of entity, domain & referential integrity. The training concludes with the analysis, design & implementation of a relational data model.

Course Dates and Pricing


Oct 22 - 23, 2018$1,150.00Nov 19 - 20, 2018$1,150.00Dec 17 - 18, 2018$1,150.00Jan 28 - 29, 2019$1,150.00Feb 25 - 26, 2019$1,150.00Mar 25 - 26, 2019$1,150.00Apr 23 - 24, 2019$1,150.00

Course Outline

Object Oriented Analysis and Design

Understanding the Role of the Business Use Case
Performing Object Identification
Eliminating Objects: Identifying Antonyms and Antonyms
Creating a Candidate List with Definitions
Identifying Primary Object Associations
Drafting a Domain Model

Exploring Relational Data

The Relationship between an Object and an Entity
The Relationship between a Property and a Field
When a Property becomes a Table
When an association becomes a Table
The Importance of Normal Form
What 1st Normal Form Provides
What 2nd Normal Form Provides
What 3rd Normal Form Provides
What Boyce-Codd Normal Form Provides
The Cost of Failing to Normalize
The Benefits of Denormalization

Exploring Relational Database Constructs

About Tables, Fields, Keys and Indexes
Ensuring Entity Integrity with Primary Keys
Ensuring Referential Integrity with Foreign Keys
Ensuring Domain Integrity with Constraints
Exploring the Role of Indexes

Moving from Analysis to Design

The Basics of ER Diagrams
Moving from an Object to an Entity
Adding Entity Relationships
Adding Entity Attributes
Adding Relationship Attributes
Specifying Data Types
Finalizing the Mode with Quality Checks
Generating the Model for a Specific RDBMS

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related Business Analysis Training

Business Analysis Training: Requirements, Use Cases & Modeling

The course Requirements, Use Cases & Modeling (Business Analysis Training) is a complete study of the requirements management roles & responsibilities of a business analyst. The training focusses on techniques for high quality business requirements & use case development in the context of systems development & process engineering. The course covers functional & non-functional requirements, business & system use cases, business process models, BPMN & more. The course concludes with a discussion of the testing and data modeling disciplines in the context of the overall business development lifecycle. Training course titled Business Analysis Training: Requirements, Use Cases & Modeling that will allow you to hone your professional skills.

Nov 27 - 30, 2018$2,775.00Dec 4 - 7, 2018$2,775.00Jan 15 - 18, 2019$2,775.00Feb 12 - 15, 2019$2,775.00Mar 12 - 15, 2019$2,775.00Apr 9 - 12, 2019$2,775.00

Business Analysis Training: The Complete Lifecycle

The course The Complete Lifecycle (Business Analysis Training) is a complete study of the roles & responsibilities of a business analyst. The training discusses the differences between waterfall & iterative methodologies for business analysis. Stakeholder & requirements management and use case development are studied in detail. Emphasis is placed on techniques for high quality business requirements & use case development in the context of systems development & process engineering. The testing & change management disciplines are also explored in this course. Training course titled Business Analysis Training: The Complete Lifecycle that will allow you to hone your professional skills.

Oct 30 - Nov 2, 2018$2,775.00Nov 27 - 30, 2018$2,775.00Jan 8 - 11, 2019$2,775.00Feb 5 - 8, 2019$2,775.00Mar 5 - 8, 2019$2,775.00Apr 2 - 5, 2019$2,775.00

Process Training: Processes for Performance & Predictability

The course Processes for Performance & Predictability (Process Training) explores the practical elements of process design & management. The training covers process management terminology & concepts and includes everything that you need to design, implement & monitor business processes within your organization. Training course titled Process Training: Processes for Performance & Predictability that will allow you to hone your professional skills.

Nov 19 - 20, 2018$1,150.00Dec 17 - 18, 2018$1,150.00Jan 28 - 29, 2019$1,150.00Feb 25 - 26, 2019$1,150.00Mar 25 - 26, 2019$1,150.00Apr 23 - 24, 2019$1,150.00

Business Analysis Training: Mastering Business Cases

The course Mastering Business Cases (Business Analysis Training) teaches you how to write great business cases. The training includes the development of a strategic vision, scope management, resource estimation, business impact analysis & project management. The course gives you the skills you need to write a business case that will ensure an approval and that will help you manage projects successfully. Training course titled Business Analysis Training: Mastering Business Cases that will allow you to hone your professional skills.

Oct 29 - 30, 2018$1,150.00Nov 26 - 27, 2018$1,150.00Jan 7 - 8, 2019$1,150.00Feb 4 - 5, 2019$1,150.00Mar 4 - 5, 2019$1,150.00Apr 1 - 2, 2019$1,150.00

Business Analysis Training: Reengineering Processes

The course Reengineering Processes (Business Analysis Training) is a complete study of business process engineering & reengineering. The course covers process terminology & concepts, as well as strategies for analysis of the as-is process and design & implementation of the to-be process. The training includes an in depth discussion of business process reengineering activities including identification of requirements, identification of current and future states as well as BPMN & other tools. Performance measurement, KPIs & change management as also dicussed in this training course. Training course titled Business Analysis Training: Reengineering Processes that will allow you to hone your professional skills.

Oct 30 - Nov 2, 2018$2,775.00Jan 8 - 11, 2019$2,775.00Feb 5 - 8, 2019$2,775.00Mar 5 - 8, 2019$2,775.00Apr 2 - 5, 2019$2,775.00

Business Analysis Training: Requirements & Lifecycle Management

The course Requirements & Lifecycle Management (Business Analysis Training) is a complete study of the roles & responsibilities of a business analyst. The training discusses the differences between waterfall & iterative methodologies for business analysis. Stakeholder & requirements management and use case development are studied in detail. Emphasis is placed on techniques for high quality business requirements & use case development in the context of systems development & process engineering. Testing & change management are also explored in this course. Training course titled Business Analysis Training: Requirements & Lifecycle Management that will allow you to hone your professional skills.

Oct 24 - 26, 2018$2,250.00Nov 21 - 23, 2018$2,250.00Dec 19 - 21, 2018$2,250.00Jan 30 - Feb 1, 2019$2,250.00Feb 27 - Mar 1, 2019$2,250.00Mar 27 - 29, 2019$2,250.00Apr 24 - 26, 2019$2,250.00

Business Analysis Training: UML for IT Professionals

The course UML for IT Professionals (Business Analysis Training) explores the use of UML for modern application design. The training includes UML constructs for classes, properties, methods, relationships, class collaboration, state machines, topology, deployment, design patterns and more. Training course titled Business Analysis Training: UML for IT Professionals that will allow you to hone your professional skills.

Nov 12 - 13, 2018$1,150.00Dec 10 - 11, 2018$1,150.00Jan 21 - 22, 2019$1,150.00Feb 18 - 19, 2019$1,150.00Mar 18 - 19, 2019$1,150.00Apr 15 - 16, 2019$1,150.00

Process Training: Concepts, Design and Implementation

The course Concepts, Design and Implementation (Process Training) :: Processes are the cornerstone of effective management. They allow organizations to standardize operational and strategic activities and, in doing so, provide a baseline for continued development and improvement of the organization. Through the word process is frequently used in the modern world, many organizations fail to implement processes as the science intends. This session provides participants with a concrete and practical definition of process. This provides participants with a good foundation to implement repeatable, measurable and controllable processes in their organization. Training course titled Process Training: Concepts, Design and Implementation that will allow you to hone your professional skills.

Nov 5 - 5, 2018$650.00Dec 3 - 3, 2018$650.00Jan 14 - 14, 2019$650.00Feb 11 - 11, 2019$650.00Mar 11 - 11, 2019$650.00Apr 8 - 8, 2019$650.00

UML Training: System Engineering & Application Architecture

The course System Engineering & Application Architecture (UML Training) is an exploration of the challenges, tasks, roles & responsibilities of implementing a formal systems engineering process. The training begins with a comparison of waterfall & iterative methodologies. This is followed by a thorough discussion of the tasks and challenges of a formal system engineering process implementation. Every aspect of the System Engineering process is discussed including High Level Design, Requirements, Design Specifications, UML, topology design & more. Training course titled UML Training: System Engineering & Application Architecture that will allow you to hone your professional skills.

Oct 29 - 30, 2018$1,675.00Nov 26 - 27, 2018$1,675.00Jan 7 - 8, 2019$1,675.00Feb 4 - 5, 2019$1,675.00Mar 4 - 5, 2019$1,675.00Apr 1 - 2, 2019$1,675.00