Before you start
This tutorial introduces different types of database objects and programming methods. In this tutorial, you will learn about:
- Different types of database objects
- The relationship between schemas and database objects
- The fundamentals of SQL routines
- The basics of dynamic and static embedded SQL
- The basics of CLI and ODBC
- The basics of ADO and OLE DB
- The basics of JDBC and SQLJ
- The security considerations associated with data access from an application
This is the first in a series of seven tutorials that you can use to help prepare for the DB2 UDB V8.1 Family Application Development Certification exam (Exam 703). The material in this tutorial primarily covers the objectives in Section 1 of the exam, entitled "Database objects and programming methods." You can view these objectives at: http://www.ibm.com/certify/tests/obj703.shtml.
You do not need a copy of DB2 Universal Database to complete this tutorial. However, you can download a free trial version of IBM DB2 Universal Database from the developerWorks downloads page for reference.
To take the DB2 UDB V8.1 Family Application Development exam, you must have already passed the DB2 UDB V8.1 Family Fundamentals exam (Exam 700). You can use the DB2 Family Fundamentals tutorial series (see Resources) to prepare for that exam. It is a very popular series that has helped many people understand the fundamentals of the DB2 family of products.
Although not all materials discussed in the Family Fundamentals tutorial series are required to understand the concepts described in this tutorial, you should have a basic knowledge of:
- DB2 instances
- Database objects
- DB2 security
This tutorial is one of the tools that can help you prepare for Exam 703. You should also review the Resources at the end of this tutorial for more information about database objects and programming methods.
Copyright, 2004 International Business Machines Corporation. All rights reserved.
IBM, DB2, DB2 Universal Database, DB2 Information Integrator, WebSphere and WebSphere MQ are trademarks or registered trademarks of IBM Corporation in the United States, other countries, or both.
Other company, product, and service names may be trademarks or service marks of others.