Welcome to Barker Pacific Group's Home Page

  Topic Outline
• DB2 Relational Concepts
• SQL Statements
• Use of SELECT to Access Tables
• Defining Selection Criteria
• Use of Aggregates
• Report Sequencing
• Use of Multiple Table Joins
• Manipulation of Report Forms
• Saving Queries and Forms

Query Management Facility With SQL

4 days

Description

This course combines lectures and lab work to illustrate the use of IBM Query Management Facility (QMF) and introduce the features of Structured Query Language (SQL).

Audience

Users and application programmers.

Prerequisite

DB2 Concepts or equivalent experience.

Objectives

Students will be able to:

  • develop report formats and layouts using QMF Forms
  • run queries using all features of QMF
  • code SQL calls
  • use SQL to create, update, and manipulate DB2 databases

For questions or comments, contact us at sales@bpgtraining.com or (800)235-8129.

© 1996 - 2003 Barker Pacific Group, Technical Training Specialists
Phone 1.800.235.8129, All Rights Reserved.