DB2 Data Base Administration - 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.
Course information: G-570 / 5 Days These
Materials © Copyright 2007 by Hunter Cobb V8.x
Topical outline
Course description
Home page
this page last updated: 07 February, 2007
this page copyright © 2007 by The Trainer's Friend, Inc.