Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

which DB to use for practice ? mysql or oracle?

 
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
 
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
 
author and cow tipper
Posts: 5000
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
 
Ranch Hand
Posts: 2908
1
Spring Java 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.
 
Bartender
Posts: 10336
Hibernate Eclipse IDE 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.
 
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.
 
This is awkward. I've grown a second evil head. I'm going to need a machete and a tiny ad ...
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic