RDBMS concepts

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, ...

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

Schedule

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 the online self-test.

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.

Duration

1 day.

Course leader

an ABIS instructor.


SESSION INFO AND ENROLMENT