Main Office:	800.631.0410
Sales Office:	800.533.3893

Intermediate DB2 Workshop

Course: DB2IN

Duration: 5 Days

Level: II

On our website at: http://www.verhoef-training.com/courses/DB2IN.html

Course Summary

This workshop uses the 'HANDS ON' approach to teach application programmers or designers more advanced concepts of DB2 programming (current or any release).

Topics Covered In This Course

DB2 Review

Scalar Functions

Subqueries

Nested Subqueries

Joins

Multiple Joins

Union/Union All

Nested Table Expressions

DB2 Objects

Creating DB2 Tables

Alter Table

Views and Synonyms

DB2 System Catalog Tables

LOAD, REORG, and RUNSTATS Utilities

Temporary Tables

SQL Batch

SQL Application Programs

Plan vs. Package

Scrollable Cursors

Dynamic SQL

Stored Procedures

EXPLAIN and Efficiency Considerations

What You Can Expect

At the end of this course, participants will be able to:

Execute Complex Queries
Be able to Define, Load, and Maintain DB2 tables
Code Programs that use Stored Procedures, Scrollable Cursors and Dynamic SQL
Construct Efficient Queries in DB2
Find the Access Strategy for a Query

Who Should Take This Course

Application programmers with some prior DB2 experience, designers interested in gaining a further understanding of DB2, Systems programmers.

Training Style

Instructor led with hands on workshops.

Related Courses

Code	Course Title	Duration	Level
DB2A	DB2 for z/OS Administration	5 Days	I	Details
DB2M	Advanced DB2 Application Programming	3 Days	II	Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.

Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at: http://www.verhoef-training.com