Before you start
Thinking about seeking certification on DB2 fundamentals (Exam 730)? If so, you've landed in the right spot. This series of seven DB2 certification preparation tutorials covers all the basics -- the topics you'll need to understand before you read the first exam question. Even if you're not planning to seek certification right away, this set of tutorials is a great place to start getting to learn what's new in DB2 9.
The material in this tutorial primarily covers the objectives in Section 5 of the exam, entitled "Working with DB2 Objects." You can view these objectives at: http://www-03.ibm.com/certify/tests/obj730.shtml.
Topics covered in this tutorial include:
- A description of the built-in data types DB2 provides, and which are appropriate to use when defining a table. (For a different treatment of data type, see the fourth tutorial in this series).
- An introduction to advanced data types.
- Tables, views, and indexes.
- An explanation of the various types of constraints and their uses.
After completing this tutorial, you should be able to:
- Understand data types and advanced data types
- Create tables, views, and indexes in a DB2 database
- Understand the features and use of unique constraints, referential integrity constraints, and table check constraints
- Use views to restrict access to data
- Understand the features of indexes
You do not need a copy of DB2 to complete this tutorial. However, if you'd like, you can download a free trial version of IBM DB2 9 to work along with this tutorial.