DB2 Overview (Custom for Scotiabank)

Training 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. This course covers up through version 11.
Prior to taking this course, students should have the following skills:Knowledge of one the programming languages listed Experience with TSO/ISPFKnowledge 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 or ALC) 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.
Course 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

Related Scheduled Courses