home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » 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 » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Using DB2 for z/OS

Intended for

Analysts, programmers, and database administrators who will be using DB2; and everyone who wants to gain a thorough knowledge of the relational database system.

Background

General knowledge of IT, some knowledge of ISPF/PDF (see course ISPF/PDF basics) and an elementary knowledge of COBOL or PL/I (see courses COBOL programming - part 1 and PL/I programming: fundamentals course) are 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

5 days.

Schedule

datelanguageplacepriceremarks
07/05/2012NWoerden2125 EUR
04/06/2012NLeuven2125 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 gives insight into relational database systems, teaches how to write basic SQL statements (DML and DDL), and presents a detailed description of the DB2 system: what it is, what it is intended for, and how it can be used. The course will also deal with deficiencies, its relation to other RDBMS, and topics like the '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 independently.

Main topics

This course consists of three components. After having attended all three, participants will have a general overview of DB2 as RDBMS.

Participants can also attend each course separately; this allows them to compose their own package, based on background and aims, or to spread the course over a longer time span.

The courses RDBMS concepts and SQL fundamentals are also presented as introductory courses for other relational database systems. In that case, no ISPF/PDF, COBOL or PL/I knowledge is required.