RDBMS concepts

Come and learn what are the foundations of an RDBMS during this one-day course at ABIS.

During this course, participants get an overview of the most important relational database concepts.

At the end of this course, participants will have obtained:

  • a thorough knowledge of the relational database model;
  • the necessary background to start studying a specific relational system - Db2, Oracle, SQLServer, Sybase, PostgreSQL, MySQL, MariaDB, ...

Schedule a training?

Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

REQUEST IN-COMPANY TRAINING

 

Public training calendar

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested? Please let us know.

Intended for

This course is designed for everybody who is interested in relational theory -- application developers and analysts, data modellers, DBAs, system managers - and also for those who want a general overview of the characteristics of an RDBMS. You can test for yourself to see if this course contains enough new information for you by filling out questions 1, 18 19 and 20 of the online self-test. If not, you can  go straight on to our course SQL Workshop.

This course has been replaced in our public offering by the course SQL and relational databases fundamentals.

Background

No specific background is required - some familiarity with informatics is an advantage.

Main topics

  • Basic principles of the relational model: tables and domains; keys; normalisation
  • Basic principles of a relational database: global organisation (catalog, optimizer)
  • Integrity: system (keys, checks, nulls) versus user (triggers, procedures)
  • Basic object structure: physical storage and logical approach
  • Database issues: transactions, logging, backup, locking, versioning

Training method

Theoretical overview with practical examples and exercises.

Certificate

At the end of the session, the participant receives a "Certificate of Completion".

Duration

1 day.

Course leader

an ABIS instructor.


SESSION INFO AND ENROLMENT