Difference between Oracle and MySQL??

  • Hey Buddies,

    I am a newbie in Oracle world. Also in here. In Fact I am a MySQL expert. I want to know that how much difference between Oracle and MySQL? I heard that some experts are talking that Oracle is much complex then MySQL and also its very difficult to learn. So I am lil bit afraid to start learning Oracle. Can anyone tell me how much effort should I give to learn Oracle?

    If I start studying 3 hours each day will it be enough to complete learning Oracle within 6 months?

    Need experts help...........

    Thanks for replies.........:-)

    Kamal

    Diabetes Type 1

    self defense

  • rnoakhali (7/15/2011)


    I am a newbie in Oracle world. Also in here. In Fact I am a MySQL expert. I want to know that how much difference between Oracle and MySQL? I heard that some experts are talking that Oracle is much complex then MySQL and also its very difficult to learn. So I am lil bit afraid to start learning Oracle. Can anyone tell me how much effort should I give to learn Oracle?

    I've only worked a little with either, yes Oracle is more complex. You'll probably get better answers to this on an Oracle board, rather than a SQL Server site.

    If I start studying 3 hours each day will it be enough to complete learning Oracle within 6 months?

    Completely learn, or get a working knowledge of the basics? I've been studying & working with SQL Server over 6 years I haven't completely learnt it

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • yeah u are quite right. I am a PHP programmer and I am working in that field more then 7 years. Still I dont think I have completed learning PHP!

  • rnoakhali (7/15/2011)


    ...So I am lil bit afraid to start learning Oracle. Can anyone tell me how much effort should I give to learn Oracle?

    If I start studying 3 hours each day will it be enough to complete learning Oracle within 6 months?

    Don't be afraid but do not think you are going to master Oracle in six months time.

    Assuming you have access to Oracle in your day-to-day job I would complement that by...

    1- building my own lab (I have one) this means you have a computer were you install Oracle, go for Ora11gR2. Oracle for educations purposes is license free 🙂 so, download and install.

    2- use Oracle documentation which is free, is online and is the best documentation on Oracle you can find anywhere in the world.

    Going back to your day-to-day job, ask you boos to get you a Metalink account/passowrd - Metalink is a Oracle what KB is a Microsoft and arguablle a little more.

    Good luck.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Great help....... I was thinking about those help files too. I noticed help files with every programming languages like Oracle, MsSQL etc. are the source of pure info.

    However Fantastic reply. Thanks dude...... 🙂

  • rnoakhali (7/16/2011)


    Great help....... I was thinking about those help files too...

    I was actually referring to the actual Oracle Documentation Library... every single book ever published by Oracle, all free and well organized.

    Try here for Ora10gR2... http://www.oracle.com/pls/db102/homepage

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Hi Everyone,

    I am very new to Oracle, I am planning to take some classes for Oracle 10G DBA.

    But I am getting confused like which is good whether MS SQL Server or Oracle.

    Can anybody help me out in this

  • rashu5577 (7/29/2011)


    I am very new to Oracle, I am planning to take some classes for Oracle 10G DBA.

    But I am getting confused like which is good whether MS SQL Server or Oracle.

    Both are good, both are implementations of the same underlying technology but they are different implementations.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Thank you.

    Then I can start up learning with Oracle DBA.

    Its one and the same , but have some changes in the Implementation

  • rashu5577 (7/30/2011)


    Thank you.

    Then I can start up learning with Oracle DBA.

    Its one and the same , but have some changes in the Implementation

    No. They are not one and the same, they just share a common basic DNA like monkeys and humans do.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply