Partner400 Logo
    Sample Agenda
   

SQL for iSeries Developers 

This course is often enhanced with some or all of the following additional topics: Referential Integrity, Writing Trigger Programs, and Using Stored Procedures

'

  All About Us

  Where To See Us

  Magazine Articles

  Downloads

  Rational RDi

  On-site Training

  The RPG Redbook

  Home Page

 

 

 

 

 

 

 

 

 

 



Day 1

SQL Concepts
SELECT statement
LAB: Using SELECT
SQL Functions
LAB: Using SQL Functions
Join, Union, Subselect
LAB: Using Join, union, subselect

 Day 2


UPDATE, INSERT, DELETE statements
Join, Union, Subselect
LAB: Using Join, union, subselect
Data Definition Language
LAB: Creating databases with SQL

Day 3

Embedded SQL and Precompiler Concepts
Host Variables and SELECT INTO statement
LAB: Simple embedded SQL RPG or COBOL programs
Using SQL Cursor operations
LAB: Cursor operations in RPG or COBOL
Dynamic SQL
LAB: Dynamic SQL in RPG or COBOL
SQL Tuning Concepts and Indexing Strategies

     
Return to Home Page  

Want more information?
Got a question or comment about the site?
Please feel free to Contact Us at any time.