home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Soft skills » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Data warehouse, business analytics and big dataApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
RDBMS concepts

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, or print the corresponding PDF file (55 KB).

Background

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

Training method

Theoretical overview with practical examples and exercises.

Course leader

an ABIS instructor.

Duration

1 day.

Schedule

datelanguageplacepriceremarks
03/06/2013NLeuven405 EUR guaranteed
26/08/2013ELeuven405 EUR
16/09/2013NWoerden405 EUR
14/10/2013FLeuven405 EUR
04/11/2013NWoerden405 EUR
18/11/2013NLeuven405 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 
  • Remarks:
    (guaranteed:) this session will certainly run
    (last places:) only limited number of places available
    (complete:) this session is fully booked; please contact us to get on the waiting list

Objectives

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

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