top of page
  • Writer's picturekyle Hailey

Where to begin with Oracle and SQL


Here is my list and everything on this list is excellent. I’m sure I missed a few good ones, but maybe people can add them in the comments.

Start with Oracle Docs, they are free and good!

  1. http://www.oracle.com/pls/db112/homepage

Get the best books and read them

  1. Expert Oracle Database Architecture by Thomas Kyte

  2. Troubleshooting Oracle Performance by Christian Antognini

  3. Refactoring SQL Applications by Stephane Faroult

A bit old, but this is a great overview of Oracle: Practical Oracle 8i by Jonathan Lewis

After you have read the above, dive into the important details:

  1. Optimizing Oracle Performance by Cary Milsap

  2. Oracle Core Essential Internals by Jonathan Lewis

  3. Oracle Wait Interface by R Shee, K Deshpande, K. Gopalakrishnan

If you know SQL but want to get great at SQL performance, read these books

  1. Cost-Based Oracle Fundamentals by Jonathan Lewis

  2. SQL Tuning by Dan Tow

  3. Relational Database Index Design and the Optimizers by Tapio Lahdenmaki

Join Online discussions and follow blogs

  1. Oracle-L forum: www.freelists.org/list/oracle-l

  2. OTN forums: https://forums.oracle.com/forums

  3. Oaktable blogs: http://www.oaktable.net/oakienews

Create your own Oracle blog aggregator, here is mine: http://oracle.collected.info/

Go to conferences. First of all your local Oracle user groups and if you have the time and resources then go to the bigger conferences:

  1. Hotsos

  2. RMOUG

  3. UKOUG

0 views0 comments
bottom of page