SQL for iSeries/i5 Users

2 Day Course
Code SQLIS

Book Now - 1 Delivery Method Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

Overview

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.

Modules

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

Prerequisites

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

Print

Share this Course

Share

Recommend this Course

Sections