This series of six tutorials is designed to help you prepare for the DB2® (Version 8) Fundamentals Certification (Exam 700). Each tutorial includes a link to a free DB2 Universal Database Enterprise Edition download. Each tutorial also includes a number of additional resources that will help prepare for the exam.
Do these tutorials on your own time, check out the associated references listed with each tutorial, and please visit the certification Web site today for more information about the exam.
DB2 Planning: DB2 V8.1 Family Fundamentals certification prep, Part 1 of 6 This tutorial introduces the basics of the DB2 products and tools, along with the concepts of data warehousing and OLAP. It is the first in a series of six tutorials designed to help you prepare for the DB2 UDB V8.1 Family Fundamentals Certification (Exam 700).
DB2 Security: DB2 V8.1 Family Fundamentals certification prep, Part 2 of 6 This tutorial introduces you to DB2 security. You will learn about DB2 authentication, authorization and privileges. It is the second in a series of six tutorials that you can use to help you prepare for the DB2 UDB V8.1 Family Fundamentals Certification (Exam 700).
Accessing DB2 UDB Data: DB2 V8.1 Family Fundamentals certification prep, Part 3 of 6 This tutorial gives you an introduction to the objects that make up a DB2 database, and the different factors which affect how the database is created. After a brief introduction to DB2 objects, we'll examine the different tools to create, access, and manipulate DB2 objects. This tutorial is the third in a series of six tutorials that you can use to help you prepare for the DB2 UDB V8.1 Family Fundamentals Certification (Exam 700).
Working with DB2 UDB Data: DB2 V8.1 Family Fundamentals certification prep, Part 4 of 6 This tutorial introduces you to Structured Query Language (SQL), and helps to give you a good understanding of how DB2 Universal Database uses SQL to define database objects (such as tables, views, or indexes) and to manipulate data in a relational database. This tutorial is the fourth in a series of six tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Fundamentals Certification (Exam 700).
Working with DB2 UDB Objects: DB2 V8.1 Family Fundamentals certification prep, Part 5 of 6 This tutorial discusses data types, tables, views, and indexes as defined by DB2 Universal Database. It explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL), and how they can be used in an application. This tutorial is the fifth in a series of six tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Fundamentals Certification (Exam 700).
Data Concurrency: DB2 V8.1 Family Fundamentals certification prep, Part 6 of 6 This tutorial will introduce you to the concept of data consistency and to the various mechanisms that are used by DB2 Universal Database to maintain database consistency in both single- and multi-user environments. This is the last tutorial in a series of six tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Fundamentals Certification (Exam 700).
After a quick registration, you can begin a tutorial. Each tutorial should take about an hour to complete. You can take it online, or download a PDF or zip file of the tutorial. You'll need JavaScript enabled in your browser to take these tutorials.
