Maintec

TRAINING


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

Programming

  • 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

  • Aldon
  • Turnover
  • 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



ENQUIRY FORM


Required
Required
Required
Required
Required
Required