System i: Interactive SQL UK Classes & Lessons (IBM System i)

Also known as: ISSQLGB

About this class

Although a late arrival on the iSeries, SQL has rapidly become the de-facto standard for database access across all computer systems. This one day course provides an introduction to using SQL interactively on the iSeries.

Who will the lesson benefit?

Application development staff needing to view, create or modify test data quickly and simply. Application support staff who need to manipulate data within database files.Technical users of Query/400 requiring a more direct interface into database files.

What delegates will learn

This course will enable delegates to:

Start an interactive SQL session.
Enter an interactive SQL statement.
Select SQL parameters and options.
Use SQL to display the contents of a database file, including row and column selection.
Use SQL to update data in a database file.
Use SQL to add and remove rows.
Use SQL verbs and clauses.
Use SQL to create views and indexes.

What prerequisites are required

iSeries System Facilities(ISSFC)Introduction to Relational Databases(IRD)or equivalent experience is acceptable.

Contents of this class

What is SQL?
Starting Interactive SQL
Entering SQL statements
Interactive SQL session services
Selecting libraries, files and fields
Prompting SQL statements
SQL terminology
Creating collections
Creating tables
Inserting rows into a table
Retrieving rows from a table
Deleting rows from a table
Updating rows in a table
Retrieving rows from more than one table
Creating views over a table
Creating views over more than one table
Working with indexes