The Advanced SQL for DB2 course covers more advanced aspects of the Structured Query Language (SQL), with specific reference to the IBM DB2 database. Contents include advanced table joins, advanced operators, expressions, operators, views, user defined functions, stored procedures (DB2 SQL PL) and database performance considerations.

Delegates who complete the dvanced SQL for DB2 course will be able to:

• Create more sophisticated joins between tables.
• Create advanced queries using expressions and operators.
• Understand factors that affect database performance.
• Use type conversion functions to produce formatted text.