9 Replies Latest reply: May 27, 2013 6:06 PM by GoodfireGeorge RSS

    Why I've choosed Oracle Certifications over SQL Server's : Highly Specified

    GoodfireGeorge
      Since doing my Internship on SQL Analysis/Optimization on both Oracle and SQL Server as we support both for our Products, I wanted to target a relevant certification to enforce my experience and as a consequence my CV.

      I was in hesitation on choosing between an SQL Server certification or an Oracle Database Certification.
      Instinctly I would have gone for SQL server for the following reasons
      1. As I'm new and totally unexperienced it feels much easier and appealling to me
      2. It is more simple and thus easier than Oracle
      3. I've Experienced it more - since the first weeks as introductive, while Oracle was and is a more misty field

      But the basic reason I decided to head towards Oracle was Simple : Highly Specified Certification.

      In my placemnt, I primarly analyse and optimize preset API SQL Statements. So what I learn and do, is SQL and SQL optimization techniques.
      And on Oracle I can be provided certifications specifically for this. SQL Expert, PL/SQL, SQL Tuning.
      On the other side, Microsoft hasn't such a thing at all, with the only Certification available being MCSA.
      To get the MCSA certification I need 3 different Exams 1 Querying 2 Administering 3 Implementing a Data Warehouse with Microsoft SQL Server 2012
      Sector on which I dont have a clue. So a logic +"Either Everything or Nothing"+ No thank you sir I wont take.

      At the best I can take just the 1.Querying BUT
      1. It combines SQL, T-SQL, Optimization in one Exam. But I dont work much with T-SQL, I would prefer an exam just on SQL or Optimization. AND
      2. Its not even considered a full Certification

      While in Oracle I can (if I'll make it and find time for their bigger extend) take a Certification on SQL, and a Certification on Tunning which are the exact fields of my Placement.
      And if i suceed I can extend to PL/SQL, but until then I dont have to bother for PL/SQL which I dont use much.
      I dont care if I need separate payments and procedures, since I can organise Studies & Exercise one field at a time, than having to care for both PLUS a field I dont actually use much.
      And then there is also the positive that you will gain certification for the Top and mos advanced DBMS. And that its not only about that Oracle Devs are less and thus maybe more easy to get hired but also that "if you learn the Difficult(Oracle), then if you have to learn the Easy (SQL Server) it would be easier possible, than the opposite"

      So Oracle Certs have in my case that positive Frame
      1. Specified Certifications Mirroring Exactly your Sectors
      2. Helps self-organisation your Study-Learning Distincting each sector
      3. No1 DBMS, more promitment,
      4. As more difficult, it will be surely easier to transfer to SQL Server if there will be need afterwards , than the opposite

      While SQL Server Certifications on the opposite have a negative Frame
      1. Only Full Certification is MCSA for the Entire SQL Serve Set, things I dont know
      2. Only an Exam 1.Querying is possible, which is Not A full Certification
      3. Mischiefs 3 fields to 1 SQL, Optimizing, T-SQL in one for which I dont operate all on the same level and will fragment the study organisation (no educative logic at all)
      4. SQL Server is Easier than Oracle. Being 22 yet, if need comes up it will be harder to transfer to Oracle. The opposite will be easier i think.

      Well under these circumstances for my situation, to set on Oracle Path I think it was more than clearly better.
      It outpasses even the needing of X4 funds for the same knowledge (SQL+Tuning+PL/SQL)
        • 1. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
          bigdelboy
          Tram 38 Heurigen @ Grinzing. Chill out.
          • 2. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
            Matthew Morris
            bigdelboy wrote:
            Tram 38 Heurigen @ Grinzing. Chill out.
            I'm particularly glad that these lovely children were here today to hear that speech. Not only
            was it authentic frontier gibberish, it expressed a courage little seen in this day and age.
            • 3. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
              GoodfireGeorge
              Er... what are you talking about I don't get a clue :S
              • 4. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
                orafad
                Goodfire George wrote:
                1. As I'm new and totally unexperienced it feels much easier and appealling to me
                2. It is more simple and thus easier than Oracle
                Why do you say that?

                It might seem easier on the surface, a point and click interface might be easier acessible for some, but both are complex product suits and neither database engine/platform has a small or "easy" feature set.

                My view is sort of the opposite of yours (of course, it might be a natural view from a long experience with databases and data systems); Oracle DBAs have to be good at what they do, when on the other hand almost anyone can fool themselves thinking they are MSSS DBAs (clicking around in a "explorer" like interface, how hard can it be?). But in reality, it will takes ten's of years of learning and doing on each platform and their applications to be really great at it.

                3. I've Experienced it more - since the first weeks as introductive, while Oracle was and is a more misty field
                Seems like this is the key - you'll only really learn when you dive in and try, fail and try again... (different thresholds on learning curve/steps may vary).

                On the other side, Microsoft hasn't such a thing at all, with the only Certification available being MCSA.
                You seem to have completely missed the Pro, Master and even Architect levels. Also, for the more "specified", there's implementor, db developer, BI developer tracks with TS and ITP exams/certifications.
                For your case you may want to compare with MCITP Developer track, which has a certificate after each exam (TS, then ITP).

                Remember that MS has a different certification layout. There may be 3 or even 5 steps (exams) before you'll get certified on some level, where as you might need 1 or 2 exams completed to get a Oracle Database cert.
                To get the MCSA certification I need 3 different Exams 1 Querying 2 Administering 3 Implementing a Data Warehouse with Microsoft SQL Server 2012
                See previous points :)
                At the best I can take just the 1.Querying BUT
                1. It combines SQL, T-SQL, Optimization in one Exam. But I dont work much with T-SQL, I would prefer an exam just on SQL or Optimization. AND
                2. Its not even considered a full Certification
                Again, look at and compare with Querying/Development and Designing Database Solutions.

                Depending on your outset and "point of view" on things, on the road ahead you could choose to not be blind to "the other side" (whichever one) but learn to discern and apply, reinforcing knowledge from whatever aspect you'll learn and see and know. Be open and open to re-learning stuff. If you don't take things too literally, sql and performance and scalability matters exists on both platforms. You might be able to learn e.g troubleshooting and optimization, not O* troubleshooting and optimization. Also this is a wast area, about performance, becuase you'll need to know systems, how systems fit toghether and maybe more importantly how the users use the system, how they think they use the system, getting to know them and how to hear and control their expectations (yes, you'll be amazed in ten or twenty yers from now how much "psychology" this really is about).

                The (hopefully long) road towards/before exams and certification is what you should put your mind and effort to. As with most other aspects of life; there are no quick fixes - that is just how we "ignore" things we not really want to invest in.

                >
                While in Oracle I can (if I'll make it and find time for their bigger extend) take a Certification on SQL, and a Certification on Tunning which are the exact fields of my Placement.
                Yes, and for you and your outset that might be a good place to start. But consider actually learning SQL and learning tuning (which will take years) not just "take a certification".
                And if i suceed I can extend to PL/SQL, but until then I dont have to bother for PL/SQL which I dont use much.
                This might be a sign of "narrow tracking" too early. Learning a little PL/SQL or whatever skills will help in ways you do not yet know. Read what EdStevens has written on the forums on the topic of studying (learning systems from having a major within music).

                It outpasses even the needing of X4 funds for the same knowledge (SQL+Tuning+PL/SQL)
                Knowledge does not come from taking exams (if you don't mean the "I know how to do multiple choice tests"-kind of knowledge).

                Perhaps it is better in the long run if you study and experience and do the things you like to do, and let the certificates come later on when the time is right.

                Edited by: orafad on May 26, 2013 12:00 PM

                Edited by: orafad on May 26, 2013 12:01 PM
                • 5. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
                  bigdelboy
                  Goodfire George wrote:
                  Er... what are you talking about I don't get a clue :S
                  I see warning signs of perhaps you are taking a too intense approach to planning your learning/certification paths.
                  I may be wrong in this view, but it may besensible to ease off.
                  Employers will often for a balance in an employees study/domestic life; and some may be worried about too much emphasis on study.

                  I always get concerns aobut people who who wish to head straight for 1z0-047. For some it is the correct choice, for others it isn't. Matthew Morris has talked about it elsewhere.
                  In a simple point of view I would initially concentrate on getting your SQL knowledge to 1z0-051 pass standard; even if your then choose not to take the exam. (Though passing 1z0-051 gives an early win, a milestone ( the only danger is it may make you over-confident about 1z0-047).
                  Get a good foundation, then build on it.

                  If you worry about SQL Server you may dilute your effort.

                  orafad's done a pretty good job of answering your original post and i wont try to add to it.

                  Good Luck!
                  • 6. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
                    GoodfireGeorge
                    as I sed I just see it as a method to learn suplementary things, which I dont use in work problems.
                    The exam itself and cert means nothing too me, I use it only as a resource index for the Basic SQL concepts that someone should know in the industry for a promitment start as a beginner.
                    I havent believed a sec the you will really be an Expert at SQL after gaining it.


                    The cert itself I see it just a typical plus to my cv compared to if I stay just with the internship duration and placement.
                    It wont tell my real experience, as I ses

                    Er for my situation its a decission in the good direction isnt it? I mean what else could I do as an extra?
                    I'm 22 on my 1st 6months Internship on SQL Analysis/Optimization, and as an extra I plan to take some certification also on what I will have done on my placement :S
                    Its a rational direction wright ? :S
                    bigdelboy wrote:
                    I always get concerns aobut people who who wish to head straight for 1z0-047. For some it is the correct choice, for others it isn't. Matthew Morris has talked about it elsewhere.
                    In a simple point of view I would initially concentrate on getting your SQL knowledge to 1z0-051 pass standard; even if your then choose not to take the exam. (Though passing 1z0-051 gives an early win, a milestone ( the only danger is it may make you over-confident about 1z0-047).
                    Get a good foundation, then build on it.
                    Err...its a matter of funds also :S I have to pay for 2 exams with the 1st being the 30% of the 2nd not even being a Cert. :S I may from start read and exercise tilli reach the required level for 0047.

                    Its like Speaking Languages, you usually gor straight for the B2 after 2 years insted of giving all intermediate levels every 6 months A1 A2 B1 B2.
                    ( I specialise to Speaking Languages with fluency on Greek, Italian, English, French and now learning German, Spanish )

                    P.S.
                    orafad we reached to know better of teh 'Cert Knowledge' in Greece, in dozens histances.
                    An histance is English, almsot everyone of my generation has Proficiency Cert but few can use it even at basic level XD
                    (Public Sector was requiring Certs just bureocratical as papers to get hired. A lifetime Placement to the Public Sector was the Greek Dream for a big part of population till the bankruptcy. )

                    Edited by: Goodfire George on May 27, 2013 1:02 PM
                    • 7. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
                      bigdelboy
                      Err...its a matter of funds also :S I have to pay for 2 exams with the 1st being the 30% of the 2nd not even being a Cert. :S I may from start read and exercise tilli reach the required level for 0047.
                      If money is the overriding factor
                      The cheapest SQL exam that may be available this year is 1z1-061 (beta version of 1z0-061).
                      The fact oracle press have a book planned for it is a good indicator ( OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press) ... Roopesh Ramklass (Author) . ISBN-13: 978-0071820288.) Ref: eg. Amazon or alternatives.
                      Please be aware:
                      - The future is not predicatable.
                      - Database 12c is never (really) mentioned by oracle until they release it. However it will almost certainly be this year.
                      - This exam release will not predate the Database 12c announcement. It may follow it by a margin. It might even not happen.
                      - Beta exams are offered relatively cheaply ... less than maybe 10 bottles of cheap plonk.
                      - You have to wait 12 weeks after the beta end to get the result ... and the beta end is sometimes extended last minute by months ...
                      - Beta exams give you more questions in less time.
                      - Beta exams last for longer than ordinary exams.
                      - You may feel like you have been in a washing machine before and for some days after taking a beta.
                      - Matthew hates betas ... Matthew avoids betas.
                      - The window between beta announcement and close may be short.
                      - There is no guarantee a beta will be offered.
                      - The Oracle Press book almost certainly wont be published until after the beta ends.
                      - Oracle 12c SQL shouldn't be a big change from 11g SQL .... especially at least at this level.

                      To summarise: If you keep your eyes open a chance of a cheap Oracle SQL exam may pass by you this year ... however there may be many reasons not to go for it, and several challenges if you do. And dont rely on it.
                      • 8. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
                        Matthew Morris
                        bigdelboy wrote:
                        - Matthew hates betas ... Matthew avoids betas.
                        As a general rule, Matthew doesn't talk about himself in the third person, but he will do so here for continuity. Matthew has written an article discussing the pros and cons of betas here:

                        http://ocprep.blogspot.com/2013/04/oracle-beta-exams-good-bad-and-ugly.html

                        And about waiting for the 12c release before getting certified here:

                        http://ocprep.blogspot.com/2013/04/should-i-get-certified-as-oracle-11g.html
                        • 9. Re: Why I've choosed Oracle Certifications over SQL Server's : Highly Specified
                          GoodfireGeorge
                          Yes yes he did and they are fully rational both, as the "what if 12c comes out" :)
                          I'm a fun of Matthew XD lool

                          Price is a factor for me but I will never act as a blind begard in ****'s name.
                          In that spirit I won't case the cheaper exam for 40 or 50 euros less neither hunt betas.

                          At the specific case, the money facto was supported by the
                          "Also why bother with an exam that grants no certification, when I can study a +25% or even +100% and go straight for the Cert "

                          If Fundamentals I was at least a distinct certification like "SQL Certified Associate" (Like the PL SQL Basic/Advanced ones )
                          I would have gave it for sure even if it wasnt prerequired and go both for Expert afterwards.

                          But now 1.Not a Cert + 2.30-60% of SQL Experts + 3. 25$ euros = No Way