 | Level: Intermediate Ted J. Wasserman (tedwas.ibm@gmail.com), Database Consultant, IBM
22 Feb 2007 This tutorial explores the advanced programming skills needed to write applications that interact with DB2® 9. Topics include user-defined types (UDTs), data type casting, parameter markers, compound SQL, triggers, distributed units of work, federated databases, and concurrency considerations. This is the eighth in a series of nine tutorials that you can use to help prepare for the DB2 9 Application Development Certification exam (Exam 733).
In this tutorial
This is the eighth in a series of nine tutorials that are designed to help you prepare for the DB2 V9.1 Application Developer Certification exam (Exam 733). - The material in this tutorial primarily covers the objectives in Section 8 of the exam, entitled "Advanced Programming". In this tutorial, you will:
Objectives - Learn how to use UDTs and perform data type casting
- Learn how to use parameter markers
- Learn how to use compound SQL
- Learn how to create triggers
- Understand the concept of distributed units of work and federated database environments
- Understand how DB2 handles concurrency
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.
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
| | | |
