About ABIS
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » Db2 for z/OS » Db2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big Data and AnalyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
Db2 for z/OS fundamentals course

This course presents a detailed description of the Db2 system on z/OS: what it is, what it is intended for, and how it can be used. Rather than just giving a description of the system, the course will also deal with how it relates to other RDBMS, and topics like the Db2 catalog, performance, authorisations, and integrity.

In addition, the course teaches how the system is used in practice. At the end of the course the participants will not only have the necessary theoretical knowledge of Db2 as an RDBMS, they will also have had sufficient practical training to start working with Db2 in an independent way.

Together with the course SQL and relational databases fundamentals, this course forms a well-balanced whole, in such a manner that the participants have a 'complete overview' of Db2 as RDBMS after having followed this course.


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.

Intended for

Analysts, programmers, and database administrators who will be using Db2; and anybody wanting to gain a thorough knowledge of a relational database system.


The participants must have insight in relational database systems and they must be able to write SQL select statements. This means, knowledge on the level of the course SQL and relational databases fundamentals, courses who precede this course. You can test for yourself to see if you have enough background by filling out the online self-test.

Some knowledge of ISPF/PDF (cf. course ISPF/PDF basics) and of COBOL, PL/I, or SQL PL (cf. courses COBOL programming - part 1, PL/I programming: fundamentals course, or SQL PL database programming) is advisable.

Main topics

Training method

Classroom instruction with exercises (about 50% of the time).


3 days.

Course leader

Koen De Backer, Peter Vanroose, Kris Van Thillo.

Global score

4.1/5 (based on 312 evaluations)


Bien, malgré la présence de trop longues sessions de théories (parfois toute une matinée à la suite). (, )
professeur toujours à l'écoute, des explications simples (, )
Goede cursus: heel leerrijk en goed qua niveau. Wel iets te kort om te kunnen stilstaan bij de BETEKENIS van alles achter wat er gecodeerd wordt en de compile- en runfiles, voor een leek als mezelf. (, )
Veel info om te verwerken. (, )
te lang, de informatie kan bondiger worden verstrekt denk ik (, )
Je suis satisfait de ce cours. (, )
Het tempo tijdens de cursus lag niet zo hoog. Ik had reeds ervaring met MySQL waardoor ik voor het gebruik van SQL niet zoveel bijgeleerd heb. (, )
zeer goed, vooral door de afwisseling theorie en oefeningen (, )
Weinig aan te vullen; cursus zit goed in elkaar. Helaas weinig aansluiting met de dagelijkse werkzaamheden tot nu toe. Ik hoop het snel een plek te kunnen geven. (, )
Er kwamen vrij veel zaken naar voren die niet erg relevant zijn voor mijn werk. (, )

Refresh this page to see other comments.