DB2 11 for z/OS Database Administration Workshop Part 1 – CV832GCR

image_pdfCourse Outline PDF

Enrol   Details


Course Code: CV832G Brand: HDM – Db2 for z/OS Category: Analytics Skill Level: Intermediate Duration: 40H Modality:CR      Audience


This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.

  Prerequisites


You should be able to:

_x000D_
_x000D_

    _x000D_

  • Design a relational table
  • _x000D_

  • Describe the SQL data manipulation statements to access and change the contents of DB2 tables
  • _x000D_

_x000D_
_x000D_

You should also take DB2 Family Fundamentals (CE031G) and DB2 SQL Workshop (CE121G), or have equivalent experience.

  Short Summary


This intermediate course is for future DB2 for z/OS database administrators who need to acquire the basic skills required to administer a DB2 database.  Overview


This course provides you with instruction on how to physically implement a logical database design in DB2. The course includes instruction on DB2 data management, DB2 catalog tables, the bind process, database utilities such as LOAD and REORG, and security considerations.

_x000D_
_x000D_

Note: This course material is at the DB2 11 for z/OS level.

  Topic


  • Setting up a DB2 database
  • Referential integrity
  • Getting data into and out of DB2
  • Keeping your DB2 data in good shape
  • Application data recovery basics
  • Program preparation and Bind
  • Security
  • Serialization

The course includes extensive machine exercises.

  Objectives


    _x000D_

  • Implement a DB2 database design
  • _x000D_

  • Use database utilities to load and reorganize data
  • _x000D_

  • Define and implement a DB2 database recovery strategy
  • _x000D_

  • Control access to database using DB2 authorization facilities
  • _x000D_

Tags :
Call Now +27 72 266 2599