AS/400 Links Partner with Rochester Institute Contact Us
Training Catalog Free Downloads Privacy / Usage


IBMi and AS400 Training
HOME >> Training Catalog >> iSeries SQL/400

iSeries SQL/400 (ADB3)
Author: ATS
$995




Description
iSeries SQL/400 is a self-paced, audio-cassette 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 iSeries 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
Documenting the Data Base Model
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 programmers.
Prerequisites
iSeries System Operations
iSeries Database Administration I
iSeries Database Administration II
Interactive RPG or COBOL programming experience
Format
Self-Instructional
Materials
15 Audio CDs
Student Text
Workbook
Interactive Media
Time Required
Approximately 16 Hours


iSeries SQL/400 (ADB3)
Author: ATS
$995



Rochester Training
     RPG Skills Accelerator - Volume 2
     RPG Skills Accelerator
     e-RPG Powertools – Stone on CGIDEV2
     WebFacing Now! WAS-Express Edition
     JDBC and Record Level Access
with IBM AS/400 Toolbox for Java
     Turbo Query/400
     XML Web Services for RPG Programmers
     RPG Modernization with WDSC (from III to IV to /Free)
     Microsoft .NET for RPG Programmers (Visual Basic Version)
     Microsoft .NET for RPG Programmers (C# Version)
     iSeries Navigator for Programmers (V5R3 Edition)
     SQL for RPG Programmers
     Subprocedures for RPG Programmers
     RPG Web Skills Accelerator
     WDSC for RPG Programmers (Version 7)
     WDSC for RPG Programmers (Version 6)
     Microsoft Word with the iSeries
     Microsoft Excel with the iSeries
Operations Training
     iSeries Advanced System Operations
     iSeries System Operations
     iSeries Startup Operations
     iSeries Security
     iSeries Work Management
User Training
     iSeries Query for Users
     iSeries Query for Advanced Users
     iSeries RPG/400 Programming
     iSeries RPG/400 Interactive Programming
     iSeries RPG/400 Advanced RPG Programming
     iSeries RPG/400 Subfile Programming
     iSeries RPG IV Programming
     iSeries Data Base Administration I
     iSeries Data Base Administration II
     iSeries Control Language Programming
     iSeries CL and Programming Techniques
     iSeries SQL/400
     iSeries Advanced COBOL/400 Programming
     iSeries Interactive COBOL/400 Programming
     iSeries COBOL/400 Programming
     iSeries COBOL/400 Subfile Programming
     iSeries Program Development
Training Bundles
     iSeries Operations & Administration Bundle
     Microsoft Word and Excel with the iSeries Bundle
     RPG Skills Accelerator & RPG Web Skills Accelerator
     RPG Basics and Beyond (training bundle)
     RPG Skills Accelerator & RPG Skills Accelerator - Volume 2