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.

View Course Outline

DB2 UDB Application Programming for UNIX and Windows Training

Outline of DB2 UDB Application Programming for UNIX and Windows Training

Day 1

Day 2

Day 3

Day 4

Day 5

Free Resources

Web Age Solutions INC.

Platforms

Architecture & Methodologies

Programming Languages

Internet Technology

Storage & Databases

Testing & Management

Systems