title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
DB2 11 for z/OS Database Administration Workshop Part 1
Course Description
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.
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
- Design a relational table
- Describe the SQL data manipulation statements to access and change the contents of DB2 tables
You should be able to:
You should also take DB2 Family Fundamentals (CE031G) and DB2 SQL Workshop (CE121G), or have equivalent experience.
Topics
- 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.
Related Courses
-
New Functions and Features in DB2 11 for zOS
CV320G
- Duration: 24 Hours
- Delivery Format: Classroom Training, Online Training
- Price: 2,445.00 USD
-
DB2 11 for z/OS Application Programming Workshop
CV722G- Duration: 24 Hours
- Delivery Format: Classroom Training, Online Training
- Price: 2,445.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration