QMF Essentials (Ver 3.1)

Outline

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Topics Include
6. Duration
7. Minimum Requirements
8. Media

Description

Teaches the creation of data base queries using three languages: SQL, Prompted Query Mode and Query by Example (QBE).

Audience

End users, programmers, designers, analysts and managers.

Prerequisites

Knowledge of database structure and principles.

Topics Include

Introduction

• Relational Database
• Usage of Tables, Columns, Rows, Primary Key, Foreign Key
• Structured Query Language (SQL)
• Query Management Facility (QMF)
• Database 2 (DB2)
• Difference Between User Defined Tables and System Tables
• System Relationship Between: MVS, DB2, SQL, TSO, & QMF

Creating a QMF Query

• QMF Home Panel
• Getting Help in QMF
• Using Prompt Panels
• The User Profile
• SHOW Command
• Setting Profile Values
• Saving Profile Values
• Creating a Query
• Selecting a AMF Table
• DRAW Command
• Selecting Specific Columns
• Selecting all Columns
• Building Row Conditions
• Null Values
• Editing a Query
• Commenting a Query
• Inserting Rows in a Query
• Deleting Rows in a Query
• Running a Query
• Interrupting a Query
• Report Format
• Creating a Prompted Query
• Converting a Prompted Query

Ordering & Grouping

• Selecting on Multiple Conditions - AND, OR, IN, BETWEEN operators
• Nesting Multiple Conditions Using Parentheses
• Selecting on Partial Value (LIKE Operator)
• Negation (NOT Operator)
• Create Computed Columns - Arithmetic Operators, Column Functions
• Putting Selected Rows in Order
• (ORDER BY Clause) - Column Name vs. Column Number
• Grouping Rows of Data (GROUP BY Clause)

Formatting Reports

• Using Forms to Customize Reports
• Getting Help When Editing a Form - CHECK Command
• Using Control Breaks in a Report
• Creating Headers & Footers
• Adding Final Totals
• Performing Calculations in a Report
• Saving a Form
• Scrolling Through Large Reports

Displaying a Report as a Chart

• Using Forms to Customize Chart
• Creating Chart Headings
• Changing Chart Types - ICUFORM
• Saving a Chart
• Saving & Re-Running Queries

Saving & Naming Queries

• Using Variables in a Query
• Displaying Names of Saved Queries
• Display a Saved Query
• Delete a Saved Query
• Creating a Simple Procedures (PROC)
• Displaying Names of Saved PROCs
• Displaying a Saved PROC
• Delete a Saved PROC

Joining & Merging Tables

• Nesting Querying Using Subselects
• Merging Columns from Multiple Tables
• Union vs. Join

Data Manipulation Language (DML)

• Inserting Rows into a Table
• Deleting Rows in a Table
• Changing Values in a Table
• Using Table Editor to Insert, Update & Delete Rows

Data Definition Language (DDL)

• CREATE, ALTER & DROP a Table
• Differences Between Synonyms, Views, Indexes & Tables
• Create & Drop Synonyms, Views & Indexes

DB2 Catalog

• The Role of the Catalog
• Querying & Updating the Catalog
• System Tables & User Tables

Overview Of QBE

• QBE vs. SQL vs PROMPTED
• Selecting QBE
• Writing a QBE Query
• Using QBE to Select Columns & Rows

Duration

11 hrs

Minimum Requirements

CGA Color Monitor; 512KB RAM; 2MB Hard Disk Space; DOS 3.3

Media

Diskette
CDROM

© Copyright Serebra Learning Corp., 2002