Efficient database programming is essential for developing high-performance applications in IBM Db2 for z/OS environments. Well-designed SQL statements, effective transaction management, and optimised access paths play a vital role in ensuring application reliability and scalability on enterprise mainframe platforms.

Db2 for z/OS: Application Programming Workshop is an intensive five-day hands-on programme that provides developers with the practical knowledge required to build, optimise, and maintain Db2 applications. Participants learn how to write advanced SQL, embed SQL within application programs, analyse execution plans, manage transactions, and implement performance optimisation techniques.

Practical workshops and instructor-led exercises allow learners to apply best practices for developing efficient Db2 applications while gaining a deeper understanding of database architecture and application preparation processes.

The programme is available as classroom training, dedicated on-site delivery, or live virtual instruction.

We can organize this training at your preferred date and location.

Prerequisites

Participants are recommended to have:

Experience with COBOL, PL/I, Assembler, or another mainframe programming language
Basic familiarity with the z/OS operating environment
Experience using TSO/ISPF
Working knowledge of JCL

Who Should Attend

This course is intended for:

Mainframe Application Developers
Db2 Application Programmers
COBOL Developers
PL/I Developers
Assembler Programmers
Db2 Technical Specialists
z/OS Software Engineers

What You Will Learn

After completing this course, participants will be able to:

Execute SQL statements using SPUFI.
Develop complex SQL queries using joins, subqueries, CASE expressions, and set operations.
Modify database records with INSERT, UPDATE, DELETE, and MERGE statements.
Analyse Db2 access paths using the EXPLAIN facility.
Embed SQL statements into COBOL, PL/I, or Assembler applications.
Understand Db2 locking mechanisms and concurrency control.
Apply transaction management techniques using COMMIT and ROLLBACK.
Prepare Db2 applications through precompile and bind processes.
Optimise SQL performance using Db2 best practices.

Training Outline

Module 1 – Database Management Fundamentals

Database management systems
Hierarchical databases
Network databases
Relational database concepts
Db2 history
Table structures
Database architecture comparison

Module 2 – Relational Database Concepts

Relational theory
Keys and constraints
Primary and foreign keys
Referential integrity
Entity integrity
Domain integrity
Relational algebra
Constraint management

Module 3 – Db2 System Architecture

Db2 architecture
Buffer pools
EDM pool
RID pool
Sort pool
Db2 objects
System datasets
Attachments
SQL processing

Module 4 – SQL Fundamentals

SQL language overview
DDL
DML
DCL
SELECT
INSERT
UPDATE
DELETE
MERGE
COMMIT
ROLLBACK
Db2 Optimizer

Module 5 – Working with Db2 Interactive (Db2I)

Db2I interface
SPUFI
DCLGEN
Program preparation
Precompile
Bind and Rebind
Program execution
Utilities
Query Management Facility

Module 6 – SQL Query Development

SELECT statements
Filtering
Sorting
DISTINCT
BETWEEN
IN
LIKE
ESCAPE
Derived columns
Date and time functions

Module 7 – SQL Functions

Aggregate functions
Scalar functions
GROUP BY
HAVING
Data conversion
Date functions
Numeric functions
String functions
NULL handling
User-defined functions

Module 8 – Advanced Query Techniques

Inner joins
Outer joins
Self joins
Multi-table joins
Nested table expressions

Module 9 – Set Operations and CASE Expressions

UNION
UNION ALL
INTERSECT
EXCEPT
CASE expressions

Module 10 – Subqueries

Simple subqueries
Correlated subqueries
EXISTS
Multi-row subqueries
Performance considerations

Module 11 – Data Modification

INSERT
UPDATE
DELETE
MERGE
Multi-row operations
Referential integrity

Module 12 – SQL Optimisation

Db2 Optimizer
Access path selection
Index usage
Table scans
Filter factors
Cardinality
RUNSTATS
Performance tuning

Module 13 – Using EXPLAIN

EXPLAIN facility
PLAN_TABLE
Access path analysis
Multi-index processing
Nested query analysis

Module 14 – Embedded SQL Programming

Embedded SQL
Host variables
SQLCA
DCLGEN
NULL processing
Error handling
SAVEPOINT
COMMIT and ROLLBACK

Module 15 – Cursor Processing

Cursor operations
Multi-row fetch
WITH HOLD cursors
Scrollable cursors
Read-only cursors
Updating through cursors

Module 16 – Program Preparation and Execution

Application preparation
Precompile
BIND
Packages
Collections
Plan management
TSO execution
IMS execution
CICS execution

Module 17 – Locking and Concurrency

Locking mechanisms
Isolation levels
Lock compatibility
Claims and drains
Lock avoidance
CURRENTDATA
ACQUIRE / RELEASE
Monitoring tools
Concurrency best practices

Why Choose Us

Experience Db2 for z/OS: Application Programming Workshop in Qatar through Bilginç IT Academy's live and interactive virtual classroom environment. Join a Public course as an individual delegate or arrange a dedicated Private / In-house online training program exclusively for your organization.

Delivery Method: Online Instructor-Led
Participation Model: Public / Private (In-house)
Live and Interactive Training: Connect with your instructor in real time and actively participate through discussions, Q&A sessions, practical exercises, and group activities.
Flexible Participation: Join the training from your home, office, or any location with a suitable internet connection.
Expert Trainer Network: Learn from experienced trainers with strong industry backgrounds and practical field expertise.
Over 30 Years of Training Expertise: Benefit from Bilginç IT Academy's professional training experience since 1995.
Worldwide Access: Join our live virtual classrooms from Qatar or anywhere else in the world, or arrange a dedicated online training program for your organization.

Experience Db2 for z/OS: Application Programming Workshop through face-to-face Classroom Based training in Qatar. Training can be delivered as a Public course open to individual delegates or as a dedicated Private / In-house class for your organization.

Delivery Method: Classroom Based
Participation Model: Public / Private (In-house)
Face-to-Face Learning: Interact directly with your instructor and fellow delegates in an engaging classroom environment.
Experienced Trainers: Learn from specialists with extensive industry experience and practical real-world knowledge.
Professional Training Environment: Attend training in comfortable, well-equipped classrooms designed to support effective learning.
Practical Learning: Depending on the course, reinforce your knowledge through hands-on exercises, scenarios, case studies, and instructor-led activities.

Arrange Db2 for z/OS: Application Programming Workshop in Qatar as a dedicated Onsite training program for your organization. Bilginç IT Academy trainers can deliver the training at your office or another location of your choice, with the program planned around your team's requirements and business objectives.

Delivery Method: Onsite
Participation Model: Private (In-house)
Training at Your Preferred Location: Organize the training at your company's office or another location selected by your organization.
Tailored Course Content: Adapt the training program to your projects, team structure, existing skill levels, and specific business requirements.
Team-Focused Learning: Develop your team around a shared knowledge base while strengthening internal collaboration and knowledge transfer.
Flexible Scheduling: Plan the training dates, location, and program according to your organization's operational requirements.
Worldwide Onsite Delivery: Arrange the training in Qatar or at another preferred location worldwide. Bilginç IT Academy trainers can travel to your selected location to deliver the dedicated training program.

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Db2 for z/OS: Application Programming Workshop Training in Qatar

Prerequisites

Who Should Attend

What You Will Learn

Training Outline

Module 1 – Database Management Fundamentals

Module 2 – Relational Database Concepts

Module 3 – Db2 System Architecture

Module 4 – SQL Fundamentals

Module 5 – Working with Db2 Interactive (Db2I)

Module 6 – SQL Query Development

Module 7 – SQL Functions

Module 8 – Advanced Query Techniques

Module 9 – Set Operations and CASE Expressions

Module 10 – Subqueries

Module 11 – Data Modification

Module 12 – SQL Optimisation

Module 13 – Using EXPLAIN

Module 14 – Embedded SQL Programming

Module 15 – Cursor Processing

Module 16 – Program Preparation and Execution

Module 17 – Locking and Concurrency

Why Choose Us

Db2 for z/OS: Application Programming Workshop Training Course in Qatar Schedule

Db2 for z/OS: Application Programming Workshop Training in Qatar

Prerequisites

Who Should Attend

What You Will Learn

Training Outline

Module 1 – Database Management Fundamentals

Module 2 – Relational Database Concepts

Module 3 – Db2 System Architecture

Module 4 – SQL Fundamentals

Module 5 – Working with Db2 Interactive (Db2I)

Module 6 – SQL Query Development

Module 7 – SQL Functions

Module 8 – Advanced Query Techniques

Module 9 – Set Operations and CASE Expressions

Module 10 – Subqueries

Module 11 – Data Modification

Module 12 – SQL Optimisation

Module 13 – Using EXPLAIN

Module 14 – Embedded SQL Programming

Module 15 – Cursor Processing

Module 16 – Program Preparation and Execution

Module 17 – Locking and Concurrency

Why Choose Us

Online Instructor-Led Training

Classroom Based Training

Onsite Training

Db2 for z/OS: Application Programming Workshop Training Course in Qatar Schedule