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

• Optional Computer Exercise: Creating Views

Common Problems