RECOMMENDED BOOKS FOR THE ORACLE PROJECT

Hi,

Which is the best book to learn/understand the syntaxes used in Oracle, please give the name of the author and ISBN number of the book.

Also, I would like to start building/developing sample projects based on oracle on my own, so which is the best guide/book which has sample projects to work one after the another.

Someone please advise.
JohnSrinivassanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sventhanCommented:
Oracle Database 10g PL/SQL Programming by Oracle Press

Author : Sctott Urman, Ron Hardman, Michael McLaughlin
0
sdstuberCommented:
Get these three.  Read them twice, and keep them handy..

Oracle PL/SQL Programming by Steven Feurstein  mine is old, but I'm sure you can find the new isbn
Expert Oracle by Design by Tom Kyte    0-07-223065-7
Expert One-on-One Oracle by Tom Kyte       1-59059-243-3

You "might" want to subtitute Expert Oracle Database Achitecture by Tom Kyte for his one-on-one, smaller, but newer material. 1-59059-530-0

0
sventhanCommented:
Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series) by Kevin Loney
Oracle Database 10g SQL (Osborne ORACLE Press Series) by Jason
Oracle Database 10g: A Beginner's Guide (Osborne ORACLE Press Series)
by Ian Abramson , Michael Abbey , Michael Corey
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

sdstuberCommented:
"The Complete Reference"   ?  really?

I've found those books horribly incomplete.  Sometimes erroneous and my most disappointing reads.
I'll admit I haven't seen the 10g one, but after the earlier editions I've given up on that series.
0
sventhanCommented:

I would use them still for refering the SYNTAX and they come with the sample CD's(you do not have to type the code samples).  You're right when you compare with TOMKYTE's. TOM's books are must have ones but you need to have little bit understanding about oracle before start reading them.

You do not need any books if you're ok browing over the net.  For me the best book now is "EE".


0
sdstuberCommented:
for syntax, I use Oracle's documentation.

I keep the 7.3.4, 8.1.7, 9.2, 10.2 and 11.1 documentation on my harddrive.
With bookmarks in my browser to point to the most commonly used....
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sventhanCommented:
Like SD said, this book also a great reference..
-- Oracle PL/SQL Best Practices by Steven Feuerstein

I also agree with SD about the Oracle Documentation. I'll do the same.



0
adrian_angCommented:
it's a long long run I guess :) and your are at the start line, then just read the Concepts guide in the documentation. It's not about command syntax, but it will give you very good foundation in your further readings.
0
JohnSrinivassanAuthor Commented:
Stuber,
Thanks for the advise.  Please give me the URL to download these documentations, I will also buy the books recommended by you.
Be in touch.  
0
JohnSrinivassanAuthor Commented:
Adrain,
Are you talking about these documents?

2 Day Developer Guide HTML  PDF  
2 Day Plus Application Express Developer's Guide HTML  PDF  
2 Day Plus Java Developer Guide HTML  PDF  
2 Day Plus .NET Developer Guide HTML  PDF  
2 Day Plus Locator Developer Guide HTML  PDF  
2 Day Plus PHP Developer Guide HTML  PDF  
Application Express User's Guide

0
sdstuberCommented:
http://www.oracle.com/technology/documentation/index.html

11,10 and 9 have links toward the top of that page.

for 8 and 7 you'll have to go to bottom of the page in the "previously released" section

0
JohnSrinivassanAuthor Commented:
Stuber,

I have now downloaded the documents as per your advise.   Please state in which folder, it contains the syntax information.   There are lot of folders, but I could not locate, in folder/file I can find the
basic concepts of syntax etc.
7.3.4 =
8.1.7 =
9.2 =
10.2 =
11.1 =
0
sdstuberCommented:
Start with the index.html page in each documentation set.

That will point you to a list of books.  Each version rearranges the files and that page a little differently.

"SQL Reference" is the book you're looking for.
0
JohnSrinivassanAuthor Commented:
Hi Stuber,

Ok, thanks for the guidance.  I hope this question is now complete.  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.