DB2 Data Base Administration - Course Objectives
On successful completion of this course, the student, with the aid of the
appropriate reference materials, should be able to:
- Design and normalize a data base in the relational model.
- Describe the physical and logical objects that are
parts of the DB2 relational Data Base system.
- Use SQL statements in DB2 to create and modify Data Bases,
Table Spaces, Indexes, Storage Groups, Tables, Views, Synonyms, and Aliases.
- Allocate VSAM files to support simple, segmented, and
partitioned Table Spaces, and Indexes.
- Use DB2 facilities to establish referential integrity
rules for related tables.
- Use DB2 utilities to load tables, reorganize table spaces,
backup table spaces, and recover table spaces.
- GRANT and REVOKE privileges to DB2 users to implement data
base security requirements.
G570 / 5 Days
These Materials © Copyright 2013 by Hunter Cobb
Materials version: V8.x
Topical Outline
Course Description
Home page
This page last updated: 1 August, 2014
Copyright © 2014 by Hunter's Training Associates, LLC