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
19/05/2014NWoerden405 EUR
23/06/2014ELeuven405 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 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