This discussion is archived
8 Replies Latest reply: Jan 15, 2013 10:30 AM by matthew_morris RSS

passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?

Philippe Ludwig Newbie
Currently Being Moderated
I passed 1Z0-051 a few weeks ago.

- How long is the exam 1Z0-051 valid? I know that I need to take second exam to receive certificate. Can I do that for example in 6 years?
- what's the easyiest second exam to receive certificate? I know nothing more Oracle than the topics in 1Z0-051 :(
  • 1. Re: passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?
    bigdelboy Pro
    Currently Being Moderated
    Philippe Ludwig wrote:
    I passed 1Z0-051 a few weeks ago.

    - How long is the exam 1Z0-051 valid? I know that I need to take second exam to receive certificate. Can I do that for example in 6 years?
    Your 1z0-051 exam pass remains valid forever, well for life, (unless ones does something extremely naughty and gets oneself decertified)

    However at some point it may cease to be a valid pre-requsite for certiications.

    My best guess is it will be a valid SQL certification for some years .... the major issue would be a switch from non-proctored exams. A revised SQL exam for 12c may emerge in 2013
    - what's the easyiest second exam to receive certificate? I know nothing more Oracle than the topics in 1Z0-051 :(
    Try to learn a little PL/SQL .... initially just try to learn it dont focus at cerification ... if you can get on with it go for PL/SQL with 1z0-144.

    You could do 1z0-052 ... but if you cant get on with with PL/SQL then a DBA track does not seem like a good option.

    1z0-117 and 1z0-047 are other possibilities, both require some sweat.
  • 2. Re: passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?
    matthew_morris Expert
    Currently Being Moderated
    ...what's the easyiest second exam to receive certificate? I know nothing more Oracle than the topics in 1Z0-051
    Well an exam that is largely SQL that will grant you an immediate certification is: *1D0-541: CIW Database Design Specialist*

    This isn't an Oracle certification, but rather a vendor-neutral database certification. From the topics list, I consider it to be a reasonable entry-point to database certifications. In addition to SQL, it contains topics on the basics of relational databases, and database design.
  • 3. Re: passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?
    Philippe Ludwig Newbie
    Currently Being Moderated
    Thanks Matthew. The CIW exams (they offer exams about many webmaster related topics) have low reputation. That's why wish to go the Oracle direction.
  • 4. Re: passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?
    Philippe Ludwig Newbie
    Currently Being Moderated
    bigdelboy wrote:
    Try to learn a little PL/SQL .... initially just try to learn it dont focus at cerification ... if you can get on with it go for PL/SQL with 1z0-144.
    thank you.

    Have here "Oracle PL/SQL Programming, 5th Edition" from O'Reilly Media. That's really complicated. Do you recommend me some kind of "for dummies" books for PL/SQL? SQL was my first programming language (some friends even say it's not a programming language).

    Is 1z0-144 really simpler than Admin I?
    You could do 1z0-052 ... but if you cant get on with with PL/SQL then a DBA track does not seem like a good option.
    why?
    1z0-117 and 1z0-047 are other possibilities, both require some sweat.
    Did I understood right, that these possibilitites are more complicated than the above?
    I tried SQL Expert but failed a few times. The other is not an option because no official study guide.
  • 5. Re: passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?
    matthew_morris Expert
    Currently Being Moderated
    They don't have the prestige of an Oracle certification for sure. That's why I consider 1D0-541 to be an entry-level cert. I found this essentially by accident. An online training vendor (who shall remain nameless) that offers Oracle training offered an incredible deal for trying out their product. I tried it, only to find out that their Oracle courses weren't part of that deal. The only database certification that was included was one for 1D0-541. I took that course to get a feel for their training. The intro deal cost me a dollar, so I wasn't too put out by the experience. That said, the course didn't impress me enough to shell out regular rates for their Oracle offerings.

    The 1D0-541 certification, however, is one that I probably will pick up at some point. I discussed this test at some length on the ORAFAQ forum here:

    http://www.orafaq.com/forum/t/181996/0/
  • 6. Re: passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?
    matthew_morris Expert
    Currently Being Moderated
    Philippe Ludwig wrote:
    SQL was my first programming language (some friends even say it's not a programming language).
    SQL doesn't really pass the bar as a 'programming' language because it is not procedural. That's actually what the PL in PL/SQL means. It is adding procedural capabilities to SQL.
    Is 1z0-144 really simpler than Admin I?
    Depends on the person really. I'd put the two about comparable, although they test very different knowledge and abilities. However, I would definitely say that entering the Oracle job market as a PL/SQL programmer is easier than entering as a DBA for someone with no work experience with Oracle.
    You could do 1z0-052 ... but if you cant get on with with PL/SQL then a DBA track does not seem like a good option.
    why?
    DBAs should generally know at least a little PL/SQL. Certainly they should know the basics that are covered in 1Z0-144.
    1z0-117 and 1z0-047 are other possibilities, both require some sweat.
    Did I understood right, that these possibilitites are more complicated than the above?
    I would say that either of the above would rate as more complex than either 1Z0-144 or 1Z0-052. 144/052 are both OCA-level exams. This means that they are intended to cover topics at an entry-level. By contrast, 117/047 are OCE-level exams and are intended to cover topics at an expert-level.
  • 7. Re: passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?
    Philippe Ludwig Newbie
    Currently Being Moderated
    Matthew please update us when you took 1D0-541. I am interested comparing 1D0-541 with Oracle entry-level exams.
    I googled 1D0-541 and found discussions at techexams.net where people get 1D0-541 very easily as part of their studies in school.
  • 8. Re: passed "1Z0-051 Oracle Database 11g: SQL Fundamentals I". Next steps?
    matthew_morris Expert
    Currently Being Moderated
    Please update us when you took 1D0-541.
    Your question is past tense, but I haven't taken it yet. I still plan to, but have been busy. It's one of several tests in the pipeline for me. I'm sure that I could pass it now... but that's not the point. If you read my posting at OraFAQ -- I'm using this test as an excuse to strengthen my design methodology. I'm aware that my normal behavior development style tends to skimp on the design aspect so I can get to development ASAP.
    I googled 1D0-541 and found discussions at techexams.net where people get 1D0-541 very easily as part of their studies in school.
    That doesn't shock me. The information in the topics list is very similar to the curriculum of a database theory & design course I took in college (long long ago). This test strikes me an an entry-level cert that would be appropriate for someone starting out in Oracle. I put it at about the same level as 1Z0-051 based on the topics (I'll know more once I take the exam). This is why I considered it an option since you were looking for a 'next step' from 1Z0-051 and I know you've had problems with 1Z0-047.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points