 | Level: Intermediate Clara Liu (claraliu@ca.ibm.com), DB2 Product Planner, IBM
01 Feb 2007 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
| | | |
