G540 SQL Query Building in DB2

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

Optional Computer Exercise: Creating Views

Common Problems

G540 / 2 Days

Materials version: V7.x