From the fundamentals to advanced topics, we have the training you need to succeed with SQL and IBM i.
 |
 | | Using Structured Query Language (SQL) (Online Series)
This series contains the following courses:
SQL Fundamentals
Coding SQL Statements in an RPG Program
Coding SQL Statements in a COBOL Program
SQL Stored Procedures
Using Structured Query Language (SQL) Competency Exam
|
|
|
 | | SQL Fundamentals (Online Course)
Introduction to SQL
Defining and Running a Basic Query
Advanced Querying Capabilities
Making Changes to the Contents of a File
Creating and Deleted SQL Objects
|
|
|
 | | Coding SQL Statements in an RPG Program (Online Course)
Embedding SQL Statements in an RPG Program
Compiling a Program with Embedded SQL Statements
Using an SQL Cursor to Process Multiple Records
Developing a Dynamic SQL Application
SQL and Commitment Control
Performance and Optimization Considerations
|
|
|
 | | Coding SQL Statements in an COBOL Program (Online Course)
Embedding SQL Statements in a COBOL Program
Compiling a Program with Embedded SQL Statements
Using an SQL Cursor to Process Multiple Records
Developing a Dynamic SQL Application
SQL and Commitment Control
Performance and Optimization Considerations
|
|
|
 | | SQL Stored Procedures (Online Course)
Introduction to Stored Procedures
Creating an SQL Procedure
Coding an SQL Procedure
Error Handling
Using a Cursor
Developing a Dynamic SQL Procedure
Working with SQL Procedures
|
|
|
 | | Using Structured Query Language (Online Competency Exam)
This Competency Exam tests your mastery of the objectives for the courses that make up the Using Structured Query Language (SQL) series:
SQL Fundamentals
Coding SQL Statements in an RPG Program
Coding SQL Statements in a COBOL Program
SQL Stored Procedures
The exam is divided into separate parts, one for each course in the series. Successfully completing all parts of the exam demonstrates your proficiency in the skills required to code SQL statements and develop SQL applications.
|
|
|
 | | I Didn't Know You Could Do That with SQL (Online Seminar)
Working with Edit Characters
Basic Subselect
Scalar Subselect
Subselect and INSERT, UPDATE, and DELETE
Subselect and CREATE TABLE
Subselect and Derived Table
Summarizing Data with SELECT
Identifying Potential Duplicate Rows
Search by Sound with SOUNDEX
|
|
|
 | | Creating and Managing Database Objects Using SQL (Online Seminar)
Executing SQL on the i5 and iSeries
Four Types of SQL Statements
Data Definition Statements
Understanding SQL Examples
SQL Statement Examples
Create a Physical File (Table) Using DDS
Create a Table (Physical File) using SQL
Differences Between CRTPF and CREATE TABLE
Resolving the Differences
Can SQL be Saved and Stored Like DDS?
SQL Statement Processor
System i Navigator
Multi-Member Files
|
|
|
 | | SQL/400 (Audio Training)
SQL/400 is a self-paced audiocassette course providing comprehensive, practical training in SQL/400 and its functions.
|
|
