Test 000-733: DB2 9 Application Developer Study Guide

IBA JV

Mikalai Zaikin

Belarus Minsk

Redistribution of this document is permitted as long as it is not used for profits.

June 2010

Revision History
Revision 1.01 May 2010MZ
Initial revision.
Revision 1.131 May 2010MZ
Updated chapter 7.
Revision 1.22 Jun 2010MZ
Final draft.

Abstract

The purpose of this document is to help in preparation for exam IBM 000-733 (DB2 9 Application Developer).

This document should not be used as the only study material for "DB2 9 Application Developer" test. It covers all objective topics, but it is not enough. I tried to make this document as much accurate as possible, but if you find any error, please let me know.


Table of Contents

Preface
I. Exam Objectives
1. Database objects and Programming Methods
Knowledge of naming conventions of DB2 objects
Knowledge of the authorities needed to access data in an application
Knowledge of complex database objects
Knowledge to identify the differences between dynamic and static SQL
Ability to determine when to use programming interfaces available
Ability to determine when to use SQL routines and functions
2. Data Manipulation
Ability to query databases across multiple tables and views
Ability to use common table expressions
Ability to work with MQT's
Ability to use DB2's built in routines
Knowledge of changing data
Knowledge to identify when to use cursors
Knowledge to identify types of cursors
Ability to manipulate cursors
Ability to manipulate large objects
Ability to manage a unit of work
3. XML Data Manipulation
Knowledge to identify the results of XML parsing
Ability to identify the results of XML Serialization
Knowledge of document encoding management
Knowledge of XML Schema Validation
Ability to execute an XQuery expression
Ability to identify the results of an XQuery/XPath expression
Knowledge of SQL/XML functions
4. Embedded SQL Programming
Ability to connect to databases within an embedded SQL programming application
Skill in executing SQL statements
Ability to analyze results and common errors
5. ODBC/CLI Programming
Ability to connect to databases within an ODBC/CLI programming application
Knowledge of the correct sequence for calling ODBC/CLI functions to execute SQL request
Ability to analyze results and knowledge of problem determination
6. .NET Programming
Knowledge of ADO.NET object model
Ability to connect to the database with ADO.NET
Skill in exeucting SQL statements and working with the results
Ability to analyze results and knowledge of problem determination
Knowledge of IBM DB2 Add-Ins for Visual Studio
7. Java Programming
Knowledge of JDBC/SQLJ object model
Ability to connect to databases within a JDBC/SQLJ application
Skill in executing SQL statements
Ability to analyze results and knowledge of problem determination
Knowledge of DB2 Add-Ins for Eclipse
8. Advanced Programming
Ability to query tables across multiple databases
Ability to create triggers and identify their results
Understand how changing data will work when referential constraints are involved
Knowledge to identify when to use Compound SQL
Knowledge of concurrency considerations within an application
Knowledge of distributed unit of work
Knowledge of using parameter markers
9. User Defined Routines
Knowledge to identify usage of User Defined Functions
Ability to create a User Defined Functions
Knowledge to identify when to use stored procedures
Ability to create SQL stored procedures
Ability to create an external stored procedures
Skill in using the DB2 Developer Workbench
II. Appendices
A. Wawaweewaa!
Ooh lala!
Bibliography
Professional hosting     Belorussian informational portal         Free SCWCD 1.4 Study Guide     Free SCDJWS 1.4 Study Guide     SCDJWS 1.4 Quiz     Free IBM Certified Associate Developer Study Guide     IBM Test 000-287. Enterprise Application Development with IBM WebSphere Studio, V5.0 Study Guide     SCDJWS 5.0 Quiz