Before you start
Thinking about obtaining the IBM Certified Database Associate — DB2 10.1 Fundamentals certification? If so, you've come to the right place. This series of DB2 10.1 certification preparation tutorials is designed to cover all the topics you need to know before you sit down to take the DB2 10.1 fundamentals certification exam (Exam 610). Even if you're not planning to seek certification right away, the information presented in this series can help you learn about many of the new features and functionality available in DB2 10 for z/OS® and DB2 10.1 for Linux®, UNIX®, and Windows®.
Don't see the tutorial you're looking for yet? You can review the DB2 9 tutorials in the DB2 9 Fundamentals certification 730 prep series.
This is Part 3 of a series of six tutorials that will help you prepare for the DB2 10.1 Fundamentals Certification (Exam 000-610). This tutorial primarily covers the objectives in Section 3 of the test.
This tutorial provides an overview of the primary objects that exist in a DB2 database. Then, primarily using IBM Data Studio, you are given step-by-step instructions to create, connect to, and drop a database. Finally, you will use Data Studio to create, update, and drop database objects.
The installation of DB2 and IBM Data Studio is not covered here. We strongly recommend that you download and install IBM DB2 Express-C and IBM Data Studio 3.1.1. Installing DB2 and Data Studio and following along will help you understand many of the concepts that are tested on the certification exam.
After completing this tutorial, you should be able to:
- Identify the database objects that exist in a DB2 database, including their basic characteristics and properties
- Use IBM Data Studio to:
- Create, connect to, and drop a database
- Create and modify objects that exist within the database
Anyone with general knowledge of relational databases will be able to complete the objectives of this tutorial.
Since DB2 and IBM Data Studio are not required to complete this tutorial, the process of installing these products is not covered here. It is recommended that you download both (see Resources).
You need neither a copy of DB2 nor IBM Data Studio to complete this tutorial. Once again, it is recommended that you download and install both products, as you will get more out of this tutorial if you follow along each step, See Resources to download both products.