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: Application Developer Boot Camp [DBAP]

OVERVIEW

This comprehensive ten-day 'Boot Camp' course provides attendees with an accelerated learning approach to developing applications in a Db2 for z/OS environment. The course is ideal for those coming new to the Db2 for z/OS environment. The regular, hands-on lab exercises give students the opportunity to try out their newly-gained skills immediately. Throughout the course reference will be made to best practices to ensure that the SQL and application programs will run efficiently and effectively. On successfully completing this boot camp, attendees will have reached the skill level needed to enable them to write, maintain and amend programs for a Db2 for z/OS environment 

COURSE DURATION & PRICE

10 Days

Hands-On

Private-Only

Email at Info@zcubedtech.com  to find out more

Private-Only Inquire

COURSE SYNOPSIS

  

Day 1: 

  • DBMS Overview
  • Relational Theory & Concepts
  • Db2 System & Operations
  • Db2 Interactive (DB2I)

Day 2: 

  • Db2 Data Objects
  • Db2 Table Design
  • Db2 Index Design & Usage 

Day 3: 

  • Db2 Physical Database Design & DDL
  • Basic SELECT Statements
  • SQL Built-in Functions

Day 4: 

  • Joins & Nested Table Expressions
  • Unions, Intersections, Exceptions & Case Expressions
  • Subqueries

Day 5: 

  • Table Modification Commands
  • Basic Application Programming

Day 6: 

  • Cursor Processing
  • Program Preparation

Day 7: 

  • Db2 Locking & Concurrency
  • Using Views & Temporary Tables
  • Materialized Query, Clone & Temporal Tables

Day 8: 

  • Distinct Data Types & User Defined Functions
  • Triggers 
  • Advanced DML options

Day 9: 

  • The Db2 Optimizer
  • Db2 EXPLAIN
  • Db2 Performance Overview

Day 10: 

  • Db2 Traces
  • Monitoring Application Performance
  • Performance Analysis

COURSE OBJECTIVES

  •  Describe the relational concepts and theory, and the advantages of a RDBMS
  • List the components of the Db2 system and their functions, and describe how they are controlled
  • Utilize all the functions available with Db2 Interactive (DB2I)
  • Describe the internal structure and components of Db2 UDB for z/OS databases
  • Use SPUFI to code SQL statements
  • Design and assess a logical database model
  • Design and implement efficient physical databases from the logical model using relevant options to create and amend storage groups, databases, table spaces, tables, indexes, aliases, synonyms, etc.
  • Code SQL SELECT statements including those using techniques such as joins, nested table expressions, subqueries, unions and case expressions
  • Code SQL INSERT, UPDATE, DELETE & MERGE statements to modify data
  • Embed SQL statements into an application programming language such as COBOL, PL/I or Assembler
  • 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 additional SQL statements associated with them
  • Describe the use of distinct data types, user-defined functions, and OLAP functions within Db2 for z/OS
  • Understand how and when triggers may be used
  • Understand and control the locking strategy used by Db2 to maintain data integrity
  • Understand the Db2 optimizer and the use of EXPLAIN in determining access path, statement efficiency and choosing optimal code
  • Plan for application monitoring and tuning
  • Use Db2 traces to identify problem areas and identify tuning opportunities 

PREREQUISITES

Experience in using COBOL, PL/I or Assembler in a mainframe application programming role, an ability to use TSO/ISPF and a working knowledge of z/OS JCL 

Email at Info@zcubedtech.com  to find out more

Private-Only Inquire

Db2 for z/OS: Database Administrator Boot Camp [DBBC]

OVERVIEW

This comprehensive 9-day 'Boot Camp' course provides attendees with an accelerated learning approach to the DBA role in a Db2 for z/OS environment. The course is ideal for anyone new to the DBA role or those who are coming to Db2 for z/OS from another database environment.
The regular, hands-on lab exercises give students the opportunity to try out their newly-gained skills immediately. On successfully completing this boot camp, attendees will have reached the skill level needed to enable them to efficiently and effectively manage their Db2 for z/OS database environment 

COURSE DURATION & PRICE

9 Days

Hands-On

Private-Only

Email at Info@zcubedtech.com  to find out more

Private-Only Inquire

COURSE SYNPOSIS

Day 1

  • DBMS Overview
  • Relational Theory & Concepts
  • Db2 System Architecture

Day 2

  • Introduction to Db2 Interactive (DB2I)
  • Db2 Data Objects
  • Db2 Table Design

Day 3

  • Db2 Index Design & Usage  
  • Db2 Physical Database Design & DDL
  • Temporary Tables & Views

Day 4

  • Specialized Table Types
  • Distinct Data Types
  • User-defined Functions
  • Triggers

Day 5

  • Online Schema Maintenance & Versions
  • Partition Management
  • Db2 Locking & Concurrency
  • Db2 Security & DCL

Day 6

  • Managing Data with DB2 Utilities - Overview
  • Online Data Utilities

Day 7

  • Online Recovery Utilities
  • Stand-Alone Utilities
  • Catalog & Directory Recovery

Day 8

  • Problem Determination
  • Db2 Performance Overview
  • The Db2 Optimizer

Day 9

  • DB2 EXPLAIN
  • DB2 Traces
  • Performance Analysis
  • Program Preparation & Execution
  • Wrap-up Session 

COURSE OBJECTIVES

  • Describe the relational concepts and theory, and the advantages of a RDBMS
  • List the components of the Db2 system, their function, and how they are controlled
  • Describe the internal structure and components of Db2 UDB for z/OS databases
  • Utilize all the functions available with Db2 Interactive (DB2I)
  • Design and assess a logical database model
  • Design and implement efficient physical databases from the logical model using relevant options to create and amend storage groups, databases, table spaces, tables, indexes, aliases, synonyms, etc.
  • Describe how large object and XML data is held, and its implications on data recovery
  • Design and use materialized query tables, clone tables and temporal tables and the additional SQL statements associated with them
  • Explain the use of distinct data types and user-defined functions within Db2 for z/OS
  • Understand how and when triggers may be used and code them
  • Understand and control the locking strategy used by Db2 to maintain data integrity and concurrency
  • Assess security and related requirements
  • Describe the concept of online schema management and versioning
  • Use Db2 commands to monitor and control Db2 objects, processes and operations
  • Describe and use the full complement of Db2 online data and recovery utilities
  • Understand and use the Db2 stand-alone utilities
  • Explain the program preparation process for Db2 applications
  • Understand the Db2 optimizer and the use of EXPLAIN in determining access path, statement efficiency and choosing optimal database and code design
  • Plan for application monitoring and tuning
  • Use Db2 traces to record performance monitoring information to identify problem areas and identify tuning opportunities
  • Understand and interpret information in DB2PE accounting and statistics reports 

PREREQUISITES

The ability to use TSO/ISPF and a working knowledge of z/OS JCL. These skills can be gained by attending the courses TSO/ISPF Users’ Workshop [MTSO] & Boot Camp: z/OS JCL [TMTQ] .

Email at Info@zcubedtech.com  to find out more

Private-Only Inquire

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