Basic QMF for Workstations

PT27248
Summary
During this course, you will develop QMF queries using Structured Query language (SQL). The class provides basic coverage of the capabilities and uses of QMF, with a focus on learning the Structured Query Language (SQL) and some of the reports that can be produced using QMF forms. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops.
Prerequisites
No previous experience in SQL is required. Ability to use TSO and ISPF is recommended.
Duration
2 Days/Lecture & Lab
Audience
Business professionals who are exposed to or are required to perform the activities associated with data stored in a Db2 relational database.
Topics
  • Relational Database Concepts
  • QMF for Workstation Overview
  • Basic Data Manipulation
  • QMF Forms (Formatting)
  • Intermediate Data Manipulation
  • Reports with Control Breaks
  • Built-In Functions

Related Scheduled Courses