IBM DB2 UDB Essentials Part 4 - Advanced SQL 
This course teaches the learner how to make use of advanced
SQL techniques to access
DB2 databases in different environments. Indepth coverage is given to creating SQL objects
Case CAST and Summary Tables Joins Subqueries Scalar Functions Recursive SQL UDTs/
UDFs and general performance guidelines. It is appropriate for learners working in all DB2 environments that is OS/
390 VM/VSE AS/400 UNIX
more...