IBM Certified Database Associate – DB2 Universal Database V8.1 Family Exam 700 Curriculum Outline
Accessing Data and Manipulating DB2 UDB Database Objects
Overview/DescriptionTo access data and manipulate database objects
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certificationbr>
PrerequisitesA knowledge of fundamental database concepts, database creation and procedures, daily administration tasks, and basic SQL
Expected Duration2.75 Hours
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
Back to ListPlanning and Securing a DB2 UDB Database
Overview/DescriptionTo plan and secure a DB2 UDB database
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certificationbr>
PrerequisitesA knowledge of fundamental database concepts, database creation and procedures, daily administration tasks, and basic SQL
Expected Duration2.25 Hours
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
- Identify the authentication type to use when configuring DB2 UDB in a given scenario
- Identify the 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
Back to ListManipulating Data with DB2 UDB
Overview/DescriptionTo execute queries using SQL
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certificationbr>
PrerequisitesA knowledge of fundamental database concepts, database creation and procedures, daily administration tasks, and basic SQL
Expected Duration2.75 Hours
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
Back to ListMaintaining DB2 UDB Data Consistency
Overview/DescriptionTo explain how to choose appropriate isolation levels and to describe how locks are acquired in a DB2 UDB database
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 Family Fundamentals certificationbr>
PrerequisitesA knowledge of fundamental database concepts, database creation and procedures, daily administration tasks, and basic SQL
Expected Duration1 Hour
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
Back to List
DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Exam 701 Curriculum Outline
Monitoring a DB2 UDB database
Overview/DescriptionTo explain how to monitor a DB2 UDB
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
PrerequisitesA good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL
Expected Duration2.50 Hours
Monitoring a DB2 UDB database - Monitor DB2 UDB states using the snapshot monitoring utility
- Manage event monitors and view collected event monitor data
- Capture and return System Monitor information
- Distinguish between the methods for collecting and viewing Explain data
- Use Visual Explain to read SQL statements
- Use Visual Explain
- Use Memory Visualizer and the Health Center to monitor a database
- Recognize when you should use the Governor and the Query Patroller
- Monitor a database
Back to ListManaging Disaster Recovery in a DB2 UDB Database
Overview/DescriptionTo explain how to use the DB2 UDB disaster recovery utilities
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
PrerequisitesA good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL
Expected Duration1.50 Hours
Managing Disaster Recovery in a DB2 UDB Database - Demonstrate an awareness of the available backup and recovery strategies in DB2 UDB
- Back up databases and tablespaces
- Use DB2 UDB utilities to recover a database
- Roll the database forward and recognize the role of index rebuilding
- Use the DB2 UDB utilities to back up and restore a database
Back to ListManaging a DB2 UDB Server
Overview/DescriptionTo explain how to manage a DB2 UDB server
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
PrerequisitesA good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL
Expected Duration2.75 Hours
Managing a DB2 UDB Server - Recognize the instance management command to use in given scenarios
- Configure the DB2 system environment
- Manage instances and the DB2 system environment
- Use the DB2 utilities to configure the client/server environment
- Grant and revoke authorities and privileges
- Manage client connectivity
- Use commands to manage connections to a DB2 UDB
- Schedule and monitor tasks
- Manage database connections and tasks
Back to ListManaging Database Access in DB2 UDB
Overview/DescriptionTo describe database access management in DB2 UDB
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
PrerequisitesA good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL
Expected Duration2.50 Hours
Managing Database Access in DB2 UDB - Create tasks with success or failure conditions and notifications
- Create a task for a given scenario using the Task Center
- Determine the most appropriate index key in a given scenario
- Create indexes in a DB2 UDB database
- Design and create an index
- Create constraints to enforce business rules and ensure data integrity
- Create referential constraints for given scenarios
- Add constraints to tables
Back to ListUtilizing DB2 UDB Utilities
Overview/DescriptionTo explain the use of DB2 UDB data movement and data maintenance utilities
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
PrerequisitesA good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL
Expected Duration2.25 Hours
Utilizing DB2 UDB Utilities - Export data from a database in a given scenario
- Import data into a database
- Select the correct method to move data
- Export and import data using external files
- Locate and remove fragmentation from a database and check pages for consistency
- Use maintenance utilities to analyze and improve performance within a database
- Use DB2 UDB maintenance utilities
Back to ListAdministering Data Placement in DB2 UDB
Overview/DescriptionTo describe the administration and placement of data in a DB2 UDB database
Target AudienceAnyone wishing to gain knowledge of DB2 UDB; end users seeking advanced competence in DB2 UDB; candidates for IBM DB2 UDB V8.1 for Linux, Unix and Windows Database Administration certification, and those working towards IBM Certified Database Administrator
PrerequisitesA good knowledge of database concepts, database creation and procedures, daily administration tasks, and a good working knowledge of SQL
Expected Duration2.75 Hours
Administering Data Placement in DB2 UDB - Create databases using the CREATE DATABASE command and the Create Database Wizard
- Demonstrate an awareness of the database creation process
- Create a database and explain aspects of the database creation process
- Distinguish between SMS and DMS tablespaces and the data they hold
- Create and modify tablespaces and obtain information about a database
- Manage tablespaces in DB2 UDB
- Create and modify buffer pools in a DB2 database
- Create DB2 UDB tables
- Generate the SQL to create a new buffer pool and a new table
Back to List
IBM Professional Certification
IBM U2 is a family of database management software (DBMS) marketed by IBM. It runs on the major Unix and Linux systems and on Windows
NT/2000. The software also includes developer and web-enabling technologies such as IBM SystemBuilder, RedBack, and wIntegrate.
Benefits of CBT Direct’s Online IBM Professional Certification Training
CBT Direct boasts the most beneficial online certification training on the market. With online training, you have
the flexibility to study on your schedule, and with the speed and reliability of the internet, CBT Direct’s IBM Professional
training course is accessible anywhere you have an internet connection. Convenience finally costs less with CBT Direct –
the most affordable online training solution today.
The unique design of CBT Direct’s IBM Professional certification course incorporates a proven four-step learning process:
presentation, demonstration, guidance and independent practice. This four-step proven learning model for CBT Direct’s IBM Professional
training course ensures the greatest level of retention to prepare you for your IBM Professional certification exam.
Who Benefits from CBT Direct’s IBM Professional Training?
This course is ideal for IT professionals who are knowledgeable with DB2 Universal Database V8.1 and are capable of performing the
intermediate to advanced skills required in the day-to-day administration of DB2 instances and databases. This training would be
beneficial for individuals looking for IT job positions such as; Database Designers, Database Administrators, or a Database Manager.
What Professionals Will Learn from CBT Direct’s IBM Professional Training
The IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows is the second of two exams required to attain
the title IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows certification.
There are two options for attaining this certification titles:
Option 1
Pass the following two exams:
000-700 DB2 UDB V8.1 Family Fundamentals
000-701 DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration
Option 2
Be certified as an IBM Certified Solutions Expert - DB2 Universal Database V7.1 Database Administration for UNIX, Windows
and OS/2 and pass one additional exam:
IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows
PREREQUISITES
Recommended prerequisites to this training course/certification include: Significant experience as a DB2 Universal
Database V8.1 Database Administrator
IBM Certified Database Associate – DB2 Universal Database V8.1 Family Exam 700
Learn the functions and components of IBM DB2 UDB, a relational database manager, which may be installed on a variety of
operating systems. This course addresses DB2 UDB running on AIX, Linux, HP-UX, Sun, and Windows operating systems.
DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Exam 701
In this training course you will learn how to perform database administration tasks such as creating DB2 instances, creating
and populating databases, and using logical design to support concurrency and recovery requirements with DB2 UDB for Linux, UNIX
and Windows.
IBM Certified Database Associate – DB2 Universal Database V8.1 Family Exam 700
DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration Exam 701
