Summary
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.
Topics Covered
- IBM i Access Client Solutions (ACS) – Run SQL Scripts
- What is SQL / Types of SQL Commands / Terminology
- Select Statement
- Generating new columns based on mathematic operations or by
concatenating character values - SQL Predicates
- Scalar Functions for string manipulating, date calculation and rounding
- OLAP-Ranking Functions
- Case Clause – If – Then – Else Clause
- Joining Tables / Views
- Group By and Multi-dimensional Grouping (Sub-Totals/Totals)
- Common Table Expressions
Software Required
IBM Access Client Solutions – IBM’s Java based IBM i Interface
Group Discounts Available
Birgitta Hauser
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application and database modernization.
Currently she is an independent consultant and works in Consulting, Application Modernization IBM i and especially Database Modernization on Db2 for i. She also provides individual programming on IBM i to her customers. Additionally, she also works in education as a trainer for RPG and SQL developers.
Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences in Germany, other European Countries, USA and Canada. In addition, she is co-author of two IBM Redbooks and also the author of several articles and papers focusing on RPG and SQL for the ITP Verlag (a German publisher), IT Jungle Guru and IBM DeveloperWorks.In 2015 she received the John Earl Speaker Scholarship Award. In 2018 she received the Al Barsa Memorial Scholarship Award.
IBM Champion 2021
