IBM DB2 Universal Database V6.1 Fundamentals

Audience

This course is intended for database administrators and application developers. Students should have a fundamental understanding of relational database technology including concepts of databases tables rows/columns data types etc. prior to taking this course. Limited exposure to SQL is also assumed. When coupled with appropriate on-the-job experience this course will help prepare students for the IBM Certified Solutions Expert Certification exam 509.

Objective

• Identify DB2 UDB product editions their installation and verification user interfaces and security features.
• Create and access DB2 database objects ensure data validation and integrity and create views and indexes.
• Master basic Structure Query Language (SQL).
• Manage database operations.

Topics Include

Unit 1: Introduction to DB2 Universal Database V6.1

• Match the product editions of DB2 UDB with their characteristics.
• Identify the satellite administration functions of the Satellite Administration Center.
• Match the DB2 UDB clients with their functions.
• Match the communication protocols that DB2 supports with their associated platform environments.
• Identify which DB2 Connect product to use given a specific scenario.
• Match the DB2 UDB products with their functions.
• Install a DB2 UDB server given system specifications.
• Identify tasks performed to verify a DB2 installation using First Steps.
• Install a DB2 client given a scenario.
• Sequence the steps of a distributed installation for DB2 clients.
• Match the database directories with their descriptions.
• Catalog a node and a database using the CATALOG command.
• Identify the functions of the DB2 Administration Server instance.
• Match the DB2 command interfaces with their characteristics.
• Identify the tasks performed using the Control Center.
• Match security levels with their definitions.
• Sequence the steps in the authentication process a user follows when accessing a DB2 instance.
• Identify the characteristics of DB2 authorization levels.
• Provide a user with privileges on database objects using Data Control Language (DCL).

Unit 2: Creating and Accessing Database Objects

• Match the data placement objects with their definitions.
• Select the type of table space needed given a scenario.
• Create a database and table space given a set of parameters.
• Match data elements with their data types.
• Identify column definitions that allow the insertion of null values.
• Create a table based on a set of instructions.
• Locate information in system catalogs by viewing a system catalog table.
• Create a view with specific characteristics.
• Create an index with specific characteristics.
• Identify the effects of table check constraints given a CREATE table statement.
• Identify characteristics of a trigger.
• Analyze data modification instructions to determine whether DB2 applies referential constraints given referential constraint definitions.

Unit 3: Basic Structured Query Language Usage

• Display data using a SELECT statement.
• Specify rows to be retrieved from a table given certain requirements.
• Apply DB2 functions to groups within a table for a given scenario.
• Retrieve data from multiple tables given a scenario.
• Enter data into a table using an INSERT statement.
• Modify data in a table using an UPDATE statement.
• Remove data from a table using a DELETE statement.
• Identify considerations in embedding SQL in applications for DB2.
• Sequence the steps to prepare to run an application program.

Unit 4: Managing Databases

• Identify the effect of COMMIT and ROLLBACK processing given a scenario.
• Identify the objects on which locks can be obtained.
• Match row lock modes with their characteristics.
• Identify ways that DB2 resolves lock contention.
• Match isolation levels with their properties.
• Transfer data between databases using data movement utilities.
• Match maintenance utilities with their functions.

Duration

8

Minimum Requirements

The CDROM version of this course requires:

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
• At least a double speed CDROM drive.
• An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).

• At least a 486DX 33Mhz CPU.
• Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
• At least 8MB RAM and 22MB available hard disk space or file server space.
• At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).

Media