G540: SQL Query Building in DB2

TTFlogo2.gif (2585 bytes)

SQL Query Building in DB2 - 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 QMF usage
Computer Exercise: Basic SELECTs

The Sample Databases - Projects and Activities
More complex SQL
   SELECT DISTINCT
   SELECT with multiple conditions
   SELECT with computed values
   NULL and LIKE in SELECT statements
QMF Commands: HELP, DISPLAY, RESET, ERASE, LIST, SHOW, SAVE
   Computer Exercise: SELECT with Complex Conditions

The Sample Databases - Project Activities and Activity Assignments
Aggregation and Sorting in SQL
   Built-in Column Functions
   GROUP BY, HAVING, and ORDER BY
SQL Built-in Scalar Functions
QMF Commands: EXPORT, IMPORT, RUN
QMF Variables
   Computer Exercise: Data Aggregates

Joined Queries
Name Specification
QMF Commands: SET GLOBAL, RESET GLOBAL
Computer Exercise: Joins

Nested Queries (Subqueries)
Outer Joins
UNION and UNION ALL
QMF Commands: EDIT, DRAW, PRINT, ISPF, TSO, RETRIEVE
Computer Exercise: Subqueries and UNION

CREATE and DROP
Other SQL statements
Views
DB2 System Catalog Tables: SYSTABLES, SYSCOLUMNS, SYSVIEWS
Computer Exercise (Optional): Creating Views

Common Problems

Course Objectives
Course description
Home page