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


Jan 6 - 7, 2025$1,500.00Feb 3 - 4, 2025$1,500.00Mar 3 - 4, 2025$1,500.00Apr 7 - 8, 2025$1,500.00May 5 - 6, 2025$1,500.00Jun 2 - 3, 2025$1,500.00Jul 7 - 8, 2025$1,500.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 12 - 15, 2024$3,750.00Jan 14 - 17, 2025$3,750.00Feb 11 - 14, 2025$3,750.00Mar 11 - 14, 2025$3,750.00Apr 15 - 18, 2025$3,750.00May 13 - 16, 2025$3,750.00Jun 10 - 13, 2025$3,750.00Jul 15 - 18, 2025$3,750.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 11 - 12, 2024$1,500.00Jan 13 - 14, 2025$1,500.00Feb 10 - 11, 2025$1,500.00Mar 10 - 11, 2025$1,500.00Apr 14 - 15, 2025$1,500.00May 12 - 13, 2025$1,500.00Jun 9 - 10, 2025$1,500.00Jul 14 - 15, 2025$1,500.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.

Jan 6 - 7, 2025$1,500.00Feb 3 - 4, 2025$1,500.00Mar 3 - 4, 2025$1,500.00Apr 7 - 8, 2025$1,500.00May 5 - 6, 2025$1,500.00Jun 2 - 3, 2025$1,500.00Jul 7 - 8, 2025$1,500.00

Business Analysis Training: Process Engineering

The course Business Process Reengineering (Business Analysis Training) will guide participants on how to use their requirements documents to model and assess existing processes, and apply techniques to analyze, and improve organizational and system processes. Through a mix of presentations, discussions and hands-on practical exercises, participants will apply a variety of modelling techniques and problem-solving tools from BABOK to LEAN to assess as-is processes to move toward creating more efficient and effective processes. Training course titled Business Analysis Training: Process Engineering that will allow you to hone your professional skills.

Nov 19 - 22, 2024$3,350.00Jan 21 - 24, 2025$3,750.00Feb 18 - 21, 2025$3,750.00Mar 18 - 21, 2025$3,750.00Apr 22 - 25, 2025$3,750.00May 20 - 23, 2025$3,750.00Jun 17 - 20, 2025$3,750.00Jul 22 - 25, 2025$3,750.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.

Nov 20 - 22, 2024$3,350.00Jan 22 - 24, 2025$3,350.00Feb 19 - 21, 2025$3,350.00Mar 19 - 21, 2025$3,350.00Apr 23 - 25, 2025$3,350.00May 21 - 23, 2025$3,350.00Jun 18 - 20, 2025$3,350.00Jul 23 - 25, 2025$3,350.00

Business Analysis Training: The Complete Lifecycle

The course Business Analysis: The Business Analysis Lifecycle I (Business Analysis Training) is a thorough study of the roles and responsibilities of a business analyst and the art and science of business analysis. Through presentations, case studies, discussions and hands-on practical exercises, participants will explore key concepts of the Business Analysis Body of Knowledge (BABOK) and various other tools from Lean, Agile and other relevant areas. Emphasis is placed on stakeholder management and techniques to elicit high quality business requirements. Training course titled Business Analysis Training: The Complete Lifecycle that will allow you to hone your professional skills.

Jan 7 - 10, 2025$3,750.00Feb 4 - 7, 2025$3,750.00Mar 4 - 7, 2025$3,750.00Apr 8 - 11, 2025$3,750.00May 6 - 9, 2025$3,750.00Jun 3 - 6, 2025$3,750.00Jul 8 - 11, 2025$3,750.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 18 - 19, 2024$1,500.00Jan 20 - 21, 2025$1,500.00Feb 17 - 18, 2025$1,500.00Mar 17 - 18, 2025$1,500.00Apr 21 - 22, 2025$1,500.00May 19 - 20, 2025$1,500.00Jun 16 - 17, 2025$1,500.00Jul 21 - 22, 2025$1,500.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 25 - 25, 2024$850.00Jan 27 - 27, 2025$850.00Feb 24 - 24, 2025$850.00Mar 24 - 24, 2025$850.00Apr 28 - 28, 2025$850.00May 26 - 26, 2025$850.00Jun 23 - 23, 2025$850.00Jul 28 - 28, 2025$850.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.

Jan 6 - 7, 2025$1,500.00Feb 3 - 4, 2025$1,500.00Mar 3 - 4, 2025$1,500.00Apr 7 - 8, 2025$1,500.00May 5 - 6, 2025$1,500.00Jun 2 - 3, 2025$1,500.00Jul 7 - 8, 2025$1,500.00