Db2 for z/OS System Fundamentals

Catalog Home Databases, Business Intelligence & Data Science Db2 for LUW
3.238.96.184
Your Training Location:  

Db2 for z/OS System Fundamentals

  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:
Building to GUARANTEED-TO-RUN
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

This course is designed to provide the student with the basic knowledge to create and maintain database objects using Db2 for z/OS. They will learn basic and advanced SQL in order to code queries. The student will also use Db2 utilities to maintain Db2 objects. Students will use application program techniques including program preparation and bind, as well as application performance considerations. This course includes features up to and including version 12 of Db2 for z/OS.

Before taking this class, students should be familiar with relational database concepts, and have experience using TSO/ISPF, SPUFI and JCL.

3 Days/Lecture & Lab

This course is intended for entry to intermediate level or future Db2 database administrators or application programmers who need to acquire the fundamental skills required to effectively utilize Db2 for z/OS.

  • Db2 Overview and Storage Concepts
  • Creating Databases, Storage Groups, Tablespaces, Tables, Indexes, including cluster and non-cluster, ::Views and Aliases.
  • Use of Db2 utilities to load, reorganize, perform backup and recovery operations
  • Utility Performance Considerations
  • Program Preparation, Bind and Locking
  • Basic and Advanced SQL
  • Cursor and Non-Cursor Processing





Copyright © 2021 ProTech Professional Technical Services, Inc. All Rights Reserved.

Sign In Create Account

Navigation

Social Media