SQL Coding Workshop - Topical Outline

Introduction - Overview of DB2
The Sample Databases - Employees and Departments
Relational Operations: Select, Project, Join
Overview of DB2 SQL - the SELECT statement: WHERE clause
Basic SPUFI usage
   Computer Exercise: Introducing SQL and SPUFI

SPUFI Processing and menu options
The Sample Databases - Projects and Activities
SELECT DISTINCT
SELECT with multiple conditions
Computed values, NULL, and LIKE in SELECT statements
   Computer Exercise: Complex WHERE Clauses

SPUFI Defaults
Autocommit and explicit Commit and Rollback
The Sample Databases - Project Activities and Activity Assignments
Built-in Column Functions
SELECT: GROUP BY, HAVING, and ORDER BY
Built-in Scalar Functions
   Computer Exercise: Aggregates and Sorting

Joined Queries
Name Specification
   Computer Exercise: Joins

Subqueries
Outer Joins
UNION
   Computer Exercise: Subqueries and UNION

Other SQL statements
CREATE and DROP
Primary and Foreign Keys
UPDATE, DELETE, and INSERT
   Computer Exercise: Changing Tables

Views
DB2 Security
   Table Security Features
   GRANT/REVOKE
DB2 Catalog Tables: SYSTABLES, SYSCOLUMNS, SYSTABAUTH, SYSVIEWS
   Computer Exercise: Querying the Catalog Tables

DB2 Query Performance
   EXPLAIN
   PLAN_TABLEs
   Index Usage

Course information: G-550 / 3 Days   These Materials © Copyright 20077 by Hunter Cobb    V3.x

Course Objectives
Course description
Home page

this page last updated: 05 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.