z/OS Overview and Db2 z/OS Basics for DBAs

Catalog Home IBM Mainframe & Midrange Db2 for z/OS

There are no scheduled dates for this course.

  Available by Request


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.

  • Operating system terminology
  • Introduction to dataset storage
  • TSO/ISPF introduction
  • ISPF hierarchy
  • ISPF commands
  • Using SDSF to view job output
  • Coding the JCL JOB and EXEC statements
  • Coding JCL DD statements
  • Db2 Concepts, Terminology and Storage Concepts
  • Basic SELECT using SELECT, INSERT, UPDATE, DELETE, TRUNCATE and MERGE
  • Advanced SQL
  • Writing SQL Queries for Best Performance




< >

Recently Viewed Courses:

Copyright © 2019 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media