IBM DB2 Universal Database V6 1--Fundamentals

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.

Content Emphasis

Skills-Based

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.

Total Learning Time

6 - 8 Hour(s)

Course Contents

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 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 Usag

This is primarily online training This is an online eLearning or CBT training program This program may be available on CD Contact 123-CBT Computer Based Training for more information

Training Presented in: English