SQL for iSeries/i5 Users

2 Day Course

Book Now - 1 Delivery Method Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online


This course is aimed at i5 and iSeries users who wish to access data and use the facilities provided by SQL and programmers who need to understand and use SQL in their work.

After attending delegates will be able to:

  • Access SQL DML and DDL using STRSQL
  • Use the Operations Navigator interface
  • Use SQL statements to extract and update data
  • Create and drop files (tables)
  • Use the SQL Query Manager

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.


Course Topics (10 topics)

  • Introduction to SQL DDL/DML
  • SRTSQL and Ops Nav
  • Select
  • Join
  • Grouping data
  • Scalar and Group Functions
  • Insert, Update, Delete
  • Union
  • Subselect
  • Create and Drop


A good familiarity with the iSeries 400 and its database is expected. Users who are familiar with using Query/400 or programmers would be suitable.

Course PDF


Share this Course


Recommend this Course