AS/Credentials iSeries Interactive SQL Class

Description: Introduction to the SQL language on the iSeries. SQL is a powerful tool for database manipulation on many platforms. This class will review implementation principles on iSeries using hands on examples and SQL tools. This course is designed for programmers and users who have some understanding of database concepts.

Class Details:

• Prerequisites: iSeries Basic Overview or equivalent. Students should be comfortable with the editor (SEU) on the iSeries, and be comfortable writing simple RPG programs. Students should have a basic understanding of programming concepts, and be comfortable working on the iSeries.
• Duration: One Day
• Cost: $450/day
• Associated Roadmap
• Downloadable flyer

Course Content:

SQL Tools:

• STRSQL
• Query Manager

SQL Statement Syntax

• Selecting which fields to display
• Extracting specific records from the database
• Sorting the data into a specific order
• Performing totals
• Built in functions

Data Manipulation

• Adding records to a database
• Changing records
• Deleting records
• Creating new tables
• Deleting a table

Advanced SQL topics

• Joining files
• Sub queries
• Embedding SQL statements in an RPG program
• Security
• Stored procedures
• Connecting to remote systems
• Commitment control