Know DB2

DB2 for z/OS Classes

All virtual classes - Run with only One!

New Class Available:
Advanced SQL Coding and Performance Tuning With Data Studio

CBI will not cancel or re-schedule a class because of low registration. It only takes one attendee for our virtual classes to run.

DB2 11 - Computer Business International

Our courses are available for on-site or virtual delivery with your choice of hands-on-labs or Lecture only.

In addition to our standard class outlines, CBI will customize any class outline for you. You decide what topics are best suited to your site and then your class material is customized to your specific requirements, at no extra charge.

All classes are written and delivered by Judy Nall; with her experience with DB2 no question will ever go unanswered.

We also provide 1 hour training webinars for those who don't have the time for full day sessions.
For more information about this see our webinars page.

DB2 for z/OS Class Topics and Outlines:

Advanced SQL Coding and Performance Tuning With Data Studio

Advanced SQL Performance and Tuning Workshop is designed to guide the students in writing effective SQL code and skills to modify complex SQL statements to achieve optimum performance. Our labs will include EXPLAIN and IBM Data Studio.

For more information about this class please visit our:
Advanced SQl Coding and Performance Tuning With Data Studio page.

Class Outline

Advanced SQL Coding and Performance Tuning

This DB2 workshop trains the DB2 Query User, Application Developer and DBA to code and performance tune complex SQL statements to achieve optimum performance.

This class is also available in half-day sessions.

Class Outline

*This is an intense SQL Advanced Performance and Tuning class, it warrants time and attention to detail in lectures and labs. In order to produce four full days of class and lab time, we present the material in half-day sessions. Each session is sequenced so that one session builds upon the next, providing step-by-step instruction during the course of the class. Each half-day session, for a period of two weeks, will complete a four-day class in DB2 for z/OS Advanced SQL Performance and Tuning.

Half-Day Session Detail Class Outline Part 1
Half-Day Session Detail Class Outline Part 2

SQL and Application Coding

A detail class on SQL code writing techniques and proper coding practices to provide effective SQL performance.

Class Outline

Database Administration From Start to Finish: Parts I, II and III

An intense three-week hands-on class, that takes the student through SQL, Utilities, Recovery, Database Administration, and System Administration.

Class Outline

*There are three courses (Part I, II, III), each five (5) days in length that comprise Database Administration From Start to Finish class. This series of classes is a complete course in DB2 Database Administration. It touches on all the aspects of a DB2 for z/OS DBA’s day-to-day responsibilities. Each section of each class addresses the topics that DBA’s must know to accomplish their job functions.

Database Administration Part 1 Outline

Database Administration Part 2 Outline

Database Administration Part 3 Outline

Systems Administration

Learn the tasks that are a part of the daily life of a systems administrator: Migration, performance tuning, trouble shooting, monitoring and problem resolution, and maintenance.

Class Outline

DB2 11 for z/OS Certification Crammer Class - Exam 317

This one-day crammer class reviews the six certification testing topics relating to the: IBM Certified System Administrator – DB2 11 for z/OS Certification Exam C2090-317.

Class Outline

DB2 11 Migration and Installation for the DBA and Systems Administrator

This workshop examines the migration and installation changes System Administrators and Database Administrators will need to know for DB2 11 for z/OS.

This class is also available in half-day and weekend sessions.

Class Outline
Half day session Class Outline

 

Not seeing what you need? CBI can write or customize any class at no extra charge!

For DB2 LUW classes give us a call at 1.866.224.4968

DB2 11 for z/OS - Enhancements for the DBA & System Administrator

DB2 11 for z/OS installation and migration planning for the DBA and System Administrator.

Class Outline

DB2 for z/OS - TSO, JCL & z/OS: The Mainframe Basics

This instructor led, virtual tutorial teaches IBM z/OS personnel the fundamentals in using and working in a z/OS environment. The essentials of the z/OS environment, JCL, ISPF/PDF, TSO Commands, Job submission, and product navigation are the major topics.

This class is also available in half-day and weekend sessions.

Class Outline
Half day session Class Outline

Introduction to DB2 for z/OS and Structured Query Language

This instructor led virtual tutorial introduces DB2 for z/OS and the Structured Query Language (SQL).

This class is also available in half-day and weekend sessions.

Class Outline
Half day session Class Outline

DB2 11 for z/OS – SQL and Application Enhancements

DB2 11 for z/OS SQL and Application enhancements are discussed in detail for migration planning.

Class Outline

DB2 10 for z/OS Advanced SQL Migration

This hands-on workshop is designed to take the student through advanced SQL coding techniques in DB2 for z/OS.

Class Outline

DB2 10 for z/OS – Migration and Installation Class

Migrating requires careful planning and knowledge of new features, and functions. Learn the detail steps for preparation, migration steps, what pitfalls to watch for and techniques for successful planning, migration and testing.

Class Outline

DB2 11 Migration for SQL Users and Application Programmers

In each new release of DB2 there are changes and additional new SQL features and functions. This class will take you through those changes to insure your successful implementation in application and SQL coding.

Class Outline

DB2 11 for z/OS Data Sharing - Implementation and Performance

The class will describe the concepts and components of a data sharing environment in DB2 for z/OS, the details of those data sharing components, performance tuning of the group buffer pools, lock structure and SCA (shared communications area) and detail performance monitoring and tuning of a DB2 Data Sharing environment.

Class Outline

DB2 Native and External Stored Procedures for DB2 z/OS

This course concentrates on methods to develop, code, implement, tune and test Stored Procedures in DB2 using External and Native coding methods.

Class Outline

z/OS, XML and COBOL

This instructor led class introduces using XML in z/OS, how XML is used in COBOL programs, and DB2 XML concepts

Class Outline

DB2 Version 8 to Version 10 for z/OS Skip Level Migration

Migration to DB2 10 from Version 8 has special considerations and this class will take you through the pre-migration through the migration process.

Class Outline

 

KNOW DB2 - Call CBI