The swallow a mountain method
1. Break big task into smaller ones.
2. Reward yourself frequently.
3. Studying Oracle is no harder than studying abc. Just expose yourself daily to it.
4. Practice, practice, practice - A great samurai
5. Do things one step at a time
6. Detachment.
7. Believe the task is easy. This will banish your resistance.
Best Oracle books
1. Oracle 10g Database Administration Concepts & Implementation Made Simple by Asim Abbasi
2. OCA: Oracle 10g Administration by Chip Dawes, Bob Bryla
3. Expert Oracle Database Architecture by Thomas Kyte
4. Selftestsoftware
5. Head First SQL by Lynn Beighley
6. Oracle Performance Tunning 101 by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande
http://oracle-bubul.blogspot.com/2009/05/best-oracle-books-reloaded.html
How to study books
1. Find good books : Googel search "Oracle" best book. Read reviews in Amazon. Get books in Singapore library. Get free books on internet google "book title" free book.
2. Quick scan : Quick scan each chapter to get a overall idea.
3. Organic read : Only read the parts that interest you. Gain understanding first.
4. Detail reading: Gain understanding.
5. Notes taking: This step is very important for memorization and detail reading. Use hand writing or copy paste from ebook. Write down your questions on the notes to refer back later.
6. Memorize: Read the notes and memorize. There is no understanding without memory.
Sunday, May 31, 2009
After I got my OCA, blitzkrieg on PLSQL and linux scripting
Maybe two weeks can finish blitzkrieg with a laptop. And post my cv up in monster. Then meantime try to get OCA developer.
This two books will help:
This two books will help:
Friday, May 29, 2009
Bubul motivational poster
Paste it on my table:
IZO - 042 JULY 27
"If you don't work, what would you do?"
"If he can do it, why can't you do it? He is only a guy"
-Chong Kok Weng, ]
Francis most hated colleague
IZO - 042 JULY 27
"If you don't work, what would you do?"
"If he can do it, why can't you do it? He is only a guy"
-Chong Kok Weng, ]
Francis most hated colleague
Oracle PL/sql for dummies
Another pretty good pl/sql book. I bought the book and upload to freedrive.com for my sonsOracle PL/SQL programming
http://www.amazon.com/Oracle-PL-SQL-Programming-Third/dp/0596003811
"Each chapter has been crafted to address these three objectives. His writing style is clear, succinct, and reads like he is sitting next to you chatting about the new things he's learned. The book is absolutely full of code examples. Most of the examples are posed as practical programming problems. He carefully walks you through the lines of example code, clearly explaining the logic used for each step of the program, and points out version-based differences. Steve is also not afraid to express an opinion and will tell you exactly why he chooses a particular method for solving a problem. Notes explaining tips and traps proliferate the book."
"Each chapter has been crafted to address these three objectives. His writing style is clear, succinct, and reads like he is sitting next to you chatting about the new things he's learned. The book is absolutely full of code examples. Most of the examples are posed as practical programming problems. He carefully walks you through the lines of example code, clearly explaining the logic used for each step of the program, and points out version-based differences. Steve is also not afraid to express an opinion and will tell you exactly why he chooses a particular method for solving a problem. Notes explaining tips and traps proliferate the book."
How is like being with Oracle
First it's like entering into a desert, there is constant thirst.
Then after you got used to the thirst, you look up and see the clear blue skies with stars shining in beautiful configuration.
Then after you got used to the thirst, you look up and see the clear blue skies with stars shining in beautiful configuration.
Thursday, May 28, 2009
Wrox Proffesional Oracle Programming
http://www.amazon.com/Professional-Oracle-Programming-Programmer/dp/0764574825
Got the book yesterday from Bukit Batok library.
Looks like a nice book to fill in the gaps left behind by Sybex OCA study guide. Nice fast overview of how and why Oracle works which Sybex left behind, and hard to find in Thomas Kyte Oracle Architecture.
Learning is about linking meanings together like building a spider web to the leaves, branches, woman's hair.
Got the book yesterday from Bukit Batok library.
Looks like a nice book to fill in the gaps left behind by Sybex OCA study guide. Nice fast overview of how and why Oracle works which Sybex left behind, and hard to find in Thomas Kyte Oracle Architecture.
Learning is about linking meanings together like building a spider web to the leaves, branches, woman's hair.
Tuesday, May 26, 2009
Monday, May 25, 2009
I am going to write a cool PL SQL object after OCA
Yeah, read that a lot of DBA works as a programmer first. So I will write a cool PL SQL program first maybe a trigger or soemthing :P as a demo or white paper.
Beginning PL SQL book looks like a good book
Beginning PL/SQL: From Novice to Professional (Beginning from Novice to Professional) (Paperback)
by Donald Baleshttp://www.amazon.com/Beginning-PL-SQL-Novice-Professional/dp/1590598822/ref=pd_sim_b_8
Wednesday, May 20, 2009
OCA Exam study progress
Just bought a canon 3in1 printer. Print out Sybex chapter 1-3 to read on the bus. Muahaha
Saturday, May 16, 2009
Oca exam study progress
I am completing the notes taking of sybex oca chapters 1-3, 6-8.
Then print out the notes. And start memorizing half of the oca requirements.
networking, performance monitoring, backup and recovery, moving is the second half.
oca exam here i come!
Then print out the notes. And start memorizing half of the oca requirements.
networking, performance monitoring, backup and recovery, moving is the second half.
oca exam here i come!
Thursday, May 14, 2009
The newer best tuning book!
So i could not find the Oracle Performance Tuning 101 book in SIngapore library because it is missing. But i track the authors in Amazon and realize they have written a new book!
| ||||
| | ||||
|
| |
Wednesday, May 13, 2009
The best Oracle tuning book: Found!
| ||||
|
1 of 3 people found the following review helpful:
Novel on Oracle Performance Tuning, | By | Samir Rajpurkar. (India) - See all my reviews |
chapter in "Oracle Performance Tuning 101". My immediate feedback on this
book is that, its a great book, just like a novel, very few technical
books that you can read and catch your 100% attention on a flight, I
enjoyed reading it !
| Help other customers find the |
Tuesday, May 12, 2009
Taking notes when studying books are much faster
I realize if i take notes when studying Oracle it is much faster to absorb.
I have read Sybex OCA study guide a couple of times but still missed out a lot of details. Only now that i start copy pasting notes from the pdf to words, that i start remembering the details.
Probably it is like digging for diamond in a pile of ash, putting the diamonds into a box can help to refer them later much faster, like indexing, instead of looking back into the ash again.
I have read Sybex OCA study guide a couple of times but still missed out a lot of details. Only now that i start copy pasting notes from the pdf to words, that i start remembering the details.
Probably it is like digging for diamond in a pile of ash, putting the diamonds into a box can help to refer them later much faster, like indexing, instead of looking back into the ash again.
Sunday, May 10, 2009
Note taking when studying a book is very important
After i
scan the book
understand the material
read other books to get more understanding
study selftestsoftware to know where to focus
now notetaking from Sybex OCA book is very important to help me remember and look in the details.
I copy paste the sybex book in pdf to a word doc. Now i am at chapter 3.
scan the book
understand the material
read other books to get more understanding
study selftestsoftware to know where to focus
now notetaking from Sybex OCA book is very important to help me remember and look in the details.
I copy paste the sybex book in pdf to a word doc. Now i am at chapter 3.
If you dont work what will you do?
A colleugue of mine in Tawau gave me two important sentence:
If you dont work what will you do?
If he can do it, why cant you do it?
If you dont work what will you do?
If he can do it, why cant you do it?
I study Oracle in small chunks
I stand on bus and study a bit, use coffee time and study a bit.
I think in my busy life, this is more efficient than study Oracle in one go hiding in a hotel. This is the guerrilla method.
I think in my busy life, this is more efficient than study Oracle in one go hiding in a hotel. This is the guerrilla method.
Oracle is like a forest
All things are fractals in this universe. Oracle is like a forest, a natural evolution, all man made things are parts of evolution.
Oracle is like patterns in go board game. A slowflake crystal.
Oracle is like patterns in go board game. A slowflake crystal.
Friday, May 1, 2009
Why Oracle is so good
I have played with a lot of toys: quantum physics, computational fluid mechanics, game programming, hacking, poetry, philosophy, psychology, chess, bridge, go, poker, xbox, mathematics, women, painting, computer graphics, and karate.
Actually deep inside all this toys, they are actually exhibiting a similar pattern, they are the same with each other. This is the fractal pattern emerging inside this chaotic holographic universe.
But Oracle is still the best because:
1. You can hack in your room only with a laptop and a few books. With other engineering for example electrical engineering, there is no way for you to hack because the equipment is expensive, critical, and you need clearance.
2. You can have more possibility of becoming a guru because of 1.
3. The study materials to become a guru are much more easier to access. There are more world class Oracle books in the bookshops than compared to theoretical physics with are only accessible in university.
4. You can quickly become a guru at a young age because of 3.
5. It is one of highest paid profession.
6. It is vast and big. A big ocean for you to explore.
7. It has the joy of tuning a car.
Actually deep inside all this toys, they are actually exhibiting a similar pattern, they are the same with each other. This is the fractal pattern emerging inside this chaotic holographic universe.
But Oracle is still the best because:
1. You can hack in your room only with a laptop and a few books. With other engineering for example electrical engineering, there is no way for you to hack because the equipment is expensive, critical, and you need clearance.
2. You can have more possibility of becoming a guru because of 1.
3. The study materials to become a guru are much more easier to access. There are more world class Oracle books in the bookshops than compared to theoretical physics with are only accessible in university.
4. You can quickly become a guru at a young age because of 3.
5. It is one of highest paid profession.
6. It is vast and big. A big ocean for you to explore.
7. It has the joy of tuning a car.
Best Oracle Books Reloaded
Sean Ryan all this books i have uploaded to Freedrive.com for you to study. Ask your mom and aunt for login and password, or read my email treasure chest to you, or read the books in my portable harddisk.
July 28, 2009
Programming is a spiritual practice like pottery or flute. Oracle is a living thing.
Best Oracle books
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
Subscribe to:
Comments (Atom)
