Managing Database Access in DB2 UDB

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To describe database access management in DB2 UDB

Target Audience
Anyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator

Prerequisites
A good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL

Expected Duration (hours)
2.5

Lesson Objectives

Managing Database Access in DB2 UDB

create tasks with success or failure conditions and notifications.

create a task for a given scenario using the Task Center.

determine the most appropriate index key in a given scenario.

create indexes in a DB2 UDB database.

design and create an index.

create constraints to enforce business rules and ensure data integrity.

create referential constraints for given scenarios.

add constraints to tables.

Course Number:
217410_eng