DB2 UDB for UNIX/Windows Application Development

    

Summary:
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. Program design issues will be considered which effect concurrency and integrity (i.e. locking) and performance.

Duration:
5 Days/Lecture & Lab

Audience:
This course is designed for Application Programmers and Designers.

Topics:

• The DB2 family
• Getting started
• Logical Design
• Creating tables and indexes
• Workshop 1 - getting started
• SQL basics to advanced
• Multiple workshops
• Programming with DB2
• Static SQL in programs
• Error handling
• Workshop - COBOL or 'C' programming
• DB2 PREP/BIND
• Embedded dynamic SQL programming techniques
• Workshop - dynamic SQL programming
• DB2 locking
• Commits and Batch applications
• DB2 stored procedures
• Workshop - stored procedures
• DB2 security
• DB2 support with utilities
• Import/Export/Load for data
• Workshop - utilities and data
• Performance and EXPLAIN
• Workshop - EXPLAIN

Prerequisites:
The student must have relevant operating systems experience (AIX, OS/2 or Windows) and COBOL or 'C' programming experience.

Last Update: February 11, 2012