Data Modeling Course

Course Code: GK2711

‍

Duration: 3 days

‍

Course Overview

Logical data modelling helps business analysts communicate data requirements clearly with business stakeholders and delivery teams. This course provides hands-on practice creating and validating conceptual and logical data models.

Delegates learn to identify entities and attributes, model relationships and business rules, manage complexity and use normalisation to improve data integrity.

‍

Target Audience

• Business and data analysts
• Requirements professionals
• Data modellers
• Solution and information professionals involved in data requirements

‍

Course Objectives

• Understand the role of logical data modelling in requirements analysis.
• Develop conceptual data models.
• Identify entities, attributes, relationships and business rules.
• Model advanced and self-referencing relationships.
• Use supertypes and subtypes to manage complexity.
• Normalise data models to improve integrity.
• Verify and validate models against other requirements artefacts.

‍

Course Content

• Data modelling concepts and project context
• Conceptual data modelling
• Entities and attributes
• Relationships, cardinality and business rules
• Advanced relationships
• Supertypes and subtypes
• First, second and third normal form
• Denormalisation considerations
• Model verification and validation

‍

Course Prerequisites

Recommended preparation includes Business Analysis Essentials, Business Analysis: Requirements Development, Documentation and Management, and Use Case Modeling.

‍

Note - This course is delivered via our training partner Global Knowledge.