Db2 UDB for UNIX/Windows Application Development

PT2174
Training 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. Basic UDB administration functions will be reviewed and some Db2 utilities will be used.
Prerequisites
Before taking this course, the student must have relevant operating systems experience (AIX, OS/2 or Windows) and COBOL or ‘C’ programming experience.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for application programmers and designers.
Course 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

Related Scheduled Courses