home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, 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 » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
DB2 for z/OS fundamentals course

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.

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 courses RDBMS concepts and SQL fundamentals, courses who precede this course. You can test for yourself to see if you have enough background by printing and filling out the self-tests (PDF file - 57 KB and PDF file - 56 KB).

Some knowledge of ISPF/PDF (cf. course ISPF/PDF basics) and of COBOL or PL/I (cf. courses COBOL programming - part 1 and PL/I programming: fundamentals course) is advisable.

Training method

Classroom instruction with exercises (about 50% of the time).

Course leader

Koen De Backer, Steven Scheldeman, Peter Vanroose, Kris Van Thillo.

Duration

3 days.

Schedule

datelanguageplacepriceremarks
01/09/2010NLeuven1275 EUR
29/09/2010NWoerden1275 EUR
17/11/2010 Leuven1275 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

This course presents a detailed description of the DB2 system: what it is, what it is intended for, and how it can be used. Rather than just giving a description of the system, the course will also deal with deficiencies, its relation to other RDBMS, and topics like the DB2 catalog, performance, authorisations, and integrity.

In addition, the course teaches how the system is used in practice. At the end of the course the participants will not only have the necessary theoretical knowledge of DB2 as an RDBMS, they will also have had sufficient practical training to start working with DB2 in an independent way.

Together with the courses RDBMS concepts and SQL fundamentals, this course forms a well-balanced whole, in such a manner that the participants have an 'overview' of DB2 as RDBMS after they followed this course.

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, precompilation, 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