About Us Software Consulting Training Home

ProTech Home Training Course Catalog & Schedule Left Navigation

	Request in your area.
	Add course to watch list.
	View full course outline.
	Need more information?

Course Schedule:
Pittsburgh, PA	09/05-09/07
Virtual Classroom	09/05-09/07
Syracuse, NY	09/05-09/07
Albany, NY	09/05-09/07
Framingham, MA	09/05-09/07
Parsippany, NJ	09/05-09/07
Reston, VA	09/05-09/07
Chicago, IL	09/05-09/07
Columbus, OH	09/05-09/07
Baltimore, MD	09/05-09/07
Columbia, MD	09/05-09/07
Annapolis, MD	09/05-09/07
Wash Metro Area, DC	09/05-09/07
Richmond, VA	09/05-09/07
Norfolk, VA	09/05-09/07
Denver, CO	09/05-09/07
Los Angeles, CA	09/05-09/07
San Francisco, CA	09/05-09/07
Indianapolis, IN	09/05-09/07
Boston, MA	09/05-09/07
Des Moines, IA	09/05-09/07
Cedar Rapids, IA	09/05-09/07
Minneapolis-St Paul, MN	09/05-09/07
St Louis, MO	09/05-09/07
Seattle, WA	09/05-09/07
Philadelphia, PA	09/05-09/07
Detroit, MI	09/05-09/07
Phoenix, AZ	09/05-09/07
Tucson, AZ	09/05-09/07
Milwaukee, WI	09/05-09/07
Charleston, WV	09/05-09/07
Atlanta, GA	09/05-09/07
Raleigh-Durham, NC	09/05-09/07
Pittsburgh, PA	12/03-12/05
Virtual Classroom	12/03-12/05
Syracuse, NY	12/03-12/05
Albany, NY	12/03-12/05
Framingham, MA	12/03-12/05
Parsippany, NJ	12/03-12/05
Reston, VA	12/03-12/05
Chicago, IL	12/03-12/05
Columbus, OH	12/03-12/05
Baltimore, MD	12/03-12/05
Columbia, MD	12/03-12/05
Annapolis, MD	12/03-12/05
Wash Metro Area, DC	12/03-12/05
Richmond, VA	12/03-12/05
Norfolk, VA	12/03-12/05
Denver, CO	12/03-12/05
Los Angeles, CA	12/03-12/05
San Francisco, CA	12/03-12/05
Indianapolis, IN	12/03-12/05
Boston, MA	12/03-12/05
Des Moines, IA	12/03-12/05
Cedar Rapids, IA	12/03-12/05
Minneapolis-St Paul, MN	12/03-12/05
St Louis, MO	12/03-12/05
Seattle, WA	12/03-12/05
Philadelphia, PA	12/03-12/05
Detroit, MI	12/03-12/05
Phoenix, AZ	12/03-12/05
Tucson, AZ	12/03-12/05
Milwaukee, WI	12/03-12/05
Charleston, WV	12/03-12/05
Atlanta, GA	12/03-12/05
Raleigh-Durham, NC	12/03-12/05
[ Select a date to register ]

DB2 V9 Performance and Tuning for Programmers

Summary:
This course is designed for Application Programmers and Programmer/Analysts who will be using SQL statements in a high level programming language to manipulate DB2 tables. This course covers differences between versions 7 & 8 of DB2 UDB.

Duration:
3 Days/Lecture & Lab

Audience:
This course is designed for Application Programmers and Programmer/Analysts who will be using SQL statements in a high level programming language to manipulate DB2 tables.

Topics:

Application Tuning
SQL Statements That Can Affect Performance
EXPLAIN Function
Simple and Complex Access Paths
Index Structure, Design and Usage
DB2 Buffer Pools and Their Impact on Performance

Prerequisites:
Students must have experience coding in one of the programming languages listed: COBOL, PL/I or C. Students must also have experience in TSO/ISPF and DB2 file structures.

Last Update: May 21, 2012

Course Locations

Popular Courses

Browse Courses

DB2 V9 Performance and Tuning for Programmers