SQL for iSeries i5 Users

Duration: 
2 days
Codes: 
SQL,I5

Overview

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.

Audience

This course is intended for i5 and iSeries users who wish to access data and use the facilities provided by SQL. Programmers who need to understand and use SQL in their work will also benefit from attending.

Prerequisites

A good familiarity with the iSeries 400 and its database is expected.

Course Outline

  • 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.

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

Upcoming Dates

  • GREEN This class is Guaranteed To Run.
  • SPVC - Self-Paced Virtual Class.
  • Click a Date to Enroll.
Course Location Days Cost Date
Midlands
Birmingham2 800 £800 2019-02-18
Manchester
Manchester2 800 £800 2019-02-18
Glasgow
Glasgow2 800 £800 2019-02-18
Onsite
Onsite2 1000 £1000 2019-04-23