The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 9 Fundamentals exam 730 prep, Part 5: Working with DB2 objects

Hana Curtis (hcurtis@ca.ibm.com), IBM Certified Solutions Expert, IBM

Hana Curtis is a lead member of the DB2 Functional Verification Testing team at the IBM Toronto Software Laboratory. Previously, she was a member of the DB2 Integration team working with DB2 and WebSphere, a database consultant working with IBM Business Partners to enable their applications to DB2, and a member of the DB2 development team. Hana is one of the authors of the book: DB2 SQL Procedural Language for Linux, UNIX, and Windows (Prentice Hall, 2003). She holds the following certifications: IBM Certified Solutions Expert: DB2 UDB V8.1 Database Administration for UNIX, Windows, and OS/2, IBM Certified Solutions Expert: DB2 UDB V8.1 Family Application Development, IBM Certified Specialist: DB2 V8.1 User.

Summary: This tutorial discusses data types, tables, views, and indexes as defined by DB2 9. 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 seven tutorials that you can use to help prepare for DB2 9 Fundamentals Certification exam 730.

View more content in this series

Date: 24 Jul 2006
Level: Introductory
PDF: A4 and Letter (340 KB | 21 pages)Get Adobe® Reader®

Activity: 26368 views
Comments:

Before you start

About this series

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.

About this tutorial

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.

Objectives

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

System Requirements

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.

Comments