Course Description

SQL Query Building in DB2

This course: course objectives; course outline;
DB2 curriculum; Topic list; Course list; Home page

Benefits

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

Audience

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

Prerequisites

Experience using ISPF/PDF.

IBM Materials Requires

This course is drawn from these IBM manuals; access to them in the classroom is desirable but not required:

QMF Reference (current version)
DB2 SQL Reference (current version)

• 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

Exercises

There are six machine exercises.

Special Note

This course's content overlaps heavily with the material in course G-565 (QMF for Programmers).