Db2 Concepts and Facilities

Summary

This two-day course is designed to provide students with a high-level overview of Db2 z/OS. You will learn about terminology, database concepts, basic SQL, as well as an introduction to application programming concepts and QMF reporting. This course covers up through version 11.

Prerequisites

Before taking this course, students should have knowledge of one the programming languages listed. Students also need experience with TSO/ISPF and knowledge of file structures such as VSAM, IMS, or QSAM.

Duration

2 Days/Lecture & Lab

Audience

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/TM 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

Related Scheduled Courses