iSeries SQL/400

Now Released on Audio CD

Course Code: ADB3

Description
SQL/400 is a self-paced, audio based driven course providing comprehensive, practical training in SQL/400 and its functions

Upon completion you'll be able to:

Create a database (SQL collection) using SQL data definition language statements.
Populate an SQL collection using SQL data manipulation language statements.
Use the SQL interactive environment to select, sequence, join, and summarize data from SQL tables and 400 files.
Use SQL queries to extract information about the SQL collection itself.
Use SQL statements to access physical and logical files created outside of the SQL collection.
Use SQL interfaces within RPG/400 and COBOL/400 programs.
Use SQL calls in interactive HLL programs that dynamically create access paths to data.
Create reports using Query Management Queries and Forms.
Pass parameters from HLL programs to Query Management Queries.
Convert Query/400 queries to Query Management Queries and Forms.

 

SQL Concepts
Using SQL across Multiple Operating Systems
Collections
Tables
Rows and Columns
Views
Indexes
Cursors
Communication Areas

SQL Data Definition Statements
CREATE COLLECTION
CREATE TABLE
CREATE VIEW
CREATE INDEX
SQL Data Manipulation Statements
SELECT
INSERT
UPDATE
WHERE
GROUP BY
UNION

SQL Predicates and Functions


Commitment Control


Query Management Queries and Forms

Creating Queries and Forms
Passing HLL Parameters to Queries
Converting Query/400 to QM Queries and Forms
Interactive SQL/400
STRSQL (Start SQL) Command
Setting and Saving SQL Session Defaults
SQL Entry Screen
Executing SQL Statements

Embedded SQL/400 in High-Level Languages

COBOL and RPG Examples
Accessing SQL Tables and Cursors
Serial and Scrollable Cursors
Updateable Cursors
Dynamic Data Selection
SQL Precompiler
SQL Optimizer

SQL/400 Subqueries

Interactive and Embedded
Simple Subqueries
Compound Subqueries
Correlated Subqueries

Audience
iSeries-AS/400 programmers

Prerequisites
System Operations
Database Administration I
Database Administration II
Interactive RPG or COBOL programming experience
Format
Self Study Interactive

Materials

15 Audio CD's
Student Text
Workbook
Interactive Software Media
Time Required
Approximately 16 Hours

Price
£ 695


back