- Series: Oracle Press
- Paperback: 796 pages
- Publisher: McGraw-Hill Education; 1 edition (December 23, 2009)
- Language: English
- ISBN-10: 0071614214
- ISBN-13: 978-0071614214
- Product Dimensions: 7.5 x 1.7 x 9.2 inches
- Shipping Weight: 3 pounds (View shipping rates and policies)
- Average Customer Review: 48 customer reviews
- Amazon Best Sellers Rank: #782,796 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
OCE Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) (Oracle Press) 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you increase your sales. We invite you to learn more about Fulfillment by Amazon .
There is a newer edition of this item:
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
About the Author
Steve O'Hearn has been an Oracle Certified Application Developer since 1999. He has designed databases for 23 years for clients such as the U.S. Army, U.S. Navy, the FAA, the World Bank, NASA, and others. He has served as a Chief Technology Officer, a consultant, and Instructor, and is the author of several computer books, including the "Oracle OCP Developer PL/SQL Program Units Exam Guide," from Oracle Press.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
The books assumes a little knowledge of SQL but I think it is a great guide for both beginners, and experts alike. It is well organized and has a great index. You can read it from beginning to end and it makes logical sense, or you can simply use it as a reference to look up the portions you are interested in. Because the book is geared towards passing the exam and not simply to provide more general SQL knowledge, you won't find any examples that you work on, alongside the book, as you read. Some people might find it hard to learn that way, but for me it was great. I didn't need to have a computer in front of me to try out the code to understand what it meant. This also allowed the book to focus on some of the more subtle and conceptual aspects of the SQL language and how Oracle has implemented it. I think that is key to having passed the exam. Because the book teaches the concepts behind the SQL language, instead of just giving syntax examples, it helps you correctly answer questions that might not directly relate to examples given in the book. For example, the book has a great section on the meaning of "NULL" which is used in a lot of "trick" questions. It might not give you all possible examples of where "NULL" can be used in a question, but it does give you a good understanding of what "NULL" means in the SQL context and therefore how to answer questions that could be affected by "NULL" in their code.
My biggest gripe with the book is the fact that it only came with 70 test questions on the CD, and that the CD is Windows only. 70 questions is the equivalent to 1 practice exam. You can download an additional 70 questions from the web after registering with the publisher, but even doing that only gives you 2 practice exams worth of material. It doesn't take long to memorize all the correct answers for 140 questions. I would have preferred the book if it came with at least twice as many questions. I also think its kind of ridiculous that the CD itself is not cross platform. Such practice exams could have been developed in a way which would have allowed me to run it under Mac OS X or Linux. Instead I had to run Windows under virtualization just to take the practice exam.
Not to nitpick but this book has at least one error in it. I will add others as I find them. On page 217, the author states that the RPAD function pads a character string with x number occurrences of a string. In reality, RPAD pads the character string until the string length reaches x number of characters. For example, (using his example):
SELECT RPAD('Chapter One - I Am Born',40,'.') FROM DUAL will result in a character string of Chapter One - I Am Born................. which is what he shows in the book. However, in the text, he states that the SQL will "Take a string literal 'Chapter One - I Am Born' and pad it to the right with 40 occurrences of a single period." Anyone following the text would likely miss any exam question based on his explanation.
I did not see an errata link on the Oracle Press web page for this book.
That one is a small guide (150 pages). Steve O'Hearn's books is 700+ pages. Though I have 17yrs of experience, I knew my SQL knowledge was intermediate but after going through this guide, saying it was intermediate was barely enough. I now TRULY feel that after reading this book and Morris' guide that I feel way more comfortable in saying "expert", but "expert" truly comes with real-world experience. But the guide will help. The end of chapter quizzes and also the accompanying practice exam CD definitely helps.
My advice is do NOT take the practice exams on the CD until you are VERY close to feeling comfortable in taking the real-world exam. And when you do take the exam take them as close as possible to the real exam. Whatever settings there are make sure they mimic the real world.
I studied from mid-April to mid-July, so a total of 3 months and this helped me PASS the exam. It is 120 minutes long (2 hours) and 70 questions total and you must get a minimum percentage right to pass. 66% is passing. Not 66 questions! As that would be a minimum of 94% passing. At that rate, very few people would pass. I got a 78% (55 out of 70). I used up EVERY second. I had 45 seconds left to spare to go over any questions I had marked but alas had little time.
Study long and slowly and take your time, as there's no rush to take the exam. They're offered daily. And good luck.