home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, 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 » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical 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 yourself to see if this course contains enough new information for you by printing and filling out the self-test (PDF file - 57 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
30/08/2010NLeuven375 EUR
27/09/2010NWoerden375 EUR
11/10/2010FLeuven375 EUR
15/11/2010 Leuven375 EUR
22/11/2010NWoerden375 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 

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 system;
  • the necessary background to start studying a specific relational system - DB2, Oracle, SQLServer, Sybase, PostgreSQL, MySQL, ...

Main topics

  • Basic principles of relational theory: set theory - basic table conditions
  • Basic principles of relational database theory: global organisation (catalog, optimizer)
  • Integrity: system (keys, check, nulls) versus user (triggers, alerts, procedures)
  • Basic object structure: physical storage and logical approach
  • Database issues: logging, backup, locking