AUDIENCE:   i5 and iSeries users who wish to access data and use the facilities provided by SQL. Programmers who need to understand and use SQL in their work. PREREQUISITES:   A good familiarity with the iSeries 400 and its database is expected. Users who are familiar with using Query/400 or programmers would be suitable. DURATION:   2 days. Hands on. OBJECTIVES:   After attending delegates will be able to: · Access SQL DML and DDL using STRSQL · Use the Operations Navigator interface · Use SQL statements to extract and update data · Create and drop files (tables) · Use the SQL Query Manager COURSE CONTENT:   Introduction to SQL DDL/DML SRTSQL and Ops Nav Select Join Grouping data Scalar and Group Functions Insert, Update, Delete Union Subselect Create and Drop