Get an introduction to the different types of database objects and programming methods. The first in a series of nine tutorials, use this series to help prepare for the IBM® DB2® 9 Family Application Development Certification exam (Exam 733).

In this tutorial

• The material in this tutorial primarily covers the objectives in Section 1 of the exam, entitled "Database objects and programming methods."

Objectives

• Learn about the different types of database objects
• Understand the relationship between schemas and database objects
• Learn about the fundamentals of SQL routines
• Understand the basics of programming interfaces: dynamic and static embedded SQL, CLI and ODBC, .NET, JDBC and SQLJ, PHP, Perl, Python, and XML
• Understand the security considerations associated with data access from an application

Prerequisites
To take the DB2 9 Family Application Development exam, you must have already passed the DB2 9 Family Fundamentals exam (Exam 730). You can use the "DB2 Family Fundamentals tutorial series" 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
• Databases
• Database objects
• DB2 security

System requirements
You do not need a copy of DB2 9 to complete this tutorial. However, if you wish, you can download a free copy of DB2 Express-C 9 from the DB2 Express-C downloads page.

Duration
Less than two hours

Formats
html, pdf

>>Click Here to Go to the Tutorial<<