Db2 Concepts and Facilities

PT1819
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