|
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.
Audience: This course is designed for programmers and users who have some understanding
of database concepts.
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.
Course Content:
SQL Tools:
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
Duration: One Day
Click here to register on-line or review
our current Course Schedule.
Download
class flier in PDF format.
|