Advanced SQL for DB2 UDB for LUW

    

Summary:
This course is designed for the SQL professional who wants to get more "bang for the buck" out of DB2, especially DB2 Universal Database. A common complaint is that so much money is sunk into relational database management systems, only to have them end up as glorified flat-file processors due to inefficient SQL and misguided application design. Why select all the columns and all the rows only to have your application program (or third-party tool) do the filtering? Why select detail-level rows when what you want to see is summarized results? And what about all the new advanced features added to SQL on the DB2 Universal Database platforms?This course presents advanced SQL syntax in an easy-to-understand format, demystifying even the most complex of the new features. It enables the attendee to return to work much better prepared to avail him- or herself of the full power of the DB2 engine.

Duration:
3 Days/Lecture & Lab

Audience:
This course is designed for application programmers; database administrators, sophisticated end users, and anyone who needs to know more about the intricacies of SQL.

Topics:

• Review of SQL Fundamentals
• Familiarization and Review
• Subqueries
• Two-dimensional Matrices
• VALUES, Table Expressions, and Set Operators
• Expressions and Scalar Functions
• Inner and Outer Joins
• Aggregation
• Grouping Sets and Super Groups
• Recursive SQL
• Object-Relational Features
• User-defined Database Objects
• Performance Considerations
• Visual Explain
• Review and Summation

Prerequisites:
Before taking this course, you should be able to code basic to intermediate SQL statements and have real-world experience coding such statements. You can develop these skills by attending either Introduction to DB2 and SQL or DB2 and SQL Fundamentals. Proficiency with Windows, Notepad (or another Windows-based text editor), the mouse, and the PC in general is also assumed.

Last Update: May 20, 2012