Db2 concepts

At the end of this course, the participant:

will have a thorough insight into the different components of Db2: its usage, its objects and procedures;
will know and understand terms and terminology related to Db2;
will have an insight into the application possibilities of Db2: the participant will be able to locate the product in an automated environment and know its influences on that environment;
will be able to describe the available development tools and the peripheral products surrounding Db2.

Schedule

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

Everyone who wants or needs an insight into Db2: managers, department manager, end-users, operators, (non)-information scientists.

Background

Some familiarity with relational database management systems is required.

Main topics

History and future
Db2 as (relational) database management system:

characteristics and application • (dis)advantages • use on z/OS • use on Windows, Unix, or Linux • combined use

Db2 in a development environment:

strategy • available tools and peripheral products (IBM as well as non-IBM) • further developments • education • DRDA

Db2, internal structure:
the objects (database, table, index, ...) and their interaction
the catalog as internal dictionary
SQL, to be used interactively in order to manipulate objects (DDL) and data (DML)
embedded SQL, method and characteristics
available utilities
the internal security and authorization mechanism
the issue of locking

Training method

Classroom instruction.

Duration

1 day.

Course leader

Peter Vanroose, Kris Van Thillo.

SESSION INFO AND ENROLMENT