DB2 SQL for Experienced Users

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 environments, that is z/OS, OS/390, VM/VSE, iSeries, Linux, UNIX and Windows.

Audience

Experienced SQL end users, application programmers, database administrators and user support staff who need more advanced knowledge of SQL.

Prerequisites

Before taking this course, you should have experience with coding and executing basic SQL statements.

These skills can be developed by attending CE12, 'SQL Workshop' or equivalent experience.

Skills Gained

After completing this course, you should be able to:

• 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

Course Outline

• 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

Please note this course replaces CF13GB

DB2 SQL for Experienced Users / CE130GB (CE130GBGB)