Accessing Data and Manipulating DB2 UDB Database Objects

Overview/Description
To access data and manipulate database objects

Target Audience
Anyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certification

Prerequisites
A knowledge of fundamental database concepts, database creation and procedures, daily administration tasks, and basic SQL

Expected Duration
160 Minutes

Objectives:

Accessing Data and Manipulating DB2 UDB Database Objects

  • identify the DB2 UDB object levels and object types.
  • create a DB2 UDB database using the advanced CREATE DATABASE command in a given scenario.
  • catalog a DB2 UDB node in a given scenario.
  • create a database and catalog a node in a given scenario.
  • match database objects to their functions.
  • use SQL to create buffer pools, tablespaces, tables, and indexes in a given scenario.
  • use SQL to create schemas, aliases, views, and triggers in a given scenario.
  • manipulate database objects in a given scenario.


    • Course Number: 209551_eng