Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

which DB to use for practice ? mysql or oracle?

 
suresh mandalapu
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI, i started looking into hibernate and spring..so which DB knowledge is good regarding job point of view? either mysql or oracle?
i am a newbee to sql/mysql/oracle..
initially i wanted to learn mysql.But now i am confused of learning oracle or mysql?
i posted this doubt in jdbc /spring forum also... sorry ..
thanks
suresh
 
Ram Para
Ranch Hand
Posts: 50
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
MYSQL is a good option. In 5.x you can find most of the functionalities.

Ofcourse its not robust like Oracle.

for start up I suggest go with MYSQL.

But from JOB perspective You should go for oracle.

I suggest go with MYSQL then migrate to Oracle
 
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper
Posts: 4968
1
Hibernate Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Howdy Greenhorns!

MySQL is real easy to play with, and easy to install. I don't even think it pings the registry or anything. Whenever I test a new technology, I like using MySQL - it tends to not get in the way too much.

Here's a little CBT tutorial I put together on setting up a Windows environment with MySQL. Enjoy:

Setting up a MySQL Environment on an XP Machine

-Cameron McKenzie
 
suresh mandalapu
Ranch Hand
Posts: 32
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks
 
Sagar Rohankar
Ranch Hand
Posts: 2907
1
Java Spring Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is it really matter ? All you have to know is sql ans pl/sql thing, If you have the database design knowledge like normaliazation, then it comes handy in understanding the database.
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, if you need to know PL/SQL, MySQL is no use.

Big databases like Oracle present quite a learning curve just to get going. With MySQL you can just get stuck in. On the flip side, MySQL is quite lax about some fairly key relational database concepts (for example, the MyISAM DB engine does not enforce constraints!) so if you are planning to do any database backed programming long term mix it up and use both.
 
Sandeep Awasthi
Ranch Hand
Posts: 597
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It does not really matter much if you use mysql or Oracle if you want to focus on Spring and Hibernate. Would be better if you use Oracle if you have job focus because it has been used in many enterprise level applications. If you do not want to use PL/SQL, you can choose to not to use it.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic