DB2 11 for z/OS Database Administration Workshop Part 1

Course Code: CV832G
Duration: 40 Hours
Price: INR 69440.00

e-Learning

Close

Learn at your own pace with anytime, anywhere training.

Contact For Pricing

Classroom Schedule

Close
Location Delivered By Language Date Price Action
No schedule date's available now.

* Prices Inclusive of taxes

View All Our Training Schedule

Virtual Schedule

Close
Location Delivered By Language Date Price Action
No schedule date's available now.

* Prices Inclusive of taxes

View All Our Training Schedule

Private / Corporate Training

Close

Tell us a little about yourself:

Course Description

  • 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.

Objectives

  • 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

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:

  • 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.

Content

 

  • Setting up a DB2 database
  • Referential integrity

  • The course includes extensive machine exercises.

  • Getting data into and out of DB2
  • Keeping your DB2 data in good shape
  • Application data recovery basics
  • Program preparation and Bind
  • Security
  • Serialization