COURSE LENGTH: 4 DAYS
 
WHO SHOULD ATTEND:
 
This course is designed for programmers and other technical
experts that want to learn to write programs that access IBM's DB2
Universal Database (DB2 UDB) for z/OS.
 
PREREQUISITES:
 
Completion of this course INTRODUCTION TO DB2 CONCEPTS,
or equivalent knowledge. Additionally, prior programming experience
in COBOL is highly recommended.
 
COURSE DESCRIPTION:
 
This course presents the fundamentals of coding Structured Query
Language (SQL), including data manipulation, datadefinition
and data control. The basic DB2 components (database,
table, index, view, etc.) are defined and basic DB2 utilities are
introduced for loading and backing up DB2 data and capturing data
statistics. The structure of a DB2/COBOL program and the SQL
statements it requires is discussed and efficient coding techniques
are presented that ensures the optimum use of DB2 application
and system resources. Hands-on workshops are used to reinforce
concepts.
 
COURSE OBJECTIVES:
 
Upon successful completion of this course, students should be able to:
· Define the terminology associated with DB2 database technology.
· Describe DB2 database concepts, including pessimistic concurrency,
  commit and rollback, and referential integrity.
· List and code the nine statements that comprise SQL's data
  manipulation language, data definition language, and data control
  language.
· Define and code the SQL statements that can be used in a DB2/COBOL
  program.
· Code an efficient and complete DB2/COBOL program that performs
  common database functions.
· Determine the correct DB2 utility for a given situation and code the
  control statements required for its execution.
· Utilize DB2 tools, such as DB2 Interactive, to prepare, test, and
  execute SQL statements and DB2/COBOL programs.
· Utilize DB2 catalog and plan table information to optimize
  application performance.