Intermediate DB2 Workshop

Course:  DB2IN
Duration:  5 Days
Level:  II
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).

« Hide The Details
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.

« Hide The Details
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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]