home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » DB2 for z/OS » DB2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Big data and analyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
DB2 for z/OS fundamentals course

Objectives

This course presents a detailed description of the DB2 system on z/OS: 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 how it relates 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 course SQL and relational databases fundamentals, this course forms a well-balanced whole, in such a manner that the participants have a 'complete overview' of DB2 as RDBMS after having 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
 

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 course SQL and relational databases fundamentals, courses who precede this course. You can test for yourself to see if you have enough background by filling out the online self-test.

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

Training method

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

Course leader

Koen De Backer, Peter Vanroose, Kris Van Thillo.

Duration

3 days.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
25 Sep3NWoerden  (NL)1425 EUR  (exempt from VAT) 
18 Oct3?Leuven  (BE)1425 EUR  (excl. VAT)  guaranteed

Global score

   
4.1/5 (based on 324 evaluations)

Reviews

     
je trouve que ce cours est trés utile pour commencer à travailler avec DB2. il donne les elements importants pour manipuler DB2 et SQL pour z/OS (, )
     
Op zich goed, maar sluit minder goed op onze dagelijkse praktijk bij ING. (, )
     
Goede grondige cursus (, )
     
compact en zeer nuttig (, )
     
Prima, en duidelijke uitleg (, )
     
Prettig en inzicht gevend. (, )
     
Zeer leerrijk. (, )
     
Bonne dans l'ensemble, le seul bémol était la partie abstraite sur les performances à la fin car nous n'avons pas encore le bagage et l'expérience pour en comprendre toutes les nuances. (, )
     
Uitstekende cursus, uitstekende en behulpzame docent (, )
     
Goede inhoud voor een introductie cursus, zelfs in zelfstudie haalbaar door goede syllabus en beschikbare oefeningen en oplossingen (, )

Refresh this page to see other comments.