Mainframe Training and Courseware

WA1893 z/OS Overview

This course is a combination of lecture, discussion and hands-on lab sessions. This course covers the various zSeries Hardware components and the various z/OS Software components. The major capabilities of Database Management systems and Transaction Processing systems are presented as 2 major application components of z/OS for providing end-use services.
 More Info


WA1892 Structured Analysis & Design

The Analysis portion presents the major Structured System Analysis tools used to improve the requirements definition / analysis activities of a project - Data Flow Diagrams, Data Dictionary, Processing Specifications, Data Structure Diagrams.
 More Info


WA1891 Successful Project Management

This course is intended for senior analysts, project team leaders, and project managers who need to build and/or sharpen their Project Management skills and to run successful projects.
 More Info


WA1890 Entry-Level Programmer Boot Camp

This series of course, gives the Entry-Level programmer a solid basis in each of the technical areas.
 More Info


WA1889 DB2 Concepts & Facilities

First, the concepts of DB2 are presented and discussed. The major features of the Structured Query Language (SQL) are presented as the means to access DB2 data (and to create and secure DB2 components).  Several of the “special features” of SQL are presented. Optionally, guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data.
 More Info


WA1888 DB2 Application Performance & Tuning

Review overall DB2 SQL Performance Considerations. Discuss the issues in Performance “problems”. Discuss the "behavior" or “mis-behavior” of the DB2 Optimizer. Explore DB2 SQL performance issues as revealed via the EXPLAIN Plan / VISUAL EXPLAIN feature. The major columns PLAN_TABLE and DSN_STATEMNT_TABLE are analyzed in detail.   
 More Info


WA1887 DB2 Query Management Facility (QMF)

The concepts of DB2 are briefly presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data. Several guided, hands-on, practice sessions give each attendee an opportunity to use QMF to build “custom:” reports from DB2 data using the extensive powers of the QMF FORMs panels. Use several other QMF facilities such as Help, Retrieve/”?”, Save/Display, Export/Import, Prompted and SQL Query modes, PROCs.
 More Info


WA1886 DB2 and SQL

First, the concepts of DB2 are presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components). Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data.  QMF and/or SPUFI are used to execute SQL statements.  Referential Integrity concepts and implementation are covered.
 More Info


WA1885 SQL and Application Programming

First, the concepts of DB2 are presented and discussed. The Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components).  Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data.  QMF and/or SPUFI are used to execute SQL statements.  Referential Integrity concepts and implementation are covered. 
 More Info


WA1883 VSAM, IDCAMS and Programming

The course covers, in detail, all aspects of using VSAM and IDCAMS that are important to the senior application COBOL programmer in new system development or maintenance.  The class lab is designed to provide an in-depth work experience. 
 More Info


WA1882 IMS Teleprocessing Programming with MFS

The course is a series of lectures, discussions, written exercises, and programming exercises dealing with the concepts, capabilities, and coding for IMS Transaction Monitor programs. Students will design terminal screens and code Message Format Services (MFS) macros to implement those screen designs. The students will modify a skeleton COBOL program to receive an input message (from an on-line terminal), process that message, and send a message (to an on-line terminal), change screen attributes, send a message to another program, and use PFF keys. The Batch Terminal Simulator (BTS) is used for Program testing.
 More Info


WA1881 IMS Database Programming

This is a lecture, discussion, and hands-on programming course covering IMS/VS database programming concepts, design, coding, testing and debugging. Segment Search Arguments (SSAs) are covered in detail along with emphasis on checking the PCB mask to understand the results of IMS database calls. Each workshop is preceded by lecture, discussion, and written exercise sessions.
 More Info


WA1880 File Aid for MVS

This course covers the use of File-AID and manipulating MVS file with capabilities above and beyond those of ISPF. The class attendees are guided through the File-Aid menu structures and extensive capabilities. Record selection, browsing, allocating files (including VSAM) and editing files are discussed.
 More Info


WA1879 COBOL Workshop

The course starts with an overview COBOL for z/OS and many of the differences from previous version of COBOL including the callable functions. An overview of the Language Environment / 370 (LE/370) is presented along with how some of its features can benefit the COBOL for z/OS programmer. Extensive workshop sessions utilize many of the COBOL for z/OS features that are different from previous COBOL environments.  The LE/370 features are also used in workshop sessions.
 More Info


WA1878 COBOL

The course starts with an overview of structured programming concepts.  The four divisions of a COBOL program and their functions are reviewed in detail.  Students will gain hands on experience through a series of class discussions and workshop exercises that include several modifications to a skeletal COBOL program.  File processing, program looping, conditional program statements, and table processing are covered in detail. Development of clear and understandable program designs is stressed along with building maintainable programs. Program debugging techniques are also discussed.
 More Info


WA1877 Basic Assembler Language Programming

This course introduces students to the basic skills required to write assembler programs using the IBM High Level Assembler (HLASM). Students will code Assembler programs.
 More Info


WA1875 Job Control Language (JCL) and z/OS Utilities

This course is a combination of lecture, discussion and hands-on lab sessions. First, an overview of JCL is given which describes the purpose of JCL, its relationship to the operating system, and the format / rules for coding. Next, the JOB, EXEC and DD statements are covered extensively. The purpose and use of each statement is described in detail; along with many parameters available to provide information to the operating system. Procedures and several commonly used IBM utilities are covered in detail. Recognize, analyze & correct typical ABENDs “caused” by JCL “errors”.
 More Info


WA1874 TSO/ISPF
This course begins with an introduction to the ISPF menu structure, menu navigation, and dataset description.  Next, the ever-useful Program Function (PF) KEYs and their functions are presented and discussed.  Utility functions to ALLOCATE a new dataset, DELETE a dataset, and COPY one dataset to another are demonstrated. The Primary and Line commands of EDIT are covered in detail. Next, Job submission and output review also covered. Lastly, we review the use of the HELP facility to review and / or to learn more about ISPF functions.
 More Info

WA1872 DB2 for z/OS Application Performance & Tuning

Review overall DB2 SQL Performance Considerations. Discuss the issues in Performance “problems”. Discuss the "behavior" or “mis-behavior” of the DB2 Optimizer. Explore DB2 SQL performance issues as revealed via the EXPLAIN Plan / VISUAL EXPLAIN feature.
 More Info


WA1871 Query Management Facility (QMF) for End-Users - z/OS

The concepts of DB2 are briefly presented and discussed.  The Structured Query Language (SQL) is presented as the means to access DB2 data.  Several guided, hands-on, practice sessions give each attendee an opportunity to use QMF to build “custom:” reports from DB2 data using the extensive powers of the QMF FORMs panels. Use several other QMF facilities such as Help, Retrieve/”?”, Save/Display, Export/Import, Prompted and SQL Query modes, PROCs.
 More Info


WA1870 DB2 for z/OS, SQL and Application Programming

The concepts of DB2 are presented and discussed. Structured Query Language (SQL) is presented as the means to access DB2 data (and to create and secure DB2 components).  Several guided, hands-on, practice sessions give each attendee an opportunity to use SQL to access data.  QMF and/or SPUFI are used to execute SQL statements.  Referential Integrity concepts and implementation are covered.
 More Info


WA1345 ISPF for TSO
This course will provide the skills to create, use and alter datasets using ISPF. Many of the ISPF panels will be reviewed including SDSF, which will be used to review JCL submitted from an EDIT panel.
 More Info

WA1346 Job Control Language (JCL) for Z/OS
This course will review basic job control language (JCL). It will not include any of the SMS (storage management subsystem) parameters or assume SMS is available. Practice with creating and executing JCL will be included.
 More Info

Atlanta
Boston
Calgary
Charlottetown P.E.I
Chicago
Columbia MD
Denver
Dallas
Edmonton
Halifax
Hartford
Irvine
Los Angeles
Las Vegas
Montreal
Minneapolis
New York
Orlando
Ottawa
Parsippany
Phoenix
Philadelphia
Raleigh
Regina
Toronto
Sacramento CA
San Diego
San Francisco
San Jose
Seatle
Vancouver
Victoria
Washington, DC
Winnipeg