Certification overview

IBM certified Application Developer – DB2 9.7 certification is concentrated on people who are experienced in developing applications that support database.  The developers who develop should be able to create, design and maintain the application that uses the DB2 as technology. They must know development of applications that are new and also should know how to change or convert the exiting one according to the new specifications. Applications thus developed should be highly reliable and consistent such that there must not be any security threat and achieve high performance. Also, the developer must also know the administration concepts which might help developing a robust application. By passing this certification, a developer would become competent in application development that supports IBM DB2 9.7.

Who can do this certification

As this certification mainly concentrates on the development part of the application, the candidate who are trying to attempt must have an extensive knowledge and skill set in designing an application that meets the latest technology requirements, build an architecture which meet the highest possible level in the system of software. They should execute the application in such a way that it is highly secured and help retrieving information fast. Deployment of the application is also an important thing to be noted as this should work in parallel to the DB2 database. Thus, the person should have a skill who can successfully build an application which meets the high industry standards.  

Benefits

This certification definitely sets you apart from the people who are not certified which are indeed a great advantage to search a job. The chance of your profile getting selected is increased as they already know that you satisfy most of their requirements. It would give you confidence in taking up an interview or a new position in the same company you work on. Since you are a master of the necessary things you might climb

your career ladder quickly.

Associated Exam

So the first step towards IBM certified Application Developer – DB2 9.7 certification is to pass either one of these exams.

C2090-700

C2090-730

C2090-610

Second and the final step is to clear the exam C2090-543 - DB2 9.7 Application Development which would earn you and IBM Certified professional award in application development. 

Prerequisites

There is a defined knowledge level required for attempting any certification. However, it would not be a mandatory one. There are certain courses recommended to be done before taking up this certification. Those courses cover the concepts of programming with WINDOWS, LINUX and UNIX and also cover the knowledge pertaining to the advanced concepts of application programming procedures in DB2 for LUW. Every individual has the sole responsibility to take up each certification with a high level of knowledge in the subject. Any clarifications one the requirements for eligibility could be known from the website and thus taking the primary step towards attempting to clear the certification.

Examination Overview

This exam mainly covers the below topics such as

1. Objects of the database like table, alias and views
2. Using the SQL functions and procedures and the in-built routines of  DB2
3. Datatypes of DB2 (LOB, Date, Time, Integer, Strings etc)
4. Manipulating the data traditionally by knowing what is static and dynamic SQL.
5. What are cursors and the different types of cursors?
6. Creation and manipulation of Cursors and their scope.
7. DELETE/INSERT and UPDATE commands usage.
8. Transaction control statements like SAVEPOINT/COMMIT/ROLLBACK.
9. Manipulating the XML data by parsing, transforming and serializing.
10. Knowledge on validating the schema.
11. Package binding and rebinding.
12. Connection to the database using various methods (Embedded SQL, JDBC, etc).
13. Submitting a SQL statement and manipulating the results.
14. Determination of the problem scenario.
15. Creation of stored procedures those are external.
16. Knowledge in using the constraints, advanced concepts of database objects, trusted contexts etc.

Apart from the topics listed above is it better that the person attempting for this certification to go through all the application development related concepts thoroughly. 

This multiple choice question paper would have 60 questions and 60% of them should be answered right for clearing. Time allotted is 2 hours. English and Japanese are the language choices given for taking this exam.

Validity of the Certification

IBM certifications never expire. But they will have to be attempted again when a new version of update is released. This will help you in understanding and restructuring with the new concepts that are introduced in the latest version and implement the same in the work place. The knowledge could be used to update the application used in your organization as well.

Expert Review

For any person interested in master the application programming along with the database concepts, this is the right certification. You may have to look and study a various concepts to clear and understand the topics of this exam which will make you an expert in the subject. You will have a confidence to face any issue that is raised. Right from designing to deployment it teaches you everything. Thank you for framing a certification like this.

Gang Wang, Sony Mobiles.

Taipei, Taiwan