Fog Creek Software
Discussion Board

Reading Recommendation Requested

I need to learn to write & understand SQL queries for a database with an Oracle backend.

Does anyone have a recommendation for a tutorial?


Todd D. Levy
Tuesday, July 6, 2004

SQL Queries for Dummies

You Don't Want to Know
Tuesday, July 6, 2004

You could always go to and sign up for a trial subscription and check out some of the books there.

Tuesday, July 6, 2004

Philip Greenspun has written one back in the Oracle 8i days:

Li-fan Chen
Tuesday, July 6, 2004

If you have Oracle running, read the Oracle documentation.  That's how I learned.

Wednesday, July 7, 2004

Also for any questions or problems you come across.....

Probably has the answer.

I just learnt Oracle PL/SQL recently. Some niceties compared to MS SQL although I do like the extra 'non standard' functions / sql code that MS gives you to do things.

James 'Smiler' Farrer
Wednesday, July 7, 2004

Not as a tutorial, but a good reference is O'Reilly's "SQL in a Nutshell"  I have an edition from 99 or 00 and it covers Oracle, MS SQL, mySQL, and Postgres.

Good stuff.

Wednesday, July 7, 2004

My typical approach to learning new things:

I usually just Google for tutorials on how to do a specific thing, and start there.  If you have to just SELECT, google for that with a term like "sql select oracle".  Etc. etc.  Once I start to get comfortable with the principles (can't emphasize enough how valuable it is to try to understand the principles - i.e. translate the code into your language in your mind so that you can "talk it out"), then I like to have a good reference book and a few websites available to go back to when I need to find a specific thing.

Bottom line, though, is that Google is your friend.  I believe that you are probably better off using Google and the web to learn something from the ground up than from a book.  That's just me though.

Clay Whipkey
Wednesday, July 7, 2004

Run the the store now and buy "Oracle Desk Reference" by Guy Harrison.  It is outstanding.

Grumpy Old-Timer
Wednesday, July 7, 2004

To Everyone:

Thank you all for your suggestion.

You have all been very helpful.

Thanks again,

Todd D. Levy

Todd D.Levy
Wednesday, July 7, 2004

*  Recent Topics

*  Fog Creek Home