ORACLE vs MySQL...! Which is best?

Question

I am thinking to begin with any databases which would suit me.I have a LITTLE c,c++ and java knowledge ill develope those very soon but now i want to know about DataBase too so help me friends....

Answer 1

a couple clarifications...



-- Oracle Express Edition versus Oracle database

if you just want to have an Oracle instance to learn the basics of Oracle the XE edition (currently only 11g) is your best choice, indeed

however the full versions of Oracle can also be downloaded for free from Oracle's download page ( http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html )

you merely have to create a (free) account with Oracle

if you want or need to familiarize yourself with "the real thing", this is the way to go

mind yourself, patches & official support from Oracle require a paying license (http://metalink.oracle.com/ ) but for XE the forums maybe helpful ( http://www.orafaq.com/wiki/Forums )

Google & the freely provided / accessible doc are your friends ;)



-- MySQL only for "small databases" ?!?

Facebook, small? i don't think so ( http://www.mysql.com/customers/ )

thus if you just want to get familiar with Database and don't aim at becoming an "Enterprise guy", MySQL is just as good an option. possibly even better, as small companies are more likely to use MySQL then Oracle.

and any database nowadays supports Java & C/C++



SQLite is cute, but mostly used on mobile platforms (Android, Qt aso.)

well, Firefox uses it on all platforms as well, as a matter of fact

it is commonly used as "registry" replacement by many softwares; thus may come in handy for (software) development

Answer 2

Mysql Vs Sql Express

Answer 3

MySQL and Oracle are apples and oranges. Oracle is designed for managing huge data sets while MySQL is more suited towards smaller data sets. I would start with MySQL first since it's free and there's an abundance of tutorials on the internet.

Answer 4

Start with MySQL, because it is lighter than Oracle, easier to install,use and learn. First try to learn basic SQL syntax, and gradually go deeper. Plus, try to use it from command line, without using any GUI client, because it will help you to learn the basic commands faster.

Answer 5

in reply to John



a free version of Oracle does exist



http://www.oracle.com/technetwork/products/express-edition/overview/index.html



granted, it's got limits compared to the "real" version but if you're only using it to learn then its awesome



MySQL is of course totally free, probably easier to learn than Oracle, but not as powerful as Oracle



but then again, if you're just starting out and learning, MySQL will meet all your needs



if you really want to go the easy route, start with SQLite



http://www.sqlite.org/



and then install this for a GUI



http://sqliteadmin.orbmu2k.de/



SQLite tutorial here

http://www.tutorialspoint.com/sqlite/sqlite_tutorial.pdf



and how to use C with SQLite

http://www.tutorialspoint.com/sqlite/sqlite_c_cpp.htm



adn with Java

http://www.tutorialspoint.com/sqlite/sqlite_java.htm

Answer 6

in terms of economic factor , MySQL is FREE while ORCLE isn't.

comparing by features ORACLE is the KING.