Oracle/SQL book
 

Hey what is the best way to learn Oracle and SQL on your own? Is there a good text book I should buy or is there a good website?

I don't really know anything about it. I'm vaguely aware Oracle is a massive program that you don't run on your own little PC. I think you write your own programs and they communicate with the Oracle program with SQL commands or something.

Do you have access to Oracle? It comes in many versions, so you'd want to get a book that corresponds to the version your using. You can also get books on MySQL and PostgreSQL. These programs are available for free on Linux/BSD OSs and although different than Oracle would provide a very good base of knowledge for working with an Oracle DB.

No I don't have any oracle access.

Hi,

Both Oracle and Mysql uses SQL (the language), install mysql and get a pdf.
Will certainly help you. If you then manage later on to get your hands on Oracle you'll allready know the basics.
Good Luck!!!!

Jan5134

If you want to start with MySQL, which comes free on Linux, the online docs are: http://dev.mysql.com/doc/refman/5.0/en/
You can (afaik) get a free at home/dev use only version of Oracle.
Oracle docs here: http://tahiti.oracle.com/
Oracle free SW: http://www.oracle.com/technology/software/index.html

GIYF
:)

Even though, given MySQL abundant "extensions" and deviations from the SQL
standards, choosing that to learn SQL may not be the brightest idea.


The SQL Zoo is a very nice resource, though, it will let you
experiment (admittedly with a limited data set) with 5 different
SQL flavours (Postgres, Oracle, MS SQL, DB2 and MySQL.


Cheers,
Tink