Db2 Concepts and Facilities

Catalog Home Databases, Business Intelligence & Data Science Db2 for Z/OS

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.

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.

2 Days/Lecture & Lab

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

  • 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


Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media