IBM DB2 Universal Database V6.1 Fundamentals

Rating:
Summary: IBM DB2 Universal Database V6.1 Fundamentals
Review: Course Overview
This course will provide both database administrators and application developers with the broad foundation skills and knowledge needed to be successful with IBM DB2 Universal Database (UDB) V6.1 in a UNIX, Windows, or OS/2 environment. This course will teach students the basic concepts of DB2 UDB V6.1, creating and accessing database objects, basic Structured Query Language (SQL), and managing databases.

Learn To

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.

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.

Deployment Options
e-Learning

Accreditation
NASBA credits: 4 CPE Credits
CEU credits: 0.70 CEUs

Language Options
US English

Total Learning Time
6 to 8 hours

Objectives
Unit 1: Introduction to DB2 Universal Database V6.1 1 - 2 hours

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 1 - 2 hours

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 2 hours

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 2 hours

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.