DB2 UDB Programming

Course Number:  704-JK
Recommended Duration:  5 days

Intended Audience
Java, C#, COBOL, PL/I, or C programmers who need to work with DB2 UDB Databases.

Objectives
Students who complete this course will be able to code SQL statements to access DB2 UDB objects by typing SQL and from within application programs (in the student's standard host environment).  Students also learn to execute and test DB2 UDB programs.

DB2 UDB Version 8.1.  Most of the class is suitable for those earlier versions of DB2 UDB (DB2 UDB 7).

Prerequisites
The student should have 6 months experience designing and coding Java, C#, COBOL, or C application programs or have completed the appropriate course within the last 12 months.  Familiarity with the available editor is required.

Topics

• Relational database concepts

• DB2 UDB concepts

• DB2 Clients: Run-time, Administration, SDK

• SQL

• Control center

• Command line processor

• SELECT

• UPDATE/DELETE/INSERT

• COMMIT/ROLLBACK

• Joins and Subqueries

• Functions

• Analytic features

• Creating tables, views, materialized query tables

• System catalog tables

• SQL in application programs

• Host variables and structures

• Cursors and locks

• Security and authorization

• DB2 Extenders

• DB2 connect

• Database administration server

• Dynamic SQL

• Stored procedures

• Efficiency considerations