e-announce Test Course V1

Please Note: This class is subject to a ten percent increase. Please contact a TrainingPage representative for verification of price increase.

Description:

This course provides the database application designer or application programmer with lectures and labs promoting knowledge to recognize when a stored procedure is the correct solution for an application. The course also gives instructions on how to set up the environment to support stored procedures, how to use the DB2 Developer Workbench or Command Window with an editor to create and build stored procedures, how to CALL a stored procedure, how to create a stored procedure using DDL with different tools that interface with DB2, and how to improve the performance of SQL procedures.

CF71 is taught using lectures and machine lab exercises for the LUW environment. Windows, DB2 Developer Workbench, and DB2 9 for Windows are installed on each participant workstation. Participants will utilize the facilities of the DB2 Developer Workbench or Command Window and an editor to create SQL/PL and Java stored procedures. The DB2 Developer Workbench is used in lab to debug SQL/PL procedures.

Audience:

This course is used for e-announce test purposes and is not part of the mainstream offerings.

Testing of LMS Environment on 12/08/03.

Objectives:

This course is used for e-announce test purposes and is not part of the mainstream offerings.

Testing of LMS Environment on 12/08/03.

Prerequisites:

Database application designers and database application programmers supporting DB2 stored procedures with the SQL database language. This prerequisite knowledge may be from prior experience or attendance of the following IBM courses:

• DB2 Family Fundamentals (CF03)
• DB2 SQL Workshop (CF12)

Topics:

This course is used for e-announce test purposes and is not part of the mainstream offerings.

This is a test on 9/12/03

More tests.

Testing of LMS Environment on 12/08/03.