Description

This course starts with a review of basic SQL, such as Select, Scalar Functions, Joins, SubQueries, Unions, and Insert/Update/Selects. Advanced SQL features are then presented. Hands-on practice reinforces the lectures. Students work in the current version of DB2, but the lectures also highlight changes coming in the next version.

Audience

Experienced data processing personnel who have used SQL and need to refresh or deepen their current skills and learn to use advanced SQL features.

Prerequisite

Six months experience using DB2 SQL.

Objectives

Students will be able to:

• Select rows of data from DB2 tables
• Use QMF and SPUFI to run SQL statements
• Use the WHERE clause to select specific rows of a DB2 table
• Build queries using the ORDER BY, GROUP BY, and HAVING clauses
• Join tables to get information from each
• Change tables using the INSERT, UPDATE, and DELETE statements
• Describe the security provided by GRANT and REVOKE
• Discuss the design considerations of referential integrity
• Understand overall DB2 performance considerations
• Run the EXPLAIN PLAN SQL statement and analyze the results
• Discuss additional SQL features from the latest DB2 version
• Use the DB2 Catalog and Runstats Utility
• Understand the concepts of DB2 efficiency
• Discuss EXPLAIN and Visual Explain
• Discuss other advanced topics, such as recursive SQL, Group By _ CUBE, and ROLLUP