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.
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.
Everyone who wants or needs an insight into Db2: managers, department manager, end-users, operators, (non)-information scientists.
Some familiarity with relational database management systems is required.
- 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
Peter Vanroose, Kris Van Thillo.
|SESSION INFO AND ENROLMENT|