This course covers advanced and complex SQL coding strategies for DB2 UDB for z/OS. Hands-on workshops give students the opportunity to apply the topics discussed.

Experienced SQL end users, application developers, database administrators who require advanced knowledge of SQL.

Upon successful completion of this course, the student will be able to perform the following:

• Advanced Data Type Usage which includes Distinct Types, Casting, ROWID, and Datetime Arithmetic
• Sophisticated use of CASE Expressions
• Creation and exploitation of Views
• Complex Inner and Outer Joins including self-joins
• Utilize subqueries for advanced processes such as quota queries and relational division
• Take advantage of the capabilities of Unions using UNION Everywhere
• Code flexible SQL by utilizing Nested Table Expressions
• Declare, fetch, and manipulate data through Scrollable Cursors
• Utilize by both declared and created Temporary Tables
• Control the granularity of Isolation Level using the WITH clause
• Make use of new SQL features of DB2

• DB2 & SQL in Review
• Advanced Data Types & Functions
• Date/Time Arithmetic
• CASE Expressions
• Views
• JOIN
• Subqueries
• UNION
• Nested Table Expressions
• Scrollable Cursors
• Isolation Override; The WITH Clause
• Global Temporary Tables
• V8 SQL Enhancements
• Embedded Programming Features of DB2 (Optional)

This course is designed for persons that have experience coding and executing basic SQL statements. Prior completion of SQL Fundamentals and/or DB2 & SQL Application Programming is suggested.