SQL/400 (Audio Training)

Course Description:
QL/400 is a self-paced audiocassette course providing comprehensive, practical training in SQL/400 and its functions. Included with course are eleven audiocassettes; Student text; Workbook; Interactive media

Time required: Approximately 16 hours

When you have completed of this course, you will 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
   • Use SQL queries to extract information about the SQL collection itself
   • Use SQL statements to access physical and logical files created outside 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

Audience: Programmers and Database Administrators

Prerequisites: AS/400 System Operations, AS/400 Database Administration I, AS/400 Database Administration II, Interactive RPG or COBOL programming experience

Course Outline:
   SQL Concepts
   Using SQL Across Multiple Operating Systems
   Collections
   Tables
   Rows and Columns
   Views
   Indices
   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 Subqueries
   Simple Subqueries
   Compound Subqueries
   Correlated Subqueries

Course Details:

Level:	Advanced
Subject:	SQL
Length:	16 hrs.
Publisher:	ATS
Publish Date:	June 1998