Test 000-735: DB2 9.5 SQL Procedure Developer

Course title: DB2 Family Fundamentals
Course duration: 2.0 Days
Course number: CE030
Abstract:

This course provides you with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms.

DB2 9 runs under the z/OS, Linux, UNIX, and Windows operating systems, to name a few.

The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.

This basic course is for persons needing an introductory knowledge of DB2, and persons preparing for advanced and specialized DB2 education.

Course title: SQL Workshop
Course duration: 2.0 Days
Course number: CE120
Abstract:

This course is the classroom delivered version of Instructor Led Online Course 3E120.

This course provides an introduction to the SQL language and applies to the entire DB2 Family, and Informix. This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.

This is a basic course anyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).

Course title: DB2 SQL Workshop for Experienced Users
Course duration: 02.5 Days
Course number: CE130
Abstract:

This course is the classroom delivered version of Instructor Led Online Course 3E130.

This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments.This course is appropriate for customers working in all DB2 enviroments, that is z/OS, OS/390, VM/VSE, iSeries, Linux, UNIX, and Windows.

This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL.

Course title: DB2 9 for LUW Stored Procedures Programming Workshop
Course duration: 2.0 days
Course number: CF710
Abstract:

This is the classroom version of the Instructor Led Online (ILO) course DB2 Stored Procedures Programming Workshop - Instructor Led Online (3L710).

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.