SQL Query Building in DB2

Course Number:  603-TF
Recommended Duration:  2 days

Intended Audience
Technical personnel who need to retrieve data from DB2 data bases.

Course Overview
This course introduces the non-programmer to SQL, in the context of on-line access to DB2 tables using QMF.  The basic concepts of relational data bases are discussed, along with the techniques for utilizing QMF to retrieve and present information.

Objectives
Students who complete this course will be able to code SQL statements to access DB2 objects using QMF.

Prerequisites:   Experience using ISPF/PDF.

Topics

• DB2 overview

• Relational data base concepts

• SELECT

• QMF Usage

• DB2 sample data bases

• Built-in functions

• Joined queries

• UNION

• Creating DB2 tables

• Views

• DB2 system catalog tables

• Common problems