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
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
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
Hands-on Labs
The SELECT Statement
Built-in Functions
Summarizing Data
Joining Files
Joining SELECT Statements
Using Subselects
INSERT/UPDATE/DELETE Statements
Limited Time!
Special pricing for the
Ontario area. Book a 5-day onsite class for as little as USD $900/day. Get a price quote today. Ask for offer CA900.
