Training offering

DB2 SQL for Experienced Users

Description

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.

Objectives

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

Participants

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

Prerequisite(s)

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.

Options

This course covers the following major 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