Duration
3 days
Course Overview
This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 enviroments, that is z/OS, OS/390, VM/VSE, iSeries, Linux, UNIX, and Windows.
Audience
This course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL.
Prerequisites
You should have experience with coding and executing basic SQL statements.These skills can be developed by attending CE12, "SQL Workshop",or equivalent experience.
Course Objective
- Use some of the OLAP features of DB2, such as GROUPing and RANKing functions
- Discuss basic relational database concepts including: databases, tables, indexes, and referential integrity
- Create tables, views and indexes
- Use referential integrity, check constraints and triggers
- Use outer join, join tables to themselves
- Use CASE and CAST
- Understand the impact of Summary Tables, Materialized Query Tables, and temporary tables
- Use complex subqueries
- Use a greater number of scalar SQL functions
- Use advanced SQL constructs including recursive SQL and table expressions
- Understand User-Defined Distinct Types and User-Defined Functions
- Avoid several of the most common causes for poorly-performing SQL
Key Topics
- Introduction, SQL review, OLAP functions
- Creating objects (tables, indexes, views, etc.)
- Join
- CASE, CAST, Summary Tables, MQTs, temporary tables
- Subqueries
- Scalar Functions
- Table Expressions and Recursive SQL
- User-Defined Distinct Types and Functions
- Performance Considerations
Programme scope, delivery arrangements and suitability are confirmed during enquiry.