home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Soft skills » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Data warehouse, business analytics and big dataApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
DB2 concepts

Intended for

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

Background

Some familiarity with database management systems is required (see RDBMS concepts).

Training method

Classroom instruction.

Course leader

Peter Vanroose, Kris Van Thillo.

Duration

1 day.

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 contact ABIS.

Objectives

At the end of this course, the participant will:

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

Main topics

  • History and future
  • DB2 as (relational) database management system:

characteristics and application • (dis)advantages

  • 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, ...) and their relation
  • 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 security system
  • the locking problem