Tools for me to study PLSQL

Palm for me to study on buses and trains. Head light for me to study under blanket.

I noticed that studying PLSQL is no different from playing Sudoko. Or playing Bridge. I wanted to become a pro bridge player. But Oracle is better.

Bought selftestsoftware for OCA developer 1zo 147

Look got all correct first try in section 1 :)

First plsql troubleshooting

Fun!

My first oracle table desc, first plsql commands error troubleshoot, first use of edit command. 

First oracle troubleshooting

Complete first reading of PLSQL program units exam guide.

Run script from Rampant press, first time I ran a Oracle script actually, actually first time also I operate Oracle formally,  Immediately there was an error from my Oracle XE, saying there is TNS connection problem, but after reading Sybex OCA Oracle study guide, I know there is something fishy with pubs/pubs@mydb. I change it to pusbs/pubs. And my first Oracle troubleshoot works for the first time!

Oracle PL SQL Program Units Exam Guide by Steve Ohearn

The best book on Oracle I have read. Super clear and lucid explanation left no stone unturned. Let you understand PLSQL deeply.

But probably not suitable as a beginner book. You should read some beginners books first to get the vague but important concepts like putting on a outline of the sculpture. And then finally read this book will sharpen the outlines deeply and all the concept together and the everything clear and lucid, I call this kind of book the finalizer.

Read like this order to understand Oracle deeply or pass an OCA exam:

Head first SQL
Rampant Press Easy Oracle PL SQL Programming
Sams Teach yourself PLSQL in 21 days.
Oracle PL SQL Program Units Exam Guide (The finalizer)
Selftestsoftware

Oracle 11g for dummies
OCA Oracle 10g administration I study guide (The finalizer)
Selftestsoftware

Oracle SQL Tuning by Dan Tow

Oracle SQL: Jumpstart with Examples by Gavin JT Powell (F,L)
Oracle Performance Tuning for 10gR2 by Gavin JT Powell (F,L)
The art and science of Oracle Performance tuning (L)

Oracle SQL high performance tuning by Guy Harrison (W)  (The finalizer)

God wrote me!!!! T0T

http://oracle-bubul.blogspot.com/2009/10/buying-pc-now-to-practice-pl-sql-at.html 

OCP Developer PL/SQL Program Units Exam Guide by Steve Ohearn

Finally book released back to Jurong Regional library. One of the best book i read. Clear and lucid prose. Orderly step by step presentation.

Probably this year I can pass the OCA developer exam. 

Buying a PC now to practice PL SQL at home

My laptop has labview cannot install big oracle. Thus buy a second hand PC.

Almost finishing reading SAMS teach yourself PLSQL in 21 days. Now I can finger around with PLSQL and get familiar with it. My reservation of PLSQL program unit study guide is still not available yet from singapore library, somebody is loaning the book.

I may again borrow Steven Ferguson PL SQL again and see what is the fuss about :)