Db2 for z/OS fundamentals course
In this 3-day ABIS training, you learn how Db2 for z/OS is set up, and you get familiar with its most important tools and database objects.
This course gives you a detailed description of the Db2 system on z/OS: what it is, what it is intended for, how it can be used, and how it relates to (or differs from) other RDBMS.
We'll dive into topics like
- Db2 objects
- the Db2 catalog
- query performance
- authorisations
- integrity
We also learn to use the system in practice.
At the end of the training, the participant will not only have the necessary theoretical knowledge of Db2 as an RDBMS, but 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.
Schedule a training?
Delivered as a live, interactive training: available in-person or online, or in a hybrid format.
Training can be implemented in Dutch, English, or French.
REQUEST IN-COMPANY TRAINING |
Public training calendar
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 let us know.
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.
You can test for yourself to see if this course contains enough new information for you by filling out the on-line self-test.
Background
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, which precedes this course.
Some knowledge of ISPF (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 and SQL/PSM database programming) is advisable.
You can test for yourself to see if you have enough background by filling out the online self-test "SQL fundamentals".
Main topics
- Introduction: Db2 environment; client-server model
- Relational system: position within the relational model
- SQL data definition language (DDL): the Db2 objects (tables, tablespaces, indexes, views, ...): characteristics, creation, use, and parameters
- SQL embedded in a program: development cycle, pre-compilation, compilation, BIND, plans and packages
- The Db2 catalog
- Security and authorization
- Utilities: LOAD, UNLOAD, CHECK DATA, RUNSTATS, REORG
- Integrity, locking
- Performance: basic principles, the EXPLAIN function
Training method
Classroom instruction with exercises (about 50% of the time).
Certification
At the end of the session, the participant receives a "Certificate of Completion".
Duration
3 days.
Course leader
Peter Vanroose (ABIS), Kris Van Thillo (ABIS).
Reviews
4.3/5 (based on 31 evaluations; the most recent ones are shown below)
|
It was a good and interesting course ! The teacher was really cool, friendly, and master in the subject !
| (N.N., NRB, ) |
De inhoud van de cursus was uitstekend en wat ik ervan verwacht had.
| (N.N., Solidaris, ) |
prima cursus.
| (N.N., Belastingdienst - B/CICT, ) |
parfait, félicitations à Peter
| (Michel Destiné, Solidaris Wallonie - Liège, ) |
Overall good!We went in depth and saw the inner workings of DB2.
| (Anas Birikh, AG Insurance, ) |
heel interessant en goede uitleg maar er mocht wat meer tijd voor oefeningen zijn.
| (N.N., AG Insurance, ) |
Also interesting
Enrollees for this training also took the following courses:
- SQL and relational databases fundamentals
- SQL PL and SQL/PSM database programming
- Db2 for z/OS SQL performance
- Db2 for z/OS database administration
SESSION INFO AND ENROLMENT |