Conceptional and physical Modeling of relational Databases
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
- 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
Data analysts, database developers, database administrators, project managers
Basic knowledge of relational database systems
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.
Participant 1€ 1,320.00
Participant 2€ 1,320.00 - 10% = € 1,188.00
Participant 3€ 1,320.00 - 20% = € 1,056.00
Participant 4€ 1,320.00 - 20% = € 1,056.00
For groups bigger than five persons please request an individual offer
Price (per person)
Regular € 1,320.00
€ 1,570.80 incl. tax