DB2 for z/OS - Applications

You are here:Home > Additional Hardware and Software Training > DB2 for z/OS Training > DB2 for z/OS - Applications

DB2 SQL for Everyone is a 3 day course targeting the needs of anyone writing SQL to access data stored in the DB2 environment on any platform.

NWDB1001 DB2 for z/OS Embedded SQL Programming

DB2 for z/OS Embedded SQL Programming is a 2 day course targeting the needs of programmers and developers writing applications that access data stored in the DB2 environment.

NWDB1010 DB2 for z/OS SQL & Application Programming

DB2 SQL and Application Programming is a 5 day course targeting the needs of programmers and developers writing applications that access data stored in the DB2 environment.

NWDB1018 DB2 for z/OS Triggers

This 1 day course covers the concepts and language of Triggers for DB2 for z/OS. Hands-on workshops give students the opportunity to apply topics discussed.

NWDB1020 Stored Procedure Options on DB2 9 for z/OS

This 3-day course presents coding and administration requirements for implementing DB2 Stored Procedures on DB2 for z/OS. Both external (COBOL)and native SQL Procedure Language Stored Procedures are covered.

NWDB1025 DB2 for z/OS Cobol Stored Procedures

This 2-day course presents coding and administration requirements to implement DB2 Stored Procedures for the DB2 z/OS environment.

NWDB1028 DB2 SQL PL Stored Procedures Using Data Studio

This 2 day course provides DB2 developers with the technical knowledge necessary to develop efficient SQL Stored Procedures with the IBM Data Studio. These tools may be used with DB2 on any platform. The course also covers the DB2 Unified Debugger.

NWDB1029 Exploiting Native SQL Stored Procedures on DB2 9 for z/OS

This 2 day course provides DB2 developers with the technical knowledge necessary to develop efficient SQL PL Stored Procedures with the IBM Data Studio. These tools may be used with DB2 on any platform. The course also covers the DB2 Unified Debugger.

NWDB1032 DB2 for z/OS SQL Optimization, Performance & Tuning

This 5 day class is designed to break down SQL statements in detail so the students understand in depth what the DB2 optimizer goes through in fulfilling an SQL request. Time will especially be spent breaking down SQL Joins and Subqueries in order to understand the fundamental issues associated with performance.

NWDB1035 Advanced Query Tuning with Optimization Service Center

This 3 day course is designed for the DB2 for z/OS development professional who desires to understand the fundamental issues associated with performance for DB2 SQL applications. Emphasis is placed on new considerations for DB2 Version 8 & 9 and the use of Optimization Service Center (OSC) as an optimization tool. Concepts discussed will be reinforced with appropriate workshops.

NWDB1036 Introduction to Optimization Service Center

This 1 day course is designed for the DB2 for z/OS development professional who desires to understand the fundamental issues associated with performance for DB2 SQL applications. Emphasis is placed on the use of Optimization Service Center (OSC) as an optimization tool.

NWDB1040 DB2 for z/OS Advanced SQL

This 5 day course covers advanced and complex SQL coding strategies for DB2 UDB for z/OS. Hands-on workshops give students the opportunity to apply the topics discussed.

NWDB1050 DB2 for z/OS Design

This 4 day course provides "how to" information on the design of DB2 databases and applications. The course utilizes the Database System Life Cycle. The four major phases of the DBLC include: Conceptual Design, Logical Design, Physical Design, and Design Implementation. It is assumed that the Conceptual Design phase has been completed, and that the conceptual data model with the base Entity Diagrams and the process model with all major process requirements identified, have been completed and accepted. The major focus of the course will be on the Logical, Physical and Implementation of Relational Database Systems as they apply to DB2.

NWDB1051 High Performance Physical Design on DB2 9 for z/OS

Implementing a logical database design on DB2 for z/OS requires an understanding of the inner workings of this platform. Learn and discuss some of the things to consider when making this transition in this action packed 3 day course. Design considerations for high performance will be the focus with hands on workshops to reinforce the concepts covered.

NWDB1060 DB2 for z/OS QMF Workshop

This 3 day course provides a comprehensive presentation of the capabilities and uses of QMF. In addition, the course addresses developing QMF queries using the Structured Query Language (SQL) and QMF’s “Prompted Mode” capability. Additional QMF topics include the development and uses of QMF forms, procedures, and Global Variables. Detailed examples are provided throughout the student text, and numerous hands–on workshops are provided to reinforce what is covered in class.

NWDB1080 DB2 for z/OS V8 Application Features

This 2 day course provides the information required for applications to assess and implement the new features of DB2 UDB for z/OS Version 8. Comprehensive coverage is provided of DB2 Version 8 Enhancements, their implementation and impact. Hands-on workshops are included.

NWDB1090 DB2 9 for z/OS New Application Features

This 1 day course introduces the attendee to the new SQL and application features of DB2 9 for z/OS.

NWDB1091 DB2 9 for z/OS PureXML Features

This 1 day course introduces the attendee to the new PureXML features of DB2 9 for z/OS.

NWDB1095 DB2 9 for z/OS Application & XML Features

This 2 day course introduces the attendee to the new SQL, application and XML features of DB2 9 for z/OS.

NWSQ1000 Cross Platform SQL Essentials

Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. This 2 day course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops.

NWSQ1010 Cross Platform SQL Essentials - Dealing with Complex Queries

Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this 3 day course is for you! Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. We begin with an in-depth discussion of joins and move quickly to more complex operations involving set processing, grouping, subqueries, table expressions, recursion and more. Each topic is reinforced with hands-on workshops.

Join our mailing list!