Db2 for z/OS Classes
All virtual classes - Run with only One!
Db2 for z/OS Classes
CBI will not cancel or re-schedule a class because of low registration. It only takes one attendee for our virtual classes to run.
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 custiomize for Db2 Verision specific classes.
Db2 version 11, 12 and 13
We offer classes for: JCL and COBOL. Call for details 1.866.224.4968
Db2 for z/OS Class Topics and Outlines:
Db2 12 for z/OS - Advanced SQL Coding and Performance Tuning Using EXPLAIN and Data Studio
This workshop prepares the Db2 Query User, Application Developer and DBA to code complex SQL statements to achieve optimum performance.
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.
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.
Db2 SQL and Application Coding
A detail class on SQL code writing techniques and proper coding practices to provide effective SQL performance.
Db2 for z/OS 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.
*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.
Db2 Database Administration Part 1 Class Outline
Db2 Database Administration Part 2 Class Outline
Db2 Database Administration Part 3 Class Outline
Db2 for z/OS Migration and Installation
This workshop examines the migration and installation changes System Administratiors and Database Administrators will need to know for Db2 for z/OS.
Db2 for z/OS - System Architecture
This class and workshop examines the structure of a Db2 subsystem and its components. Understanding the environment that makes up a Db2 subsystem is the base line for working with Db2 for z/OS
JCL Basic
This introductory terminal course give the student a solid working knowledge of IBM JCL (Job Control Language). This combination lecture and terminal course is designed to give the student hands - on experience coding and using JCL.
JCL Intermediate
This course revisits the topics of JCL Basic's and extends them to creating and manipulating JCL Procedures. Participants extend their knowledge of partitioned data sets, generation data groups, symbolic parameters and overriding catalogued procedures. Command JCL abends and their resolutions are presented. Students complete workshops which require them to code both in-stream and catalogued procedures as well as to manipulate the procedure using overrides for both symbolics and data sets.
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 12 System Administration Crammer Class -
For IBM Certification Exam #318
This one-day crammer class reviews the six certification testing topics relating to the: IBM Certified System Administrator – Db2 12 for z/OS Certification Exam C2090-318.
Introduction to SQL (Structured Query Language)
This insturctor led class introduces the Structured Query Language
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.
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.
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.
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
TSO - ISPF Introduction
This course provides a hands - on introduction to Time Sharing Option/Interactive Systems Productivity Facility concepts, commands and utilities.
Db2 Fundamentals
This course is for Systems personnel that will be working in an IBM SQL environment. There is an examination of a relatinal database and its advantages over traditional data files. The rules and terminology of Db2 SQL and relationship with TSO, IMS, and CICS are presented.
Db2 for z/OS Database Administration Bootcamp
Database Administration Bootcamp is a 5-day advanced course that provides the attendee with the skill sets required to understand physical database designs, perform database implementations and to maintain Db2 for z/OS databases in an on-going production environment.
COBOL Overview
This course is designed for application programmers and systems analysts who are or will be using COBOL in a z/OS environment.
Structured Basic COBOL Programming
This fundamentals class covers the use of structured COBOL programming techniques to design, code and test COBOL programs
Structured COBOL Advanced
This hands-on workshop train the Db2 Query User, Application Developer and DBA to code complex SQL statements in a COBOL program to achieve optimum performance.