QMF AD HOC Queries And Reporting Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 105
Course Abstract:	This course uses lecture and hands?on labs to explain the Query Management Facility (QMF) capabilities including the Query By Example (QBE), 'Prompted Queries' and QMF's report design and formatting capabilities. Also, basic Structured Query Language (SQL) is discussed for accessing DB2 table data directly.
Audience:	This course is designed for business unit personnel, end users, managers, technical and non-technical professionals, and other personnel needing the ability to do simple data retrieval, table processing, and report generating.
Duration:	3 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Explain the Query Management Facility (QMF) > Explain the DB2 UDB SQL Relationship to QMF > Recognize how to access DB2 UDB Table data > Use Sophisticated QMF Reporting techniques
Course Topics:	Using SQL with QMF QMF Commands and Functions QBE - Query by Example Prompted Query Report Formatting, Saving Queries, Forms, and Data QMF Table Editor QMF Batch Reporting QMF Production Reporting and REXX Possible Client/Server Applications
Prerequisites:	DB2 Concepts and Facilities (RT 01) is recommended, but not required

QMF AD HOC Queries And Reporting Course