System i: Interactive SQL

Course Overview

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.

Audience

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.

Skills Gained

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.

Prerequisites

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

Course Outline

• 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