DB2 UDB Application Programming for UNIX and Windows Training

Course #:WA1339

DB2 UDB Application Programming for UNIX and Windows Training

This course is designed to review concepts of using DB2 UDB (Universal Database). UDB object components will be presented along with communication and security aspects. Basic and advanced SQL techniques will be used. CLP commands and SQL statements will be used to create objects for application design and development. Design issues of referential Integrity, table check constraints, user defined data types and functions, triggers and large objects will be reviewed. Techniques for using EMBEDDED STATIC and DYNAMIC SQL in either COBOL or ‘C’ programs, will be applied in workshops. Program design issues will be considered which effect concurrency and integrity (ie. locking) and performance. Basic UDB administration functions will be reviewed and some DB2 utilities will be used.

Objectives:
  After completing this course the student should be able to:
  • UnderstandUnderstand the basic concepts and facilities of DB2.
  • Use CLP and SQL to create relational objects for application development.
  • Use basic and advanced SQL queries to access and manipulate data on DB2 tables.
  • Use embedded STATIC and DYNAMIC SQL in either COBOL or 'C' programs to access data using single and multiple row (cursor) techniques.
  • Use different BIND options for creating DB2 packages.
  • Know how to design an Application program to manipulate data for a Distributed Unit of Work (DUW).
  • Understand the DB2 locking strategy for improving concurrency and maintaining data integrity.
  • Know how to create Stored Procedures and also code client applications to use them.
  • Use IMPORT, EXPORT and LOAD utilities to manipulate data.
  • Understand the basic security features of DB2.
  • Know performance enhancing techniques and how to use the EXPLAIN facilities.
Target Audience:
  Application programmers and designers
Prerequisite:
 
  • Relevant Operating Systems experience (AIX, OS/2 or Windows).
  • Either COBOL or 'C' programming experience (depends on preferred language).
Duration:
  Five days.

Outline of DB2 UDB Application Programming for UNIX and Windows Training

Day 1

  • The DB2 Family
  • Getting started
  • Logical Design
  • Creating Tables and Indexes
  • workshop 1 - getting started
  • SQL BASICS to ADVANCED
  • Multiple Workshops

Day 2

  • SQL BASICS to ADVANCED - continued
  • Multiple Workshops - continued

Day 3

  • Advanced SQL
  • Programming with DB2
  • Static SQL in Programs
  • Error Handling
  • Workshop - COBOL or ‘C’ programming
  • DB2 PREP/BIND

Day 4

  • Dynamic SQL programming Techniques (‘C’ or JAVA)
  • Workshop - Dynamic SQL programming
  • DB2 Locking
  • Commits and BATCH applications
  • DB2 Stored Procedures
  • Workshop - stored procedures

Day 5

  • DB2 Security
  • DB2 Data Management
  • Workshop - utilities and data
  • Performance and EXPLAIN
  • Workshop - explain
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.