This course aids the student with learning to manipulate and retrieve data from DB2 tables. The student will understand the DB2 environment and the data structures within the DB2 environment. Lab assignments will be used to provide a better comprehension of the lectured material.
The student should have minimal experience with TSO and ISPF Panels.
3 Days/Lecture & Lab
This course is intended for application programmers, consultants and end users who will be manipulating and retrieving data from DB2 tables.
- DB2 Concepts and Terminology
- QMF Concepts and Terminology
- Basic and Advanced SQL Overview
- Basic QBE
- QMF Command Overview
- Report Formatting
- Security Overview