This course is designed to teach new z/OS Database Administrators the z/OS environment and concepts. Students will gain a working knowledge of TSO, ISPF and JCL. The lecture components and hands-on labs will give each student the opportunity to understand and use the basic facilities of the z/OS environment.
The second part of this course focuses on introducing the student to database administration for Db2 z/OS, as well as best practices used to write queries using Db2 SQL up to and including version 11 of Db2 for z/OS. The student will demonstrate how to effectively and efficiently use SQL to extract and manipulate data in Db2 database objects, with an emphasis on performance considerations.
There are no prerequisites for this course.
5 Days/Lecture & Lab
This course is intended for personnel who are new to the MVS operating system or those who are seeking a refresher course in basic to intermediate JCL programming execution.