IBM i (AS400, iSeries, i5, System i) Programming - Course Catalogue

Basic :

Database on IBM i

Physical Files
Logical Files
Join Logical Files
Keyed Logical Files
Non-Keyed Logical Files


CL Programming
RPG Programming

Subfile Programming

Load-All Subfile
Expanding Subfile
Single Page Subfile

RPG-SQL Programming

Embedded SQL RPG Programming
Different Types of Cursors

COBOL Programming

Comprehensive COBOL/400 and COBOL ILE Training

Advanced :

SQL Programming

SQL Stored Procedures (External & Internal)
SQL Triggers
SQL Constraints
SQL Functions (UDF & UDTFs)
Complex SQL Queries

Database on IBM i

SQL Tables
SQL Views
SQL Indexes
SQL Joins
SQL Unions

Advanced Programming - RPGLE

ILE Fundamentals
Advanced RPGIV Programming
RPG ILE Programming
Free-form RPG Programming

IBM i Comprehensive Course :

IBM i Comprehensive Course

This is a complete Course of IBM i - including Database, CL and RPG or COBOL programming.

File Systems and Query Programming:

Files Systems on IBM i

Different file Systems on IBM i
Purpose of file Systems on IBMi

Query on IBM i

WRKQRY (Work with Query)
Query Management (QMQRY)

Tools and Utilities:

IBM i Tools

Job Scheduler
Advanced Job Scheduler
i Series Navigator
SQL Functions (UDF & UDTFs)
Rational Developer for i (RDi)

Third Part Tools

ROBOT Scheduler

IBM i (AS400, iSeries, i5, System i) Administration - Course Catalogue

IBM i Operations
IBM i Security
IBM i System Management
IBM i Backup Recovery and Media Services (BRMS)
IBM i Management Central