Conceptional and physical Modeling of relational Databases

Course description

The course covers a structured approach for creating data models in the conceptual schema and the transition to the database schema.

The model is visualized as an entity relationship model (ERM). Concepts such as e.g. various notations, primary and foreign keys and normalization are covered in detail. The course covers various normal forms and processes for normalization and denormalization of data models.
Structured entity relationship modeling (SERM) will also be discussed on top of ER modeling.

Learn about data modeling and how to use it in practice in this course. Model business scenarios in tutorials led by an experienced trainer and discover the potentials held by data modeling for your tasks.

At the end of the course, you will be able to model and understand data models in the conceptual schema and database schema. You will be able to differentiate between normalized and denormalized data models and know the reasons behind the differences.

Course contents/Methodology/Target group

Course contents

  • Introduction into data modeling
  • Notations in data modeling (Chen, James Martin, SERM, DSA, IDEF1X)
  • Differences between conceptual and physical data model
  • Entities, attributes, relationships
  • Primary/foreign keys (basic concept)
  • Data analysis process
  • Normalization and keys

Target group:
Data analysts, database developers, database administrators, project managers


Basic knowledge of relational database systems

Advanced courses

Innovator for Information Architects

You are already familiar with data modeling in the conceptual schema (ERM) and database schema. However, data modeling hardly makes sense if you do not use an efficient modeling tool.

Model-based Business Intelligence (BI) and Data Warehouse (DWH) Modeling

In this course you will learn various aspects of a BI and be able to differentiate between BI modeling elements and apply them correctly.


Group discounts

  1. Participant 1
    € 1,320.00
  2. Participant 2
    € 1,320.00  - 10% = € 1,188.00
  3. Participant 3
    € 1,320.00  - 20% = € 1,056.00
  4. Participant 4
    € 1,320.00  - 20% = € 1,056.00

For groups bigger than five persons please request an individual offer

At the moment there are no events scheduled for this course. You can contact us if you are interested.

Price (per person)

Regular € 1,320.00

€ 1,570.80 incl. tax

Companies Like Yours Trust in Our Expertise

Need More Information?

Please do not hesitate to contact us with any questions about (in-house) training or individual packages you may have.



Dr. Katja Eisentraut

Head of Academy