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??
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.
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
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...
Joined: Apr 01, 2008
better to learn latest one... tutorial you can fine on internet easily
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.