Fog Creek Software
Discussion Board




Recommendation on book for an Oracle newbie

Hi:

Can anyone recommend a book to start learning Oracle? I am a real beginner and I hope to start using Oracle in software development.

But I would like the learning curce to be gentle :)

Has anyone come across a good book for beginners?

Jane M
Tuesday, October 07, 2003

SQL for Web Nerds http://philip.greenspun.com/sql/

Matthew Lock
Tuesday, October 07, 2003

"Getting Started with Oracle"
http://otn.oracle.com/products/gswo/getstart.html

Matthew Lock
Tuesday, October 07, 2003

The Oracle Desk Reference is a must-have for anyone working with Oracle:

  http://www.amazon.com/exec/obidos/ASIN/013013294

Grumpy Old-Timer
Tuesday, October 07, 2003

Just to clarify - are you a database newbie as well? Or do you have experience with other databases?

Philo

Philo
Tuesday, October 07, 2003

The Complete Oracle Reference (at this point the version is 9i) http://www.amazon.com/exec/obidos/tg/detail/-/0072225211/qid=1065555708/sr=8-2/ref=sr_8_2/002-1922960-7973627?v=glance&s=books&n=507846 is perhaps the only book for developers worthey of having the word "Complete" in it's title and is some of the best money I have ever spent. 

K
Tuesday, October 07, 2003

Reference... is just reference not studybook. All Oracle docs are available online at technet.oracle.com not need to buy one.

I have no good recommendations for beginners book (our beginners spend 5 days at Oracle's SQL for beginners course) but after 6+ months with Oracle you really should read Concepts manual. If you do not like manual buy Thomas Kyte books.

msc
Tuesday, October 07, 2003

Maybe:

Beginning Oracle Programming by Sean Dillon, Christopher Beck, Thomas Kyte, Joel Kallman (Contributor), Howard Rogers
http://www.amazon.com/exec/obidos/ASIN/186100690X

and then

Effective Oracle by Design by Thomas Kyte
http://www.amazon.com/exec/obidos/tg/detail/-/0072230657//103-2944356-5466269

msc
Tuesday, October 07, 2003

msc,

"(our beginners spend 5 days at Oracle's SQL for beginners course)"

Do you have any information on this course? Or does anybody have any information on this sort of thing available in Sydney, Australia? I have looked at all of the mainstream training companies and none of them run Oracle courses.

ChrisO
Tuesday, October 07, 2003

re: Do you have any information on this course? Or does anybody have any information on this sort of thing available in Sydney, Australia? I have looked at all of the mainstream training companies and none of them run Oracle courses.

Oracle themselves run a training courses on SQL, DBA. The website you want is http://www.oracle.com/au/education and it should have enough details on courses in sydney. Searching for SQL at the find a course page provides the following description for the "Introduction to Oracle9i: SQL" course

This class is applicable to Oracle9i and Oracle8i users. This course offers students an extensive introduction to data server technology.The class covers the concepts of both relational and object relational databases and the powerful SQL programming language.

Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. Students learn to retrieve data by using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval.

They also learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output.Demonstrations and hands-on practice reinforce the fundamental concepts.

i've found oracle education to be very useful for my job, having done both the dba course and backup & recovery courses through them. btw, i'm not affiliated with oracle, we just use them extensively here at my work.

hope this helps.

ko
Tuesday, October 07, 2003

Thanks very much ko. I will look into this.

ChrisO
Tuesday, October 07, 2003

I agree with msc, "Beginning Oracle Programming" is a great book.

Fredrik
Wednesday, October 08, 2003

*  Recent Topics

*  Fog Creek Home