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.

Price (per person)

Regular € 1,320.00

€ 1,570.80 incl. tax

We are happy to help. Request a non-binding offer for an inhouse- or individual training.

Need more Information?

Our experts will be pleased to show you how you and your company can benefit from our solutions.



Dr. Katja Eisentraut

Leiterin Akademie