OCE Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)

by Steve O'Hearn

Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all objectives for exam 1Z0-047, On the For a complete list of Oracle Press titles, visit www.OraclePressBooks.com

796 pages, Paperback

First published March 31, 2009

Reviews

[Ellen Zain · Rating 5 out of 5]

This book was highly recommended to me by a friend who has been working in the software business for about 20 years. The book is not intended to teach you everything about SQL, it is intended to prepare you for the exam. However, it teaches a great deal, I learned a lot and filled in many gaps in my technical knowledge I did not even know I had. For example, I never used regular expressions before, I had heard of them but assumed they were something else. I never used MERGE before. The section that described "NULL" was outstanding, I don't think I ever really understood NULL and how it works until I read that.

The chapters of the book line up with the objectives of the exam. Every objective is covered in detail. The book is rich with code examples, so it does not just describe concepts or provide syntax, it shows you real world examples.

I studied this book and worked through the practice exams and exercises, before taking the test, and I passed. The text is a tough test, but without this book I don't think I would have passed.

Recommended!

[John Chilton · Rating 1 out of 5]

This book is terrible. This book is poorly written, confusing, and perhaps worst of all entirely ambiguous at times. A certification exam guide needs to be filled with concrete statements "This won't be on the exam...", "This may be on the exam...", "The exact syntax is as follows...", etc.... This book is entirely wishy washy. I would say don't buy it, but unfortunately what other book covers the material? Oh well.

[Will · Rating 3 out of 5]

Very readable compared to other computer books. The end of chapter quizzes are very good, and the attached CD with downloadable practice exam is great. If you don't read this book, there's probably zero chance that you'll pass the Oracle cert exam.

[Citlali · Rating 3 out of 5]

This book has a lot of errors in its text even found one error in the master exam that comes with it.

[Hugh Griffiths]

If you only read one book about Oracle's SQL Expert (1Z0-047) certification this year, make it this one.