File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Which DB to learn

 
Sony Agrawal
Ranch Hand
Posts: 143
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
pankaj vijay
Ranch Hand
Posts: 75
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Sony Agrawal
Ranch Hand
Posts: 143
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 75
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
better to learn latest one... tutorial you can fine on internet easily
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic