DB2 UDB V8 DBA Certification prep tutorials

For Linux™, UNIX, and Windows®

If you know DB2 Universal Database V8.1 and can perform intermediate to advanced level administrative tasks, you may benefit from becoming an IBM Certified Database Administrator. This series of six tutorials is designed to help you prepare for the DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration (Exam 701) certification exam to attain the certification "IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX and Windows." These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam. After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take the tutorials online, or download a PDF or zip file.

If you don't already have a background in DB2 database administration, but are interested in learning more, you should instead begin with the DB2 UDB Family Fundamentals Certification (exam 700) Preparation tutorials. The Family Fundamentals tutorial series provides an introduction to SQL (Structured Query Language) and covers how DB2 Universal Database V8.1 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation.

This series of six tutorials is designed to help you prepare for the DB2 UDB V8.1 for Linux, UNIX and Windows Database Administration (Exam 701) certification exam. Each tutorial includes a link to a free DB2 Universal Database Enterprise Edition trial download. These tutorials provide a solid base for each section of the exam. However, you should not rely on these tutorials as your only preparation for the exam.

	Server Management: DB2 V8.1 Database Administration certification prep, Part 1 of 6 This tutorial introduces skills you must have to properly manage a DB2 UDB server. This is the first tutorial in a series of six that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Database Administration Certification (Exam 701).
	Data Placement: DB2 V8.1 Database Administration certification prep, Part 2 of 6 This tutorial discusses the creation of DB2 databases as well as the various methods used for placing and storing objects within a database. This is the second tutorial in a series of six tutorials that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Database Administration Certification (Exam 701).
	Database Access: DB2 V8.1 Database Administration certification prep, Part 3 of 6 This tutorial takes you through the various steps required to manage some of the objects within DB2. This is the third tutorial in a series of six tutorials that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Database Administration Certification (Exam 701).
	Monitoring DB2 Activity: DB2 V8.1 Database Administration certification prep, Part 4 of 6 This tutorial covers the different options a DBA has for tuning and configuring their DB2 environments. This is the fourth tutorial in a series of six that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Database Administration Certification (Exam 701).
	DB2 Utilities: DB2 V8.1 Database Administration certification prep, Part 5 of 6 This tutorial introduces utilities provided by DB2 servers for data movement and maintenance. This is the fifth tutorial in a series of six tutorials that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Database Administration Certification (Exam 701).
	Backup and Recovery: DB2 V8.1 Database Administration certification prep, Part 6 of 6 This tutorial discusses database backup and recovery topics. It explains the different methods of database recovery and logging, and how to use the backup, restore and rollforward commands. This is the last tutorial in a series of six tutorials that you can use to help prepare for the DB2 V8.1 for Linux, UNIX, and Windows Database Administration Certification (Exam 701).

Prerequisites
These tutorials are geared toward Database Administrators (DBAs) familiar with basic database concepts. As mentioned above, if you don't already have a background in DB2 database administration, but are interested in learning more, you should instead begin with the DB2 UDB Family Fundamentals Certification (exam 700) Preparation tutorials.

System requirements
You'll need JavaScript enabled in your browser to take these online tutorials.