Saturday, October 5, 2013

How Difficult are Oracle Specialist Certifications?

Over the past decade and more, I have taken a number of Oracle exams. The list includes multiple exams for OCA, OCP, and OCE certifications. One of the more popular articles that I have written is "Oracle Certifications: What Is the Difference Between OCA, OCP, OCE, and OCM?" where I discuss the differences between the various types. Mind you, I have not taken an OCM (yet), but I am familiar enough with it that I was able to point out the differences between it and the other three. Notably missing from that article, however, are Oracle specialist certifications. I deliberately left OCS out because I had no information with which to compare this class of exams to the other four. That changed yesterday when I took 1Z0-460: Oracle Linux 6 Implementation Essentials. I should note that while I have read that there is no official acronym for these certifications, I see OCS used to designate Oracle Certified Specialist fairly often. It is certainly handier than constantly spelling out Oracle Certified Specialist.

I recall enough of my college statistics class to realize that a single data point makes for a really bad sample population. 1Z0-460 may be an outlier and have little in common with any of the other OCS exams. However, I do not have any plans to take another OCS exam in the next several months, so it will have to suffice for now.

Going into this exam, I really expected it to be a walk in the park. It is titled Linux Essentials after all, and I have used Linux for years. I will grant that doing work at the OS-level is not my main function -- I am a developer first, a DBA second, and a Linux system admin a distant third. Still... this is an essentials exam, and intended to give the employees of Oracle partner companies a basic grounding in the technology. I figured it was likely an OCA-level exam, maybe a bit lower.

I hate it when I underestimate exams.

1Z0-460 certainly was not at the level of an OCE exam. It probably did not even make it to the difficulty of an OCP exam. However, I would judge the difficulty closer to that of an OCP exam than an OCA one. It contained a fair number of simple questions that would have had no place in an OCP test. However, a number of the questions required a level of detail about Linux commands, and configuration files, and directories that surprised me.

Anyone who has used Linux much knows that there are huge numbers of commands and many have dozens of options. Likewise there are scores of configuration files and scripts located throughout the file system. I do not normally memorize any but the most common of options for a given utility. That is what 'man' is for. Likewise, I do not memorize the locations of every file. That is what 'locate' is for. Many more of the questions were practitioner-type questions than I expected to find.

That said... I passed the exam, so all is right with the universe today. For anyone planning to take a specialist exam (and assuming that 1Z0-460 is typical of the breed), I would suggest that you not design your study plan with the idea that essentials=easy. For that matter, you should always allocate more study time than you really think any exam needs. No one has ever failed a test because they were over-prepared for it.

Saturday, September 21, 2013

Your chance at a free voucher for 1Z1-062: Oracle Database 12c: Installation and Administration (CLOSED)

This contest is over and I have selected the winners.

This afternoon I was contacted by a representative of Oracle University. She had five vouchers for the 1Z1-062 beta exam, Oracle Database 12c: Installation and Administration and wanted to know if I could come up with a way to get these to five of my readers. I told her that I have it covered.

Before I explain how you can get the vouchers, I want to talk a bit about the exam. 1Z1-062 is one of two exams in the Oracle Database 12c Administrator Certified Associate track. The other can be 1Z0-061: Oracle Database 12c: SQL Fundamentals or one of several other SQL exams. My previous blog post discussed all of the various SQL exams that meet the requirement and why they were created. Passing 1Z1-062 and a valid SQL exam will qualify you to be an Oracle Database 12c Administrator Certified Associate.

1Z1-062 is currently in beta and the vouchers are only valid while it is in beta. The beta period is currently scheduled to end on October 19, 2013. If you have not started preparing for the test and plan to take it, you had best study fast. A month of study time is a very low-end figure for an Oracle certification exam. This is especially true here as the 062 exam covers eighty-five topic areas. Putting that into perspective, the 11g Admin I exam, 1Z0-052, only had fifty areas. That is a seventy percent increase in the number of topics! If you have not started studying and are not willing to put in a lot of preparation for the exam, I would strongly suggest passing on this offer. For those of you that have been studying for it and will be scheduling the exam soon -- great! Read on and I will get to the 'free voucher' part... eventually.

If you have never taken an Oracle beta exam, you should know that they are long. The exam duration is 2 1/2 to 3 hours and there will be 150-220 questions.  Production exams, by contrast, are normally about 70 questions and 1 to 2 hours in duration. An earlier post in this blog talks about Oracle beta exams -- Oracle Beta Exams -- The Good, the Bad, and the Ugly. I highly recommend reading that post before committing to a beta exam. I took one Oracle beta and was not fully prepared for what it would be like. Having the proper expectations would have made the experience easier. That said, the biggest advantage betas have is that they cost less than the production exam. If you get one of these vouchers, the exam is completely free... bonus.

So... free vouchers (finally). Oracle University left it up to me to determine how to distribute them. I decided to make it a test of your research ability.  If you have been to my Oracle Certification Prep website, it contains hundreds of links to articles, white papers, and videos on topics for various Oracle certification exams. If you want to have a chance at the vouchers, find an article, white paper, or video that is relevant to one or more of the topics on the 1Z1-062 exam. You can see an example of the type of link I am looking for in my page for 1Z0-052. Once you have found a good source for the exam, create a comment to this post linking to it. If you want to include more than one, feel free to include up to five sources.

That's it.  Because the exam is scheduled to close in a month, I want to pick five winners fairly soon.

EDIT:  With five valid responses, I will definitely choose the winners on October 5th.

Some rules:
1. No brain dumps.  A comment with links to a brain dump or sites that sell them will simply be deleted without consideration even if it contains links to other valid sources.
2. I will be looking at the content in the linked articles.  If you supply a comment full of articles unrelated to the exam, or advertisements, etc. -- the comment will be deleted.
3. Yes -- the Oracle documentation is a great source.  No -- it will not count for this.
4. Do NOT put your email address in the comment.  I do not believe in feeding spambots.  I will announce the winners in a later post along with how to get in touch with me for the voucher numbers.
5. If two people supply a link to the exact same source, only the first will receive credit for it.
6. I will decide on the winners based solely on the quality of the content in the links. Telling me why you really really really need this voucher will not affect my decision-making process.

Wednesday, September 4, 2013

Oracle's SQL Fundamentals Exams and Database Releases

Oracle Education released 1Z0-061: Oracle Database 12c: SQL Fundamentals a few weeks ago.  It is now the fourth introductory SQL exam created by Oracle University.  The earlier exams were:

  • 1Z0-001 -- Introduction to Oracle: SQL and PL/SQL
  • 1Z0-007 -- Introduction to Oracle9i SQL
  • 1Z0-051 -- Oracle Database 11g: SQL Fundamentals I

While the first two exams have been retired, candidates who have passed any of the above four (or the SQL Expert Exam, 1Z0-047) will be given credit for having met the SQL requirement for any certification track that requires one.  Put another way, it is not necessary for a certification candidate who wishes to become an Oracle Database 12c Administrator Certified Associate to take the 12c SQL Fundamentals exam.  The candidate could take 1Z0-051, or be grandfathered in for having passed 1Z0-007 or 1Z0-001 before they were retired.

While I was creating a study guide for this new exam, I asked myself, why are the SQL exams associated with a database release if it doesn't really have implications for the certification?  

In developing an answer, I thought about why each exam was developed.  1Z0-001 obviously was created because a SQL (and PL/SQL) exam was needed.  1Z0-007 was the first of the 'SQL-only' exams and was created around the same time as 1Z0-147: Program with PL/SQL.  Effectively the move split 1Z0-001 into two more focused exams and allowed for the new PL/SQL developer track.  Because of the content split, 1Z0-007 is a significantly different test than 1Z0-001.

Oracle University did not create a 10g SQL Fundamentals exam (although the SQL expert exam was first created during this release).  However, for Oracle 11g, a new SQL Fundamentals exam was created. The reason was largely because the 9i SQL Fundamentals exam had several topics that had become obsolete.  Namely, it had some that were about iSQL*Plus, which Oracle had since discontinued.

The 1Z0-007 and 1Z0-051 exams have about 85% commonality between the material covered.  The 11g version swaps the iSQL*Plus topics out in exchange for a handful of additional SQL topics.  Oracle University could not simply alter the topics of the 1Z0-007 exam itself, since that would make any existing book, self-test, or class materials obsolete. As an author of certification study materials, I know that such a change would really make me upset.

Coming back around to the topic this post started out with -- 1Z0-061 has been released.  It drops one section that had been on 1Z0-051 (Creating Other Schema Objects) and adds an 'Introduction' chapter that covers some basic details about 12c features and RDBMS theory. I confess to not really being sure why this exam was created. My best guess is that OU is shifting the SQL Fundamentals exam topics slightly further away from the SQL Expert exam.  If you are choosing an exam to take, selecting 1Z0-051 or 1Z0-061 is something you can leave to a coin toss.

The release numbers applied to SQL Fundamentals exams are really just a convenient way for Oracle University to create versions with updated topic lists. However, all of the SQL exams contain enough information in common to ensure that candidates have a firm grasp of basic SQL. Therefore, Oracle does not require a specific SQL exam for those certification tracks that are release-specific.

Saturday, July 13, 2013

I know nothing about Oracle... but I want to be a DBA.

I see numerous posts on LinkedIn groups and forums from people who currently have no knowledge of the Oracle database but want to know where to begin learning so that they can start a career working with it. This is a perfectly reasonable goal. There are thousands of highly skilled Oracle professionals in the world today, but at some point in their lives, every single one of them knew absolutely nothing about the Oracle database. In this article I will suggest some ways for people starting at or near ground zero to begin acquiring knowledge.

Possibly the single best starting point for someone completely unfamiliar with Oracle is the Concepts Guide. This book is part of the documentation for every release and can be easily located from a Web search. It is free to download, well written, and provides an excellent grounding in the Oracle database. Locate this book and read it cover to cover.

Choosing a second step is a bit harder because there are many possible options. If you do well learning from reading, there are a number of other books in their online documentation you could read next. Oracle has several manuals intended to provide an overview of information for a given area that are designed to be covered in two days. There is a 2-Day DBA book that would be a reasonable second step in your Oracle introduction. Like the Concepts Guide, this and many other books are easily found online and freely available to download.

Alternately, there are a number of Oracle video tutorials available on YouTube. Some of these are quite good and might be a better second step if you learn better in an environment where information is presented by an instructor. I have put together links to a number of these tutorials in the exam details page for the SQL Fundamentals exam on my Oracle Certification Prep website.

If you complete all of the sources above, you will have started building a foundation of Oracle knowledge. One option to move forward might be to study to become an Oracle Database Administrator Certified Associate. If you go this route, you should understand that what makes the OCA valuable is that it gives you a defined set of curriculum to learn. The topics selected for the exams are intended to give you a reasonable set of knowledge areas that beginning DBAs ought to be aware of. Too many individuals starting out with Oracle believe that the value of the OCA is in the piece of paper you get for passing the required tests.

Moving forward from this, there are dozens of sources of information about the Oracle database. The Internet is filled with thousands of articles about the Oracle database. There are hundreds of books available on the subject. The more you learn about Oracle, the less you should need someone suggesting what to learn next.

The biggest pitfall that I see far too many people fall into is looking for shortcuts and easy answers. The use of brain dumps to pass exams and books with answers to interview questions both seem to be increasingly popular. Both have the same basic intent -- to make someone appear to have knowledge they really do not. The reality is that you cannot build a successful career with Oracle by faking competence with it. There are plenty of legitimate sources available that will allow you to learn everything you need to become an Oracle professional.

Wednesday, June 26, 2013

What defines an Oracle Expert?

From numerous postings on Oracle certification forums and on LinkedIn groups, it appears to me that there is a common misconception about the Oracle Expert certifications. It seems many people feel that if you study for and pass one of these exams that you become an expert on the topic -- even if you had little or no knowledge prior to your exam preparation. This is simply not true. The study process no more makes you an instant expert than reading a medical textbook and putting on scrubs and a mask would instantly make you a surgeon.

Just to be clear -- I really like Oracle's expert series. I hold the expert certifications for Application Express, SQL, and SQL Tuning. I enjoy the fact that the topics are covered in greater depth than is typical for OCA and OCP level exams. In addition, they are some of the hardest Oracle exams I have ever taken, which pushes me to work harder when preparing. That said, I have been writing and tuning SQL for over seventeen years and programming in Apex since it was HTMLDB. I was an expert in these topics before taking the tests. I did not pursue the certifications in order to become an expert but rather to refine and expand what I already knew from having worked with them for years.

It is possible to pass the Application Express expert certification while having no aptitude whatsoever at creating a web application using that environment. The exam cannot test someone's ability to program and does not attempt to. Instead it tests the candidate's knowledge of the development environment. That said, studying for the exam was valuable for me as an experienced developer because it forced me to learn portions of the interface that I had previously not made use of.

The same holds true for the SQL and SQL Tuning exams. People with little or no experience of Oracle SQL will not instantly become skilled at writing or tuning it simply by studying the exam topics. The expert exams are designed to help experienced Oracle professionals to backfill any knowledge gaps and enhance their skills. They are not designed as a shortcut for freshers to prove that they are knowledgeable.

One of the biggest pitfalls with inexperienced professionals gaining expert certifications is that it can set them up to fail. Going back to the earlier 'surgeon' analogy. You memorized the textbook, you look great in scrubs, and you somehow convinced a hospital to hire you as a surgeon. This is great -- who needs medical school or years in a residency program? However, sooner or later someone is going to expect you to be able to perform surgery...

In the real world, it would never get that far, of course. Someone pretending to be a surgeon would almost certainly get caught early in the hiring process. Likewise, someone portraying themselves with Oracle expertise that they do not really have is almost certain to be tripped up during the interview. Misrepresenting yourself is likely to result in your resume being tossed in the trash. Your best bet is to pursue certifications that are appropriate to your level of Oracle proficiency.

Wednesday, June 19, 2013

The Value (or Lack Thereof) of Oracle Certifications

I received a comment earlier today on my earlier article Should I Get Certified as an Oracle 11G DBA or as a 12c DBA?. The subject is one that I felt rated a separate post in order to provide a sufficiently detailed response.

Matt-
I dislike certifications intensely, even though I hold several, and hope that someday they will lose their popularity. I got my certifications by studying and reading, but don't necessarily have experience in all of the areas in which I hold certs. However if I put all my certs on my resume, I get invitations to interview for senior positions based on these certifications! 

Such stupidity is sickening. It's definately unfair to the qualified people who don't hold the certification. Now I just list the certifications in which I have the most job knowledge. 

Certifications have little to no value in my view, and do NOT equate to job knowledge. Only relevant work experience can provide that. I always point this out when I speak to anyone who hires. 

-Susan Hanover

I find it difficult to understand why anyone would consider it stupid to be offered an interview because their resume contains certifications relevant to the position. I agree that it would be extremely unwise if the employer did not perform due diligence during the interview to ensure the candidate is qualified for the position. However, resumes and LinkedIn profiles are simply a way for employers to attempt to locate a pool of individuals that might fit their needs. Certifications are just one of many ways to locate potential candidates.

Likewise, I do not see how employers using certifications as part of their interview filter is unfair to individuals without certifications. By that logic, an employer who requires candidates to have a four-year degree is being unfair to any individuals that could do the job but never completed college. Nothing prevents experienced (but uncertified) Oracle professionals from pursuing certifications. If they choose not to, that is their decision. However they cannot decide not to certify and simultaneously complain that they are missing out on opportunities afforded to certified professionals.

I will agree that being able to pass a certification exam does not guarantee that an individual will be able to perform the job properly. I do not agree with the statement "Certifications ... do NOT equate to job knowledge". The following topics are a handful from those in the 11g Admin II exam (1Z0-053):


  • Configure multiple archive log file destinations to increase availability
  • Create and configure a recovery catalog 
  • Using RMAN to Create Backups
  • Recover from a lost redo log group  
  • Implement Automatic Memory Management


Each of these topics is very important for DBAs to know. It is knowledge that is required in order to be able to do the job of a DBA properly. The vast majority of topics on the 1Z0-053 exam are likewise either useful or critical for administrators to know. Studying for Oracle certifications does provide knowledge useful for the job. It is more correct to say that for someone brand new to the Oracle database, learning all of the topics in the OCP exams is not sufficient to become the sole DBA maintaining a mission-critical database. Job experience beats certification knowledge alone. However, job experience plus knowledge gained studying for certifications beats job experience alone.

I hold many Oracle certifications, including several of the Oracle Expert series. I would never point to any of them and claim that I am an expert because of the certification. I am, however, expert at several areas of Oracle. Studying for certification exams helps me to increase my expertise further because I make sure that I learn as much as possible from every one. The knowledge in my skull is why I am able to earn an enviable salary. The way in which I prepare for certifications increases what I know about Oracle and so they provide value to me. If having a certification on my resume also gets me an interview that wouldn't have happened otherwise or allows me to negotiate a higher salary -- that is simply a bonus.

Friday, June 7, 2013

My article series on TechTarget

A bit over a month ago I contracted with TechTarget to write a series of articles for their SearchOracle division.  The articles that I have written for this blog and GoCertify.com and other sites have been directed towards advising certification candidates about certification and career goals.  What I will be developing for SearchOracle articles is a series of technical articles written to cover Oracle certification exam topics. I am not writing the articles in any particular order and the exams covered will rotate. I will link to each of the articles from the relevant Exam Details page at www.oraclecertificationprep.com as they are published.

At this time, the first four articles have been published.  I will be providing the next four articles to my editor shortly. If the series is popular, in a few months there will be a significant number of articles available to boost the amount of free materials available to prepare for Oracle certification exams. You can access all of the articles (as well as any I write in the future) from my TechTarget Bio.

The four articles currently available are: