iSeries SQL Introduction Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	AS 67
Course Abstract:	This course applies to System i, iSeries, and AS/400 systems. SQL is a very powerful programming and database language that is widely used in business today. SQL is frequently used in AS/400 high level languages as an alternate means to access the database. Learn how to access AS/400 database files using SQL. Learn how to create, maintain, and query the database using the interactive SQL interface supported by System i Navigator. This course is based on System i navigator (PC interface) but can also be taught for green-screen use. We recommend the PC interface version.
Audience:	This course is designed for experienced AS/400 programmers and very skilled AS/400 users who want to learn how to use the SQL as a means to access the DB2 UDB for iSeries database. This course is recommended for users who need to perform simple queries.
Duration:	2 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Use Data Definition Language (DDL) to describe tables and views > Use UPDATE, INSERT, ALTER and DELETE to modify SQL tables > Use the SELECT statement to extract data from tables and views > Code SQL queries that use column and scalar functions > Code SQL queries that use inner and outer joins
Course Topics:	SQL concepts SQL objects and data definition Extracting data using SELECT Functions JOIN and UNION Sub-SELECTs
Prerequisites:	Experience with programming is required.

iSeries SQL Introduction Course