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

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