DB2 System Fundamentals & Programming

An introduction to DB2 SQL programming.
  

Objectives:

 

 This course is designed as an introduction to the DB2 SQL programming environment.

Subjects covered:
  • Relational Theory
  • DB2 Concepts
  • Database design
  • Data Definition Language (DDL)
  • DB2I & SPUFI
  • Application programming
  • Access paths
  • Security and authorisation
  • Locking
  • Utilities and Commands
  • Distributed Data Facility (DDF)
  • Shared Data & Data sharing with SYSPLEX

Participants:

 Programmers, Analysts and DBA’s who wish to design, develop and code DB2 applications using a normal programming language.

Prerequisites:

 TSO/ISPF knowledge, a programming language (the demonstrations shall be given using COBOL) and an understanding of basic programming concepts.

Remarks:

 None

Teaching method:

 Classical, with practical exercises.

Course duration:

 5 days

Cost:

 1700,- EUR excl. tax

Register for course: