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.
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 contact ABIS.
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.
No specific background is required - some familiarity with informatics is an advantage.
- 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
Theoretical overview with practical examples and exercises.
an ABIS instructor.
|SESSION INFO AND ENROLMENT|