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


Mar 15 - 16, 2018$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.

Mar 13 - 16, 2018$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.

Mar 5 - 9, 2018$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.

Mar 12 - 13, 2018$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.

Feb 19 - 20, 2018$1,150.00Mar 19 - 20, 2018$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.

Feb 20 - 23, 2018$2,775.00Mar 20 - 23, 2018$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.

Mar 7 - 9, 2018$1,675.00

Business Analysis Training: Requirements Management & Use Cases

The course Requirements Management & Use Cases (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 Management & Use Cases that will allow you to hone your professional skills.

Feb 28 - Mar 2, 2018$1,675.00Mar 27 - 29, 2018$1,675.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.

Mar 12 - 13, 2018$1,150.00

Business Analysis Training: Writing Quality Use Cases

The course Writing Quality Use Cases (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 is also explored in this course. Training course titled Business Analysis Training: Writing Quality Use Cases that will allow you to hone your professional skills.

Mar 7 - 9, 2018$1,675.00

Business Writing Training: Writing Quality Requirements

The course Writing Quality Requirements (Business Writing Training) teaches you to write & maintain a quality business requirements document. The training includes business & system use cases, user stories and discusses functional requirements non-functional requirements & project constraints. Techniques for the maintenance of the integrity of the requirements are also covered. Training course titled Business Writing Training: Writing Quality Requirements that will allow you to hone your professional skills.

Feb 19 - 20, 2018$1,150.00Mar 19 - 20, 2018$1,150.00

Business Writing Training: Writing Quality Use Cases

The course Writing Quality Use Cases (Business Writing Training) teaches you to write great business use cases. The training includes techniques for requirements identification and covers writing & editing effective business use case. The course compares business use cases & system use cases and emphasize the characteristics of functional & non-functional requirements. Training course titled Business Writing Training: Writing Quality Use Cases that will allow you to hone your professional skills.

Mar 12 - 13, 2018$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.

Feb 26 - 26, 2018$650.00Mar 26 - 26, 2018$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.

Feb 26 - 27, 2018$1,675.00Mar 26 - 27, 2018$1,675.00