IBM DB2 Universal Database 8 Fundamentals Certification Training Course Certified Database Associate
 With our IBM DB2 Universal Database Fundamentals training course you will learn to plan and secure a DB2 UDB database, access data and manipulate
database objects and execute queries using SQL. The course also covers how to choose appropriate isolation levels and to describe how locks are acquired in a
DB2 UDB database.This course also cover the training for the IBM Certified Database Associate certification exam.
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
Training Includes
- Interactive full multimedia lessons
- Review questions to test one skills
- Interactive lab exercise
- 24 x 7 online mentoring to instructor to answer all your questions.
- Proven Sucess
- Online or CD-ROM formats
- Training Time 13 hours
- Demo
|
Online
IBM DB2 Fundamental 8 Course
One Year Access
|
skibmdb2f8o
|
$245.00
|
|
|
CD-ROMS
IBM DB2 Fundamental 8 Course
|
skibmdb2f8c
|
$295.00
|
|
|
Online
Both the IBM DB2 Administration and Fundamentals Courses
|
skibmdb28c
|
$545.00
|
|
|
CD-ROMS
Both the IBM DB2 Administration and Fundamentals Courses
|
skibmdb28c
|
$595.00
|
|
Training Content
Planning and Securing a DB2 UDB Database
- Identify the appropriate DB2 UDB product to use in a given scenario.
- Match DB2 UDB tools to their functions.
- Identify the DB2 UDB products and tools to use in a given scenario.
- The authentication type to use when configuring DB2 UDB in a given scenario.
- Appropriate DB2 UDB authorities and privileges used in database security in a given situation.
- Manage authorities and privileges for a DB2 UDB database in a given scenario.
- Secure a DB2 UDB database in a given scenario.
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.
Manipulating Data with DB2 UDB
- Use the basic SELECT statement in a given scenario.
- Use advanced SELECT statement features in a given scenario.
- Use the INSERT, UPDATE, and DELETE statements in a given scenario.
- Use the SELECT, INSERT, UPDATE, and DELETE statements in a given scenario.
- Apply an inner join, an outer join, and a union in a given scenario.
- Apply table joins and unions in a given scenario.
- Manage cursors, transactions, and stored procedures in a given scenario.
- Manage transactions and stored procedures in a given scenario.
Maintaining DB2 UDB Data Consistency
- Choose an appropriate isolation level for a given scenario.
- Identify how locks are acquired in a DB2 UDB database.
- Identify DB2 UDB isolation levels and locks in a given scenario.
|
