Computer Business International, Inc., is an on-site or virtual, hands-on instructor led
Db2 for z/OS education, training and consulting company
with over 30 years of Db2 experience.
5605 Riggins CT., Suite 200 Reno, NV 89502
Introduction to Db2 for z/OS and Structured Query Language
DETAIL COURSE OUTLINE - 1/2 Day Sessions
This hands-on workshop trains the Db2 Query User, Application Developer and DBA to code complex SQL statements to achieve optimum performance.
Duration: 4 day, 1/2 day sessions, Instructor led, Virtual Class with hands-on LABS. Half Day is approximately 2 hours of lecture and 2 hours of lab time.
Audience: This course is primarily directed toward new users of Db2 for z/OS and SQL basic coding.
Prerequisites: Basic computer concepts, and basic knowledge about relational data management systems.
Workshops: z/OS platform will be used to run class problems coded by the students.
Course Objectives:After successful completion of this course, the student will be able to describe relational database management system concepts, the basic structures in a Db2 for z/OS subsystem and write basic SQL statements.
Introduction to Db2 for z/OS
and Structured Query Language
Half-Day Session Class Outline:
Relational Database Management Systems:
Mainframes systems overview
Using Db2 on z/OS system basics
Logon / Logoff a TSO/ISPF session
Allocate sequential/partitioned dataset
Workshop - Lab Exercises:
Logging on to z/OS and allocating a data set to use in our exercises.