DB2 SQL Workshop for Experienced Users

Course Overview

This course builds on the DB2 SQL Workshop (CF12GB) and enhances your existing SQL knowledge. There is ample opportunity to try out 'advanced' statements in practical sessions.

Audience

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

Skills Gained

Skills Gained

:

• Use 'advanced' SQL constructs, such as recursive SQL, CASE expressions, check constraints, and triggers
• Discuss basic relational database concepts, such as referential integrity, tables, and indexes
• Create DB2 objects such as tables, indexes and views
• Use inner and outer joins
• Use more complex subqueries
• Use the major scalar functions, and the 'newer' GROUPing column functions
• Understand the use and impact of summary tables and table expreressions

Prerequisites

You should complete the DB2 SQL Workshop (CF12GB) and/or have three to six months of SQL experience.

• DB2 SQL Workshop (CF12GB)

Course Outline

Topics

Include:

• Introduction and Review
• Using CUBE and ROLLUP
• Creating DB2 Objects (tables, views, indexes.....)
• Inner and Outer Join
• CASE, casting and summary tables
• Subqueries
• More on Scalar Functions
• Table Expressions and Recursive SQL
• User-Defined Types and Functions 0 Some Performance Considerations when writing SQL

DB2 SQL Workshop for Experienced Users / CF13 (CF13GB)