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.
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.
This Study guide and/or material is not sponsored by, endorsed by or affiliated with Cisco Systems, Inc. Cisco®, Cisco Systems®, CCDA™, CCNA
™, CCDP™, CCNP ™, CCIE™, CCSI™, the Cisco Systems logo and the CCIE logo are trademarks or registered trademarks of Cisco Systems, Inc.
*30-Day Guarantee applies only if products purchased are returned with 50% of product unopened. For example if
product purchased contains 6 videos, 3 must remain unopened.
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.
