Db2 for z/OS Database Administration Essentials and Design v12

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

Db2 for z/OS Database Administration Essentials and Design v12

  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...
No available dates in this city.

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

This course is designed to provide the student with the knowledge to effectively and efficiently design, create and maintain Db2 databases using Db2 for z/OS. The student will learn how to use Entity Relationship Modeling techniques to design and normalize a relational database. They will demonstrate how to define Db2 objects, including Databases, Storage Groups, Tablespaces, Tables, including temporal tables, Indexes, Views, Aliases, Materialized Query Tables and Clone Tables. The student will also develop skills to load, modify, backup, and recover Db2 data using Db2 utilities. This course includes features up to and including version 12 of Db2 for z/OS.

The student should:

  • Be familiar with Db2 concepts
  • Have experience with SQL data manipulation language
  • Have experience using TSO/ISPF, SPUFI and JCL

5 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 essential skills required to administer a Db2 database

  • Entity Relationship Modeling
  • Normalization
  • Db2 Overview and Storage Concepts
  • Create and Maintain Db2 Objects
  • Referential Integrity
  • Utilities
  • Program Preparation, Bind and Locking
  • Security

< >

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

Sign In Create Account


Social Media