Db2 Concepts and Facilities

Catalog Home IBM Mainframe, Midrange & ISV Products Db2 for z/OS
75.101.243.64
Your Training Location:  

Db2 Concepts and Facilities

  Add Course To Watch List
  View Full Course Outline
  Request A Public Course
         In Your Area
  Request A Quote For A
        Private Class
Delivery Options & Status:
Instructor Led
Loading Course Dates...
Failed
No available dates in this city.

  Available by Request
{{date.date_begin | date:'M/d'}} - {{date.date_end | date:'M/d/yyyy'}}
   Free{{date.date_price}}
 
ViewHide Additional Dates

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

< >

Search our catalog of over 500 course titles!

Copyright © 2020 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media