Posted on

Database Development for Microsoft Great Plains Dynamics GP

For Oracle professionals that are going after the Oracle PL/SQL Developer Qualified Associate accreditation, there are 2 examinations that will certainly please the PL/SQL need: “1Z0-147: Program with PL/SQL” and the newer version: “1Z0-144: Oracle Data Source 11g: Program with PL/SQL”. There is a reasonable amount of complication amongst candidates looking for accreditation over whether they need to take one examination, or the various other, or both. The intent of this post is to help explain both tests, their resemblances and also distinctions, and why you could take one over the other.

Something should be made clear from the beginning: there is never ever a reason to take both examinations. Unlike the DBA track, Oracle PL/SQL accreditations are not tied to the database launch. You do not become certified in launch X of Oracle PL/SQL and afterwards have a demand to take upgrade tests. Since either of these 2 examinations will certainly please the OCA-level PL/SQL demand, passing the various other would certainly give no accreditation benefit. That stated, you must make a decision which of the two tests to seek. The 1Z0-147 examination is several years older than 1Z0-144. Unless there is a details reason that taking the older examination will benefit you, your far better option is to go with the 11G version of the exam. Until Oracle retires 1Z0-147, nevertheless, the choice is yours.

Both tests have a great deal of commonality between them. This makes sense as they are for basically the very same topic. What is shocking is the number of distinctions that exist between both. 1Z0-144 is not simply a remake of the earlier examination with new PL/SQL features from versions SQL Course London 10G and also 11G tacked on. There is a completely different feel to the test and the subjects covered. There are several areas that do not exist in 1Z0-147 which cover features that did not exist in 9i. Nonetheless, the majority of the brand-new sections in 1Z0-144 cover core topics of PL/SQL programs that perhaps ought to have remained in the earlier test. A few of the sorts of details covered in 1Z0-144 however not 1Z0-147 consist of:

The benefits of utilizing PL/SQL
Setting essentials, including variables, conventions, qualities, as well as lexical systems
Use SQL features in PL/SQL
Implied vs. specific data conversion
Use tags, imprint, and whitespace to make more understandable code
Making use of DML in PL/SQL
The use of control frameworks and also Loops
The use of cursors and also cursor qualities
Using the FOR UPDATE stipulation
Exception Handling
PL/SQL Layout considerations
Compound information types
Autonomous deals
BULK SQL procedures
PL/SQL compiler adjustments
The variety of subjects covered in 1Z0-147 that are not covered in 1Z0-144 is much smaller. However, the very first 3 are unexpected thinking about the pronounced change to PL/SQL principles in the 11G test:

Benefits required to perform treatments
Specification settings and DEFAULT values
Criterion passing methods– by recommendation vs. by worth
A much larger focus on triggers
A lot more recommendations to client-side PL/SQL (1Z0-144 mostly disregards client-side).
Extra focus on PL/SQL reliances and invalidations.
Big objects and also using the DBMS_LOB package.
If you wind up pursuing 1Z0-147, make sure to examine utilizing the Oracle 9i documentation. Abilities that were included in PL/SQL in 10G or 11G will not be on that test. Having actually looked into the topics for both examinations, I think about 1Z0-144 to be the much better test from the viewpoint of the information checked. The subject is a much better mix of what is very important for an entry-level PL/SQL developer to recognize. New developers studying for this examination will certainly come out with a more rounded as well as full knowledge of PL/SQL basics. Whichever exam you seek, make sure to study each of the exam subjects noted on the Oracle Education and learning site prior to arranging the examination. All the best on the examination.