|
An IBM Certified Application
Developer is an intermediate or advanced level application developer
specializing in creating applications that run on any of the DB2 platforms:
Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows, z/OS, s/390,
and iseries. This individual has strong skills in all common programming tasks
as well as strong skills in one or more of the specialty areas: embedded SQL
programming, ODBC/CLI programming, or Java programming. Section 1 - Database objects and Programming Methods (13%) - Knowledge of naming conventions of DB2 objects (aliases, views,
etc.)
- 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 embedded SQL
- Skill in determining when to use CLI/ODBC
- Skill in
determining when to use JDBC, SQLJ
- Ability to determine when to use
SQL routines and functions
- Determine when to use OLEDB
Section 2 - Data Manipulation (26%) - Ability to
query database across multiple tables
- Ability to query tables across
multiple databases (federated databases)
- Knowledge of changing data
- Ability to use DB2 SQL functions
- Ability to use common table
expressions
- Knowledge to identify when to use cursors in an SQL
program
- Knowledge to identify types of cursors
- Knowledge to
identify the scopes of cursors
- Ability to manipulate cursors
- Ability to manage a unit of work (transaction management)
Section 3 - Embedded SQL Programming (11%) - Knowledge of identifying steps and output involved in creating an
embedded SQL programming application
- Knowledge to identify when host
variables are used (begin-declare)
- Skill in declaring host variables
- Skill in utilizing host variable in queries
- Ability to
explain/analyze the content of the SQLCA
- Knowledge of common errors,
prep, and BIND database programs
- Ability to connect to databases
within an embedded SQL programming application
Section 4 - ODBC/CLI Programming (13%) - Knowledge of the different handle types
- Knowledge of
configuring DB2 ODBC driver
- Knowledge of problem determination
(diagnostic records)
- Knowledge of the correct sequence for calling
ODBC/CLI functions
- Knowledge of various CLI cursor types and when to
use them
- Ability to connect to databases within an ODBC/CLI
programming application
Section 5 - Java Programming (13%) - Knowledge of
various JDBC objects
- Knowledge of the difference between SQLJ and JDBC
- Knowledge of problem determination (JDBC Trace, SQL exceptions, JDBC
error log)
- Skill in performing the steps to build SQLJ applications
- Ability to manage transactions across multiple databases (JTA)
- Ability to connect to databases within a JAVA programming application
- Ability to determine which connection types should be used to connect
to the database
Section 6 - Advanced Programming (16%) - Utilize
dynamic and static SQL within programs
- Skill in casting UDTs within a
program
- 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
- Determine the approaches to programming using
Unicode
- Use performance enhancement features (buffered inserts)
Section 7 - User Defined Routines (8%) - Knowledge to identify usage of UDFs
- Knowledge to identify when
to use stored procedures
- Skill in using the DB2 Development Center
- Knowledge of programming languages using the DB2 Development Center
|
