Loading Course Schedule...
PT8149
Summary
This course presents advanced DB2 SQL syntax in an easy-to-understand format. It enables the student to learn the more advanced features of DB2, including OLAP functions and performance considerations. This course is designed to be taught on DB2 for LUW (LINUX, UNIX, and Windows). It includes features up through v9.7.
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 an Introduction to DB2 and SQL. Proficiency with Windows, Notepad (or another Windows-based text editor), the mouse, and the PC in general is also assumed.
Duration
2 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 DB2 SQL for distributed platforms.
Topics
Review of SQL Fundamentals::Subqueries::Table Expressions, and Set Operators::Expressions and Scalar Functions::Inner and Outer Joins::Creating DB2 Objects, including Global Temporary Tables::Aggregation::OLAP Functions::Recursive SQL::Performance Considerations::Visual Explain::Overview of Dynamic SQL