LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-03-2009, 02:25 AM   #1
icecubeflower
Member
 
Registered: Mar 2008
Location: USA
Distribution: Slackware 13.1
Posts: 304

Rep: Reputation: 33
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.
 
Old 08-03-2009, 03:29 AM   #2
Johnnie J
Member
 
Registered: Mar 2008
Posts: 54

Rep: Reputation: 16
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.
 
Old 08-03-2009, 06:21 AM   #3
icecubeflower
Member
 
Registered: Mar 2008
Location: USA
Distribution: Slackware 13.1
Posts: 304

Original Poster
Rep: Reputation: 33
No I don't have any oracle access.
 
Old 08-03-2009, 06:27 AM   #4
jan5134
LQ Newbie
 
Registered: Mar 2009
Location: pretoria,SA
Distribution: Centos/Ubuntu
Posts: 9

Rep: Reputation: 0
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
 
Old 08-03-2009, 09:40 PM   #5
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,240

Rep: Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324Reputation: 2324
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
 
Old 08-03-2009, 10:59 PM   #6
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,066
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Recommendation of SQL Book? shreks Linux - Software 5 05-05-2008 08:53 PM
PHP and SQL book berrance General 2 03-03-2005 09:35 AM
Oracle SQL+ darkRoom Programming 2 05-20-2004 10:01 PM
What's the best SQL book? Travis86 Programming 2 09-08-2003 11:28 AM
SQL and Oracle Rutnut Linux - General 3 04-07-2002 01:39 AM


All times are GMT -5. The time now is 10:37 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration