Contact Us: +62 21 750 2345 - gasi.csr@ptgasi.co.id

 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

Back to Top