top of page

About

Data Modelling and Design is one of the core disciplines in the DAMA-DMBOK® framework of DAMA International, which defines the methods and structures used to capture, define, relate, and implement data across an organisation. It underpins virtually all other areas of data management—enabling consistency, integrity, and alignment of data with business needs. 


This specialist function deals with both data at rest (how data is stored and structured) and data in motion (how it flows across systems), and includes traditional relational designs as well as emerging patterns such as NoSQL, cloud-native models, and dimensional structures for analytics.


This course builds a practitioner’s capability to model data in conceptual, logical, and physical forms using global standards, while aligning models with governance, quality, architecture, and strategy requirements.


Learning Objectives


By the end of this course, participants will be able to:


  • Apply DAMA-DMBOK® modelling principles across all modelling levels (CDM, LDM, PDM)


  • Evaluate and select modelling techniques appropriate to enterprise, analytical, and transactional use cases


  • Design data structures using ERD, UML, dimensional and NoSQL paradigms


  • Integrate metadata, governance, and stewardship into modelling workflows


  • Optimise physical models for performance, scalability, and business relevance


  • Translate complex data requirements into scalable, communicable models


Where is this Data Modelling and Design course available?


This course is available In-Person in Doha, Qatar, Dubai, Abu Dhabi in UAE & Riyadh in Saudi Arabia, Muscat in Oman and Amman in Jordan as well as being available Online Worldwide.


Who Is This Training Course For?


This specialist training is ideal for professionals who work with enterprise data architecture and need to define, validate, optimise, and govern data structures across complex systems. It is especially suitable for the following roles and industries:


Roles:


  • Data Modellers and Data Architects

  • Enterprise Architects

  • BI Developers and Data Engineers

  • Data Governance Leads and Analysts

  • Solution Architects

  • Metadata Managers

  • Information Systems Consultants

  • CDMP® candidates specialising in Data Modelling


Industries:


  • Financial Services and Insurance

  • Healthcare and Life Sciences

  • Government and Public Sector

  • Telecommunications

  • E-Commerce and Retail

  • Energy and Utilities

  • Higher Education and Research

  • Defence and Aerospace

  • Technology, SaaS and Cloud Services

  • Logistics and Transportation


Why Should You Take This DAMA Data Modelling and Design Specialist Course?

  • Built on DAMA-DMBOK® Principles: The course is aligned with the DAMA-DMBOK2 framework and supports CDMP® Specialist certification.


  • Structured, Tool-Agnostic Approach: Gain a structured understanding of conceptual, logical, and physical modelling, applicable to any platform or tool.


  • Model for Today’s Architectures: Learn how to design models for NoSQL, cloud, MDM, and analytics alongside traditional RDBMS environments.


  • Bridge Business and Technical Worlds: Learn how to translate business requirements into technical models and vice versa, enabling stakeholder alignment.


  • Sharpen Governance and Stewardship Practices: Position your models as the backbone of metadata management, data quality, lineage, and compliance.


  • Advance Your Career: Demonstrate advanced competency in a specialised function essential to digital transformation, AI readiness, and data maturity initiatives.


Course Customisation


This course is fully customisable to suit the specific needs, priorities, and maturity level of your organisation. The modules listed below are provided as a sample structure and can be tailored to focus on particular sectors, regulatory environments, data challenges, or internal frameworks.


Whether you, or your organisation is just beginning its data quality journey or looking to align with advanced international standards, the content, case studies, and tools will be adapted to ensure maximum relevance and practical value.


Prerequisites


There are no formal prerequisites for this course. 


However, it is a specialist-level programme, and participants are expected to have:


  • A solid working knowledge of data management concepts, ideally aligned with the DAMA-DMBOK® functional areas


  • Experience working on data-related initiatives or roles involving business analysis, IT architecture, systems development, or data governance


  • Familiarity with basic data modelling concepts or tools is strongly recommended


This course is best suited for those who have completed a foundation-level data management programme or have equivalent industry experience.


Please note that MENA Executive Training is an independent training provider and is not affiliated with or endorsed by DAMA International. This course is intended solely to help participants prepare for the DAMA International certification examination.

Modules

AIGP.png

Module 1: Introduction to Data Modelling and DAMA Framework

  • Overview of DAMA-DMBOK2 Functional Areas

  • Definitions and roles: Data Modelling vs. Data Design

  • Business drivers and challenges in data modelling

  • Role of data modelling in governance and architecture

  • Data modeller responsibilities and skills


Activities:


  • Map organisational needs to modelling functions

  • Group discussion: Why does modelling fail without governance?

AIGP.png

Module 2: Levels and Types of Data Models

  • Conceptual, Logical, and Physical Data Models (CDM, LDM, PDM)

  • Metadata capture at each modelling level

  • Alignment between CDM, LDM, and PDM


Activities:


  • Create a conceptual model for a real-world scenario (e.g. hospital, university)

AIGP.png

Module 3: Data Modelling Techniques and Notations

  • Entity-Relationship Diagrams (ERD)

  • UML Class Diagrams, Barker and Crow’s Foot notation

  • Relationship types: 1:1, 1:M, M:N

  • Keys and constraints: Primary Keys, Foreign Keys


Activities:


  • Draw an ERD using Crow’s Foot notation for a given use case

AIGP.png

Module 4: Logical Data Modelling and Normalisation

  • Detailed attributes, domains, and data types

  • Normal Forms (1NF, 2NF, 3NF, BCNF)

  • Denormalisation: when and why

  • Data integrity rules


Activities:


  • Normalise an unstructured table to 3NF

  • Workshop: Model an e-commerce platform (products, customers, orders)

AIGP.png

Module 5: Physical Data Modelling and Performance

  • Indexing strategies: clustered vs. non-clustered

  • Storage structures, partitions, and sharding

  • Physical model optimisation techniques

  • RDBMS-specific deployment considerations


Activities:


  • Convert a logical model to a physical model

  • Case study: Optimise a “Customer Order” database

AIGP.png

Module 6: Data Modelling for Specialised Architectures

  • Master Data Management (MDM) structures

  • Dimensional Modelling: Star and Snowflake schemas

  • Data modelling for NoSQL (Document, Graph, Key-Value)

  • Modelling in Big Data and Cloud contexts


Activities:


  • Design a Star Schema for a retail dashboard

  • Group exercise: Compare relational and NoSQL models

AIGP.png

Module 7: Integrating Governance and Metadata

  • Business Glossary vs. Data Dictionary

  • Metadata management in models

  • Data stewardship and modelling standards

  • Version control and model repository practices


Activities:


  • Build a business glossary from a model

  • Explore metadata-driven modelling examples

AIGP.png

Module 8: Tools, Collaboration, and Real-World Application

  • Overview of industry tools (ERwin, PowerDesigner, ER/Studio, Sparx EA)

  • Collaborative modelling in agile teams

  • Communicating data models to stakeholders

  • Best practices for modelling lifecycle management


Activities:

  • Tool demo: Create a model using a modelling tool

  • Mock presentation: Explain a model to business stakeholders

Soft Gradient Background

Gain an Official Data Management Global Certificate

LinkedIn_logo_initials.png

Share your credential on LinkedIn

Course Certificate.png

Your certification.

Receive a verifiable certification from an accredited certifying body.

Showcase your achievement on LinkedIn and your CV.

Rock Logo
Basic elements of AI and machine learning
ISACA-Accreditd-Partner_edited.png
Rock Logo
AIGP Artificial Intelligence Governance Professional IAPP
ISACA-Accreditd-Partner_edited.png
Rock Logo
Basic elements of AI and machine learning
ISACA-Accreditd-Partner_edited.png
Rock Logo
AIGP Artificial Intelligence Governance Professional IAPP
ISACA-Accreditd-Partner_edited.png
Rock Logo
AIGP Artificial Intelligence Governance Professional IAPP
ISACA-Accreditd-Partner_edited.png
Rock Logo
AIGP Artificial Intelligence Governance Professional IAPP
ISACA-Accreditd-Partner_edited.png
Rock Logo
AIGP Artificial Intelligence Governance Professional IAPP
ISACA-Accreditd-Partner_edited.png
Rock Logo
AIGP Artificial Intelligence Governance Professional IAPP
ISACA-Accreditd-Partner_edited.png

Exam Details

Course Study Options

Self Study

Online Study at Your Own Pace

In-Person Training

12 locations across the Middle East

​

Qatar: Doha & Lusail

​

Saudi Arabia: Riyadh, Jeddah & Dammam

​

UAE: Dubai & Abu Dhabi

​

Bahrain: Manama ·

 

Oman: Muscat

​

Jordan: Amman ·

 

Kuwait: Kuwait City

​

Egypt: Cairo

​

Live Online Training

Course Duration : Flexible

Ready to find out more?

Speak to our team to choose your course and plan your next step.

You May Also Be Interested In

Rock Logo
IAPP
Rock Logo
Rock Logo
AIGP Artificial Intelligence Governance Professional IAPP
Rock Logo
Rock Logo
Basic elements of AI and machine learning
Rock Logo
Rock Logo
AIGP Artificial Intelligence Governance Professional IAPP
Rock Logo
Soft Gradient Background
qatari-man-original-hero.png
a.jpg

Data Modelling and Design Specialist

Taught: Online & In-Person

Official Training

Languages: English & Arabic

Duration: Flexible

Rock Logo
bottom of page