DB2 Concepts and Facilities

    

Summary:
The student will be provided with a comprehensive presentation on the differences between relational/non-relational software products, relational terminology, DB2 concepts and facilities, the uses of Structured Query Language (SQL) and the use of the Query Management Facility (QMF).

Duration:
1-2 Days/Lecture & Lab

Audience:
This course is designed for application programmers and programmer/analysts who will be using SQL statements in a high level programming language (COBOL or C) to manipulate DB2 tables in a CICS, TSO or IMS/DC environment. This course would also be beneficial to analysts and database administrators who support application teams

Topics:

• DB2 Concepts and Terminology
• The Application Design Process
• DB2 Table Design
• Basic and Advanced SQL Topics
• Application Programming Considerations
• DB2 Physical Storage
• Referential Integrity Overview
• Program Preparation
• Overview of QMF

Prerequisites:
Students should have knowledge of one the programming languages listed, experience with TSO/ISPF and knowledge of file structures such as VSAM, IMS, or QSAM.

Last Update: February 10, 2012