Information/Data modeling (EN)

“A student can enrol in multiple courses.” 

“That can’t be right! A student doesn’t enrol in a course, but in a session.” 

Are you also fed up with these kinds of discussions about concepts and data in your team? 

Do you also value clarity and clearly defined definitions of the concepts that are important to the business and for which we store data? Would you like to learn how to identify which data is important and how to model it? 

Then you’ve come to the right place. Welcome! 

Je hoeft niet te betalen voor je opleiding.
Een kost is wel mogelijk als je niet correct of tijdig annuleert.Hoe werkt dat?


Training Objectives

  • Learn the key concepts of data modelling 
  • Learn how to translate an analysis document into a data model in the form of an ERD 
  • Learn how to normalise data to convert a conceptual model into a logical model 
  • Understand the principles of dimensional modelling and apply them 

Program

  • Your first steps in data modelling 

A long time ago, when most computers were not yet capable of ‘speaking’, data modelling was introduced as a technique for designing an optimally structured database. We can still apply these techniques to represent important data. 
In this course, you will learn the theory behind this modelling technique and discover how to determine, based on the people who carry out the business processes or on the applications we need to build, which data is important and should be stored in a database. 
Enough theory, please give us a concrete example. 

  • Subchapters: 

Welcome 

  • Learn how to model data 
  • Data modeling exercise 
  • Practice makes perfect 

It’s time to put all that theory into practice and draw a few entity-relationship diagrams together. 
For example, help us design the database for a cinema complex, water level measurements, and so on… 
During the exercises, you’ll soon realise that reality isn’t always easy to capture using the rules you learnt in the previous module. 
That’s why, in this module, in addition to the exercises, you’ll receive the necessary guidance to give your models that extra bit of oomph by using enhanced ERDs. 

  • Subchapters: 
  • Learn the method 
  • Data modeling exercise 
  • Data modeling workshop 

Practical information

This is a live classical training of 2 days.

Do not forget to bring your laptop

Sessies

Datum
Plaats
Status

Incompany

Deze opleiding, exclusief voor je werknemers? Dat kan!

Meld je aan als opleidingsverantwoordelijke en vraag aan Hoe werkt dat?