This course begins with an introduction to the SQL language, and then teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments.his course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.his Boot camp course combines CE121 DB2 SQL Workshop and CE131 DB2 SQL Workshop for Experienced Users.
This course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).
Students should have:ul> computer literacy/li> editing skills/li>
DB2 SQL Workshopul> Introduction/li> Simple SQL Queries/li> Retrieving Data from Multiple Tables/li> Scalar Functions and Arithmetic/li> Column Functions and Grouping/li> UNION and UNION ALL/li> Using Subqueries/li> Maintaining data/li> DB2 SQL Workshop for Experienced Usersul> Introduction /li> Create Objects/li> Join/li> CASE, CAST, Summary Tables, and Materialized Query Tables /li> Using Subqueries /li> Scalar Functions /li> Table Expressions and Recursive SQL/li> UDTs/UDFs and Performance/li>