aspose file tools*
The moose likes JDBC and the fly likes Which DB to learn Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Which DB to learn" Watch "Which DB to learn" New topic
Author

Which DB to learn

Sony Agrawal
Ranch Hand

Joined: Oct 04, 2009
Posts: 143
I know a bit of JSP and servlets. I am trying to learn database stuff. I want to know which one to learn Oracle or mySQL.
Is there any difference between them???
Which one is more used with respect to java.
Or, are my question dumb??
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

There is quite a lot different between the two, but the basic concepts are the same so either are fine to learn on. Both are well suited to use with JDBC. Knowing Oracle is a good thing to have on the CV, but it is a much steeper learning curve (Oracle is a much bigger beast than MySQL). MySQL suffers a little in that some of their db engines depart from the behaviour you would expect relational databases to follow, such as the MyISAM db engine not honouring foreign key constraints, so it is possible to pick up bad habits.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
pankaj vijay
Ranch Hand

Joined: Apr 01, 2008
Posts: 75
hi sony ..
The main thing is concepts. If you have good concepts on any one of them then you can go for other one very easily.
Your question is which one to pick? as i think you can pick the one on which you are working at present. Because you are asking with respect to java. So for you main thing is programing language java. Better to concentrate on java & learn any one DB. I think you want to learn basics of DB not full DB.
There is a big difference in both DB. you should think about those differences if you want carrier in DB field. If you want carrier in java then learning basics is i think sufficient.
Anyway It is good to have oracle in your CV


Pankaj Vijay (SCJP, SCBCD)
Learn Core Java,Learn Servlet Jsp, SCJP Questions,Struts Tutorial
Sony Agrawal
Ranch Hand

Joined: Oct 04, 2009
Posts: 143
Thank you for your suggestion.
I think i will pick oracle because of the reason i would be working that in my next project.
Can you guys tell me which version to choose??? i mean 9 or 10 ....
can you tell me which tutorial is good for that...
pankaj vijay
Ranch Hand

Joined: Apr 01, 2008
Posts: 75
better to learn latest one... tutorial you can fine on internet easily
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

9 is no longer supported, so I would not bother with that at all. pankaj's advice is sounds; I'd start with 11g. The basics (from a developer's point of view) don't really change that much from version to version however.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Which DB to learn