Become an Oracle SQL Certified Expert

December 30, 2011 at 2:32 pm | Posted in Certification Paths, Oracle, Study hints | Leave a comment
Tags: , , ,

Have you taken a look at the Expert series of certifications that Oracle offers? Normally, the path to an  Expert certification is shorter than the path to OCA or OCP certification, sometimes as little as a single exam, but Expert certification requires a very in-depth knowledge of a particular area of Oracle technology.

If you are an Application Developer or a DBA who uses SQL extensively, you may want to consider the Oracle Database: SQL Certified Expert certification. The only requirement is to receive a passing grade (66% or higher) on Oracle’s certification exam 1Z0-047. However, before you jump to sign up, you need to be warned. This exam is not for your casual user of SQL. It requires an in-depth knowledge of SQL, including all of the enhancements made over recent years. Furthermore, this is one exam where Oracle University does not offer a course which maps almost perfectly to the exam.

The course “Oracle Database 11g: Introduction to SQL” or the equivalent knowledge would be a helpful resource, but you need to look closely at the topics covered. Here are my observations:

  • Be prepared to write joins using the new ANSI standards. You’ll also need to write single row, multiple row, and correlated subqueries.
  • All of the set operators are covered, as well as the new MERGE command and the multi-table INSERT command.
  • You should be well versed in index creation, and the various type of indexes, and more importantly when it’s appropriate to use each kind of index.
  • Understanding privileges, both object and system, as well as roles (both default and non-default) should be in your repetoire. You should also be prepared to answer questions dealing with transaction control, external tables, and the use of the Data Dictionary.
  • Constraints are hit hard, and the multidimensional report writing commands of ROLLUP, CUBE, and GROUPING are covered on the exam.
  • You should be able to deal with all the date and time functions, and provide global support to clients in different time zones.
  • The Oracle propietary commands to produce hierarchical tree-structured reports are definitely covered in the exam objectives.
  • And finally, be prepared to deal with regular expressions and pattern matching using the various REGEXP functions. Perl programming experience would come in handy here.

If you decide to take on this challenge, we have just finished upgrading the Transcender 1z0-047 exam prep practice test to 11g Release 2. This practice test will give you a good idea of what you are in for when you go to take the Oracle exam. Just like the live exam, the questions on the practice exam are challenging and really do require you to be a “SQL Expert”.

Good luck to all!

The Oracle Guy

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Entries and comments feeds.

%d bloggers like this: