SQL is playing an ever-increasing role in the IBM i operating system (aka iSeries, AS/400) in enterprise database design, supplanting legacy DDS. This class shows you how to use industry-standard SQL Data Definition Language to retrieve, analyze and modify the data in an IBM i database.

Recommended schedule: 2 days

Get a Price Quote

Who Should Attend
This class is for existing IBM i programmers and users who want to understand SQL Data Manipulation Language and its use in IBM i.

(Note: This class does not cover Data Definition Language or embedded SQL programming concepts. Those topics are also available as separate topics, or in a combined class: “Accessing Data, Database Design and Embedded SQL Programming.”)

Prerequisites
In order to successfully complete this course, students should have completed the following courses, or have equivalent knowledge/experience:

• IBM i Concepts

What You Will Accomplish
At the end of the course, students will be able to:

• Use interactive SQL to retrieve data from table
• Sort and select retrieved data
• Summarize data with SQL column functions
• Create complex queries which join files and multiple SELECT statements
• Nest SELECT statements within other SELECT statements

Get a Price Quote

What You Will Receive
Each student receives:

• Custom printed handout, containing class notes
• Completion certificate

Course Outline
The class covers these topics:

• SQL Overview
• Interactive SQL
• Using the RUNSQLSTM Command
• SQL and Operations Navigator
• The SELECT Statement
• Sorting Data
• Data Filtering
• Built-in Functions
• Summarizing Data
• Joining Files
• Joining SELECT Statements
• Using Subselects
• INSERT, UPDATE, and DELETE Statements

Get a Price Quote

Hands-on Labs

• The SELECT Statement
• Built-in Functions
• Summarizing Data
• Joining Files
• Joining SELECT Statements
• Using Subselects
• INSERT/UPDATE/DELETE Statements

Get a Price Quote