Managing Database Access in DB2 UDB

This course is included in our On-demand training solution.

Overview

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

150 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?