July 28, 2009
Programming is a spiritual practice like pottery or flute. Oracle is a living thing.
Best Oracle books
A. Head first SQL by Head First SQL by Lynn Beighley
B. Oracle SQL high performance tunign by Guy Harrison
Easy Oracle SQL by John Garmany
1. Oracle SQL: Jumpstart with Examples by Gavin JT Powell
2. Oracle Performance Tuning for 10gR2 by Gavin JT Powell
3. Easy Oracle PL/SQL programming by John Garmany
4. Oracle 11g for dummies
Supporting books
1. Linux for dummies
2. C Programming Language by Brian W. Kernighan, Dennis M. Ritchie
3. Networking for dummies
4. Game programming books
July 23 2009 list
Start Oracle by studying the performance tuning first, it is the most fun.
Intro into Oracle:
1. Oracle 11g for dummies : study this master book first to give direction for other books.
2. Oracle 10g Database Administration Concepts & Implementation Made Simple by Asim Abbasi : Read this book if you have trouble.
3. Head First SQL by Lynn Beighley
Oracle tuning:
1. SQL tuning by Dan Tow : This is the master book that gives direction to study other books.
2. SQL performance tuning by Peter Gulutzan :This book explains index well, can use to support 1.
3. Oracle Performance Tunning 101 by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande : The other master book.
Oracle concept:
1. Expert Oracle Database Architecture by Thomas Kyte
2. Oralce concepts manual (online, search with google).
PLSQL:
1. Oracle online documentation (they are actually quite good)
Non Oracle supporting books:
1. Linux for dummies
2. C Programming Language by Brian W. Kernighan, Dennis M. Ritchie
OCA administration exam:
1. OCA:Oracle 10g Administration by Chip Dawes, Bob Bryla
2. Selftestsoftware
Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples (Paperback)by John Garmany
This book is probably much better than PLSQL for dummies or the online manual. I am getting a copy from Amazon. Sample can find in google books.
Easy Oracle SQL: Get Started Fast Writing SQL Reports with SQL*Plus (Paperback)by John Garmany
This book is probably better than head first SQL.
July 27, 2009
Two better SQL tuning books here:
http://oracle-bubul.blogspot.com/2009/07/two-better-sql-tuning-books.html
July 18 2009 list
1. Oracle 10g Database Administration Concepts & Implementation Made Simple by Asim Abbasi
2. Oracle 11g for dummies.
3. SQL tuning by Dan Tow
4. Oracle Performance Tunning 101 by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande
5. Head First SQL by Lynn Beighley
6. Expert Oracle Database Architecture by Thomas Kyte
7. OCA: Oracle 10g Administration by Chip Dawes, Bob Bryla
8. Selftestsoftware
9. Linux for dummies
10. Oracle online documentation (they are actually quite good)
11. C Programming Language by Brian W. Kernighan, Dennis M. Ritchie
Old list:
Oracle is actually quite a big subject. But if you know the main concepts the rest is easy. So this is the book to start. Oracle Database Administration Concepts & Implementation Made Simple by Asim Abbasi.
Then you study Sybex OCA to know which part you need to study first. Oracle is still quite big. You need to break it up into smaller pieces.
Selftestsoftware is essential also for you to pass the OCA exam, and narrow down the area you need to study. It has clear explanation.
But this is the best Oracle book. Clear, lucid, written in simple prose, makes the concepts of Oracle exiting. It is written by Oracle Oracle Thomas Kyte. Read all his books to become an Oracle guru, and enjoy life to the fullest.
Expert Oracle Database Architecture. by Thomas Kyte
Get started on SQL
Oracle Database 10g Admin 1 Exam Cram (1Z0-042)
Steve Cholerton
A nice 66 pages of short notes of important points needed for OCA exam. Read this to get the main ideas of Oracle quickly.
This book provides a fast overview of Oracle where sybex missed, or Kyte Oracle architecture is too long winded.
Other books
Because normally dba starts by becoming programmers first and know a bit of linux/unix scripting. The following books can be read quickly:
Very fast and easy intro into solid plsql
Get a know a bit about linux
know a bit about linux shell scripting
1. Oracle SQL: Jumpstart with Examples by Gavin JT Powell
2. Oracle Performance Tuning for 10gR2 by Gavin JT Powell
3. Easy Oracle PL/SQL programming by John Garmany
4. Oracle 11g for dummies
Supporting books
1. Linux for dummies
2. C Programming Language by Brian W. Kernighan, Dennis M. Ritchie
3. Networking for dummies
4. Game programming books
July 23 2009 list
Start Oracle by studying the performance tuning first, it is the most fun.
Intro into Oracle:
1. Oracle 11g for dummies : study this master book first to give direction for other books.
2. Oracle 10g Database Administration Concepts & Implementation Made Simple by Asim Abbasi : Read this book if you have trouble.
3. Head First SQL by Lynn Beighley
Oracle tuning:
1. SQL tuning by Dan Tow : This is the master book that gives direction to study other books.
2. SQL performance tuning by Peter Gulutzan :This book explains index well, can use to support 1.
3. Oracle Performance Tunning 101 by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande : The other master book.
Oracle concept:
1. Expert Oracle Database Architecture by Thomas Kyte
2. Oralce concepts manual (online, search with google).
PLSQL:
1. Oracle online documentation (they are actually quite good)
Non Oracle supporting books:
1. Linux for dummies
2. C Programming Language by Brian W. Kernighan, Dennis M. Ritchie
OCA administration exam:
1. OCA:Oracle 10g Administration by Chip Dawes, Bob Bryla
2. Selftestsoftware
Friday, July 24, 2009
Probably the best PLSQL and SQL book
Rampant press has produced a few probably best oracle books that explains concepts intuitively:Easy Oracle PL/SQL Programming: Get Started Fast with Working PL/SQL Code Examples (Paperback)by John Garmany
This book is probably much better than PLSQL for dummies or the online manual. I am getting a copy from Amazon. Sample can find in google books.Easy Oracle SQL: Get Started Fast Writing SQL Reports with SQL*Plus (Paperback)by John Garmany
This book is probably better than head first SQL.July 27, 2009
Two better SQL tuning books here:
http://oracle-bubul.blogspot.com/2009/07/two-better-sql-tuning-books.html
July 18 2009 list
1. Oracle 10g Database Administration Concepts & Implementation Made Simple by Asim Abbasi
2. Oracle 11g for dummies.
3. SQL tuning by Dan Tow
4. Oracle Performance Tunning 101 by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande
5. Head First SQL by Lynn Beighley
6. Expert Oracle Database Architecture by Thomas Kyte
7. OCA: Oracle 10g Administration by Chip Dawes, Bob Bryla
8. Selftestsoftware
9. Linux for dummies
10. Oracle online documentation (they are actually quite good)
11. C Programming Language by Brian W. Kernighan, Dennis M. Ritchie
Old list:
Oracle is actually quite a big subject. But if you know the main concepts the rest is easy. So this is the book to start. Oracle Database Administration Concepts & Implementation Made Simple by Asim Abbasi.
Then you study Sybex OCA to know which part you need to study first. Oracle is still quite big. You need to break it up into smaller pieces.
Selftestsoftware is essential also for you to pass the OCA exam, and narrow down the area you need to study. It has clear explanation.
But this is the best Oracle book. Clear, lucid, written in simple prose, makes the concepts of Oracle exiting. It is written by Oracle Oracle Thomas Kyte. Read all his books to become an Oracle guru, and enjoy life to the fullest.
Expert Oracle Database Architecture. by Thomas Kyte
Get started on SQLOracle Database 10g Admin 1 Exam Cram (1Z0-042)
Steve Cholerton
A nice 66 pages of short notes of important points needed for OCA exam. Read this to get the main ideas of Oracle quickly.
This book provides a fast overview of Oracle where sybex missed, or Kyte Oracle architecture is too long winded.Other books
Because normally dba starts by becoming programmers first and know a bit of linux/unix scripting. The following books can be read quickly:
Very fast and easy intro into solid plsql Get a know a bit about linux know a bit about linux shell scripting
No comments:
Post a Comment