This self paced workshop with labs, quizes and over twelve hours of video instruction, is an introduction into SQL (Standard Query Language), for selecting, joining and aggregating data located in database tables. In this workshop you will be introduced to IBM i Access Client Solutions (ACS) – Run SQL Scripts which is IBM’s strategical product for entering and executing SQL Statements. At the end of this course your developers and database administrators should be able to generate and run SQL SELECT-Statements where data located in Tables is altered and sorted, compose data located in different tables by joining the tables and accumulate data and integrate sub-totals and totals in the results.Class duration varies and is based on student activity – maximum of 2 weeks.
