Monday, October 28, 2013

You are Either Learning or Sliding Towards Obsolescence

A couple of days ago I read an article on Career Builder: The importance of life-long learning in the IT industry, by Scott Skinger.  As the CEO and Founder of TrainSignal, it is not surprising that Scott is of the opinion that training is an important part of a long and successful career. Mind you, as the author of a series of certification guides, it is equally unsurprising that I am of the same opinion.

That said, anyone who spends just a few minutes thinking about it would be hard put to deny that being employed in the IT industry pretty much requires you to continue learning throughout your career.  Most people have working careers that span more than forty years. How much 1973 IT technology do you think is relevant today? Which companies are looking to hire individuals with knowledge of it?

If you want to continue to have skills and knowledge that make you valuable to your current employer and interesting to prospective employers, you must continually learn and adapt to changes in technology.  If you become expert in any given area and decide that you know enough, you will eventually discover your error.  This may take years depending on how deeply invested companies are in the technology that you are expert in. Eventually however, something will come along to replace it. If you have established yourself as the 'Go-To-Guy' for the legacy technology, you will likely be tapped to maintain the legacy system until its replacement.

I am reminded of a quote from an old movie, Other People's Money.  The main character in one scene says: "You know, at one time there must've been dozens of companies making buggy whips. And I'll bet the last company around was the one that made the best goddamn buggy whip you ever saw. Now how would you have liked to have been a stockholder in that company?" Do you really want to be the last employee at a company maintaining the code/system/application they are actively working to replace?

You should always be looking to learn new technologies and diversify your skills. This makes you look like a proactive employee and thereby adds job security.  Having multiple different skills also reduces your chance of becoming obsolete. Even if one becomes less important over time, others should continue to be relevant.

Friday, October 18, 2013

Wanted: A Very Short Book That Has All the Basics of PL/SQL

A recent forum posting from someone just starting out with the Oracle database requested suggestions on a PL/SQL book for beginners.  He had some fairly restrictive requirements for it:

The book should...


  • Require no prior knowledge.
  • Be 200 pages or less.
  • Contain only the most most important elements of PL/SQL.
  • Function as a survival guide.

I write Oracle certification study guides.  By design, I make them as concise as possible in order to have a final product that can be used to help direct certification candidates while they prepare for the test and still be short enough to re-read a day or two before the exam date as a review. My guide for the OCA PL/SQL exam,
Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL, at 178 pages is not far from the supplied maximum.  However, by no means could the topics covered on the 1Z0-144 exam be considered '...
the most most important elements of PL/SQL'.  They are simply a reasonable set of the basic knowledge required to develop in PL/SQL.

In addition, even on the relatively focused subset of PL/SQL covered by the exam, the guide does not go into the depth that these subjects require for complete understanding.  Oracle professionals that have used PL/SQL will be able to put the information into context.  People new to PL/SQL will need to supplement the guide with other sources to really understand the material covered by the exam.  That is why I provide links to more details on the 1Z0-144 page on my companion website.


From this I can state with great confidence that there is no way that a 200 page book can simultaneously cover all of the important aspects of PL/SQL and be something that is written at a level that would be useful for someone new to the language.

One book that I consider to be an excellent A to Z resource for people just learning PL/SQL is Oracle PL/SQL Programming by Steven Feuerstein and Bill Pribyl.  It meets all of the required elements except for the page limit.  At 1,232 pages, it is just over six times the maximum requested.  No reason was supplied for the 200-page restriction.  Whatever the reason, if someone wants to start a career with Oracle as a PL/SQL developer, my advice would be to use the best resources available to learn the language rather than setting an arbitrary restriction on the size of that resource.

Saturday, October 5, 2013

Free 12c Beta Vouchers -- the Winners

I had a number of people ask for the vouchers. A couple did not follow the rules and were eliminated. There were six people that provided one or more links. I looked at the contents of each of the links and rated them based on how useful they would be for the exam. One link was for an article that was not about 12c and another was a duplicate of one provided by an earlier poster. These two were not counted at all. A number of links were perfectly valid articles about 12c... but on topics not covered by the 1Z0-052 exam. I gave these links half credit... worthwhile to read, but not part of a study program for the exam.

After evaluating all of this, the winners are:

+Bobin Varghese with four full-credit articles and one half-credit article.
+Henry FC with two full-credit articles and two half-credit articles.
+Андрей Басов1 with two full-credit articles.
+Yovanni Carpio with one full-credit articles and three half-credit articles.
+Daniele Pasian would have been fifth with one full-credit article. However, he won a voucher on Tim Hall's contest at Oracle-Base. Since he does not need another, the sixth-place entrant gets it.

+Hayde Castillo with three links on 12c (but none on exam topics) comes in sixth and squeaks in since Daniele has a voucher already.

For those of you that have won, use the 'Contact' page on my website to give me an email address to send the vouchers to.


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.