GASI EDUCATION CENTER
SYLLABUS
“iSeries DATA BASE STRUCTURE QUERY LANGUAGE”
Course Code : GSDB3
♦ COURSE OBJECTIVE
This GASI course is designed to provide comprehensive partical training in Structure Query Language/400.
♦ COURSE PREREQUISITES
Students taking this course should have completed the following GASI AS / 400 courses or have equivalent experiences :
AS / 400 Introduction
AS / 400 Workstation Operations
AS / 400 System Operations
AS / 400 Data Base Fundamental
AS / 400 Data Base Advanced
RPG or COBOL programming experience
♦ COURSE PROGRAM CONTENTS
⇒ SQL Concepts
- Using SQL across multiple operating systems
- Collections
- Tables
- Rows and Columns
- Views
- Indexes
- Cursors
- Communication Areas
⇒ SQL / 400 Data Definitions Statements
- SELECT
- UPDATE
- WHERE
- GROUP BY
- UNION
⇒ SQL / 400 Functions
- SUBSTRing
- MINImum
- MAXImum
- AVeraGe
- COUNT
- DIGITS
- Concatenate
- Arithmetic
⇒ Interactive SQL / 400
- STRSQL ( Start SQL ) Command
- 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
- Dynamic Data Selection
- SQL Pre – Compiler
- SQL Optimizer
♦ COURSE METHODS
This training program is designed to provide participants with an interactive learning experience. As the word implies, this course does more than just provide a lecture. Instead, participants will actively involved in the operation of the AS / 400. In addition, participants will be called on to test participants knowledge by answering some short quizzes. Participants will also perform some Hands On exercises.
♦ COURSE DURATION
3 Days