Before you start
Learn what to expect from this tutorial, and how to get the most out of it.
Thinking about obtaining the IBM Certified Database Associate — DB2 10.1 Fundamentals certification? If so, you've come to the right place. This DB2 10.1 Fundamentals certification preparation series 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 features and functionality available in DB2 10 for z/OS® and DB2 10.1 for Linux®, UNIX®, and Windows®.
You 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.
Twenty-two percent of the DB2 10.1 Fundamentals certification exam (Exam 610) is designed to test your knowledge of the structure, creation, and alterations of tables, views, and indexes within DB2. This includes the data types that are supported, the various forms of tables and views, the restrictions that can be created on the values to be entered into tables and views, the indexes that can be built to provide speedy access, and triggers that can be built to cause other actions to happen upon certain events.
The material in this tutorial covers the objectives in Section 5 of the DB2 10.1 Fundamentals certification exam (Exam 610). You can view these objectives at http://www-03.ibm.com/certify/tests/obj610.shtml.
After completing this tutorial, you should be able to:
- Have the ability to demonstrate usage of DB2 data types (XML data types, Oracle compatibility data types).
- Have the ability to create a temporary table.
- Have the knowledge to identify when referential integrity should be used.
- Have the knowledge to identify methods of data constraint.
- Have the knowledge to identify characteristics of a table, view or index.
- Have the knowledge to identify when triggers should be used.
- Have the knowledge of schemas.
In order to understand some of the material presented here, you should be familiar with the following notions:
- Database Management System (DBMS) — a system that provides the core services necessary to support collecting, maintaining, protecting, sharing, and retrieving data among authorized users and applications. Generally it uses the devices and communications services made available by an operating system, and is used by applications which implement business logic and control the interactions with the users of the system.
- Relational Database Management System — a database management system that is perceived by the user as named tables in which data is arranged in rows and named columns.
- Structured Query Language (SQL) — a standardized language used to define objects and manipulate data in a relational database management system.
- Special register — a storage area that is defined for an application process by DB2 and is used to store information that can be referenced in SQL statements. Examples of a "special register" are CURRENT TIMESTAMP or CURRENT USER.
You do not need a copy of DB2 to complete this tutorial, but if you have access to a DB2 database server, you will be able to test some of the commands and concepts presented.
You can download a complimentary copy of DB2 Express-C from IBM.