logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

DB2 11 for z/OS Database Administration Workshop Part 1

SS Course: 38740

Course Overview

TOP

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.

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

                                                                  

Scheduled Classes

TOP
05/22/23 - TDV - Virtual-Instructor Led - Virtual-Instructor Led (click to enroll)

What You'll Learn

TOP
  • Implement a DB2 database design
  • Use database utilities to load and reorganize data
  • Define and implement a DB2 database recovery strategy
  • Control access to database using DB2 authorization facilities

    Outline

    TOP
    Viewing outline for:

    Prerequisites

    TOP

    You should be able to:

    • Design a relational table
    • Describe the SQL data manipulation statements to access and change the contents of DB2 tables

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

        Who Should Attend

        TOP

        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.

          Next Step Courses

          TOP