Order your ZCubed Technologies CICS WallChart Today

973.299.9669

  • Home
  • Education
    • CICS
    • MQSeries
    • z/OS
    • DB2
    • Application Development
    • IMS
    • Network
    • Security
    • Education Documents
    • Inquire about a class
  • Schedule
  • Training/Program Paths
  • Services
  • C\TREK™
    • What Is C\TREK™?
    • C\TREK™ Beta Program
    • C\TREK™ Screens & Videos
  • Company
    • About Us
    • Contact Us
    • Join Mailing /Career
  • More
    • Home
    • Education
      • CICS
      • MQSeries
      • z/OS
      • DB2
      • Application Development
      • IMS
      • Network
      • Security
      • Education Documents
      • Inquire about a class
    • Schedule
    • Training/Program Paths
    • Services
    • C\TREK™
      • What Is C\TREK™?
      • C\TREK™ Beta Program
      • C\TREK™ Screens & Videos
    • Company
      • About Us
      • Contact Us
      • Join Mailing /Career

973.299.9669

  • Sign In
  • Create Account

  • My Account
  • Signed in as:

  • filler@godaddy.com


  • My Account
  • Sign out

Signed in as:

filler@godaddy.com

  • Home
  • Education
    • CICS
    • MQSeries
    • z/OS
    • DB2
    • Application Development
    • IMS
    • Network
    • Security
    • Education Documents
    • Inquire about a class
  • Schedule
  • Training/Program Paths
  • Services
  • C\TREK™
    • What Is C\TREK™?
    • C\TREK™ Beta Program
    • C\TREK™ Screens & Videos
  • Company
    • About Us
    • Contact Us
    • Join Mailing /Career

Account


  • My Account
  • Sign out


  • Sign In
  • My Account
ZCubed Technologies

Db2 for z/OS: Introduction, Concepts & Facilities [DC]

OVERVIEW

This course introduces, describes and explains the fundamental principles of Db2 for z/OS. The course also explains the relational theory and concepts, and shows how Db2 adheres to them. The concepts of Db2 data storage, the Db2 system and its operation, Structured Query Language, the use of Db2 Interactive (DB2I), and the management of DB2 data using standard utility tasks are also introduced and explained 

COURSE DURATION & PRICE

2 Days

Hands-On

$1,450

Email at Info@zcubedtech.com  to find out more

Dates & Enrollments

COURSE SYNOPSIS

  • DBMS Overview
  • Relational Theory & Concepts
  • Db2 System Architecture
  • Introduction to DB2 Interactive (DB2I)
  • Db2 Data Objects
  • Introduction to SQL
  • Managing Db2 Data with Utilities
  • Hands-on Exercises

COURSE OBJECTIVES

  • Describe the relational concepts and theory, and the advantages of a RDBMS. 
  • Describe the components of the Db2 system, their function, and how they are controlled. 
  • Identify the objects used to store Db2 data and the relationships between them. 
  • Code the SQL statements needed to create and modify Db2 data objects, and control access to them. 
  • Code SQL statements to read and modify Db2 data and interrogate the Db2 catalog. 
  • Describe and fully utilize all the functions available with Db2 Interactive (DB2I). 
  • Use online utilities to backup and restore data, and perform other data management tasks. 
  • Describe the use of stand-alone utilities and identify situations where they may be required 

PREREQUISITES

A basic understanding of IT, with some exposure to database technology as a user. Whilst not essential, a knowledge of TSO/ISPF would be beneficial 

Email at Info@zcubedtech.com  to find out more

Dates & Enrollments

Db2 for z/OS: Understanding & Using SQL [DSQL]

OVERVIEW

This intensive course has been designed to provide a comprehensive understanding of data manipulation using Structured Query Language (SQL). While it is intended for all personnel who are going to use SQL to report from and modify relational data in a Db2 for z/OS environment, it will still be relevant to users of other RDBMSs.

COURSE DURATION & PRICE

3 Days

Hands-On

$2,150

Email at Info@zcubedtech.com or Find out more

Dates & Enrollments

COURSE SYNOPSIS

  • Introduction to Structured Query Language
  • Introduction to Db2 Interactive (DB2I)
  • Basic SELECT Statements
  • SQL Built-in Functions
  • Joins & Nested Table Expressions
  • Unions, Exceptions, Intersections & CASE Expressions
  • Subqueries
  • Table Modification Statements
  • The Db2 Optimizer and Access Path Selection
  • Db2 EXPLAIN
  • Practical exercises

COURSE OBJECTIVES

  • Code SQL SELECT statements including those using techniques such as joins, nested table expressions subqueries, unions and case.
  • Code SQL INSERT, UPDATE and DELETE statements to modify data 
  • Select the best options to use with SQL to achieve the required results
  • For Db2 for z/OS users use EXPLAIN to evaluate SQL access path and performance
  • For Db2 for z/OS users understand the factors influencing the Db2 optimizer and their effect on access path 

PREREQUISITES

Attendees must have experience with a relational environment 

Email at Info@zcubedtech.com or Find out more

Dates & Enrollments

Db2 for z/OS: Application Programming Workshop [DAPW]

OVERVIEW

This intensive course has been designed to provide a comprehensive understanding of the DB2 UDB for z/OS Structured Query Language and how it is embedded in application programs. Throughout the course reference will be made to best practices to ensure that the SQL and application programs will run efficiently and effectively

COURSE DURATION & PRICE

5 Days

Hands- On

$2,800


Email at Info@zcubedtech.com  to find out more

Dates & Enrollments

COURSE SYNOPSIS

  • DBMS Overview
  • Relational Theory & Concepts
  • Db2 System Architecture
  • Introduction to Structured Query Language
  • Introduction to DB2 Interactive (DB2I)
  • Basic SELECT Statements
  • SQL Built-in Functions
  • Joins & Nested Table Expressions
  • Unions, Exceptions, Intersections & CASE Expressions
  • Subqueries
  • Table Modification Statements
  • The Db2 Optimizer and Access Path Selection
  • Db2 EXPLAIN
  • Basic Db2 Application Programming
  • Cursor Processing
  • Program Preparation & Execution
  • Db2 Locking & Concurrency

COURSE OBJECTIVES

  • Use SPUFI to code SQL statements.
  • Code SQL Select statements including those using techniques such as joins, nested table expressions, subqueries, unions and case expressions.
  • Code SQL INSERT, UPDATE DELETE and MERGE statements to modify data.
  • Identify access paths chosen by Db2 by using the EXPLAIN feature.
  • Embed SQL statements into and application programming language such as COBOL, PL/I or Assembler. 
  • Understand and control the locking strategy used by Db2 to maintain data integrity.
  • Prepare and execute DB2 applications and understand the use of pre-compile and bind steps in the preparation process

PREREQUISITES

Must be familiar with a major application programming language, e.g. COBOL, PL/1 or Assembler. Previous exposure to the z/OS environment and the ability to use TSO/ISPF would also be a big advantage 

Email at Info@zcubedtech.com  to find out more

Dates & Enrollments

Db2 for z/OS: Advanced Application Programming [DASE]

OVERVIEW

 Course designed for the experienced Dbamong2 developer which focuses on the advanced SQL statements and options. Additionally, the Db2 EXPLAIN facility is discussed as a tool to be used when choosing amongst competing SQL and design alternatives 

Email at Info@zcubedtech.com  to find out more

Dates & Enrollments

COURSE DURATION & PRICE

3 Days

Hands-On

$2550

COURSE SYNOPSIS

  • Predicates, Access Paths, & I/O Types
  • The Db2 Optimizer
  • Db2 EXPLAIN
  • Views & Temporary Tables
  • Specialized Table Types
  • User-defined Functions
  • Ranking & Grouping Data
  • Triggers
  • Advanced Data Manipulation Language
  • Identity Columns & Sequences

COURSE OBJECTIVES

  • Choose optimal SQL code
  •  Understand the Db2 optimizer and the use of EXPLAIN in determining access path and statement efficiency
  • Understand the differences between views, nested table expressions, common table expressions, and temporary tables and select the best option for a specific task
  • Understand the use of materialized query tables, clone tables and temporal tables and the SQL statements associated with them
  • Describe the use of distinct data types, user-defined functions, and OLAP functions
  • Understand how and when triggers may be used
  • Explain the advanced programming possibilities when using the INSERT, UPDATE, DELETE and MERGE statements
  • Understand the difference between, and use of, identity columns and sequences

PREREQUISITES

 Attendance in Db2 for z/OS: Applications Programmers Workshop [DAPW], or equivalent experience 

Email at Info@zcubedtech.com  to find out more

Dates & Enrollments

Db2 for z/OS: Database Administration [DDAN]

OVERVIEW

This course provides a detailed understanding of the Db2 for z/OS facilities and procedures required to provide database users with efficient administration and support. It explains the system architecture and facilities of Db2 including monitoring, security and recovery techniques

COURSE DURATION & PRICE

3 Days

Hand-On

$2,350

Email at Info@zcubedtech.com  to find out more

Dates & Enrollment

COURSE SYNOPSIS

  • Db2 System Architecture
  • Db2 Pagesets
  • Db2 Security & Data Control Language
  • Managing Data with Db2 Utilities - Overview
  • Online Data Utilities
  • Online Recovery Utilities
  • Stand-alone Utilities
  • Performance Tuning

COURSE OBJECTIVES

  • Describe the Db2 environment, and understand the use of key Db2 components such as buffer pools, the Db2 catalog and directory, logging data sets, etc.
  • Describe the internal structure of Db2 UDB for z/OS databases
  • Understand and assess security and related requirements
  • Use Db2 commands to monitor and control Db2 objects, processes and operations
  • Understand and use the full complement of Db2 online data and recovery utilities
  • Understand and use the Db2 stand-alone utilities
  • Use Db2 traces to record performance monitoring information
  • Understand and interpret information in DB2PM accounting and statistics reports 

PREREQUISITES

Attendees should be familiar with the Db2 environment and have knowledge of SQL or have attended courses DB2 for z/OS: Introduction, Concepts & Facilities [DC] and Understanding & Using SQL [DSQL] 

Email at Info@zcubedtech.com  to find out more

Dates & Enrollment

Copyright © 2025 ZCubed Technologies - All Rights Reserved.

  • Education Documents
  • Inquire about a class
  • Schedule
  • CICS WallChart
  • About Us
  • Join Mailing /Career
  • Student Portal

Powered by

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

DeclineAccept