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.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your e-mail address or mobile phone number.

Kindle Price: £41.79

Save £2.20 (5%)

includes VAT*
* Unlike print books, digital books are subject to VAT.

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

Deliver to your Kindle or other device

Deliver to your Kindle or other device

Flip to back Flip to front
Audible Narration Playing... Paused   You are listening to a sample of the Audible narration for this Kindle book.
Learn more

Oracle SQL by Example (Prentice Hall Professional Oracle Series) Kindle Edition

3.7 out of 5 stars 3 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"

Length: 960 pages Enhanced Typesetting: Enabled Optimised for larger screens
  • Due to its large file size, this book may take longer to download

Lonely Planet is now in Kindle Unlimited
Unlimited exploring. Unlimited reading. Browse hundreds of Lonely Planet eBooks now in Kindle Unlimited. Learn more
Get a £1 credit for movies or TV
Enjoy £1.00 credit to spend on movies or TV on Amazon Video when you purchase any Amazon Kindle ebook from the Kindle Store (excluding Kindle Unlimited, Periodicals and free Kindle ebooks) offered by Amazon.co.uk. A maximum of 1 credit per customer applies. UK customers only. Offer ends at on Friday, 26 February, 2016. Terms and conditions apply

Product Description

From the Back Cover

“The book...has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book

many times over.”

–Dr. Paul Dorsey, President, Dulcian, Inc., Oracle Magazine PL/SQL Developer of the Year 2007, and President

Emeritus, New York Oracle Users Group 


“This is a fascinating guide into the world of Oracle SQL with an abundance of well-collected examples. Without a doubt, this

book is helpful to beginners and experts alike who seek alternative ways to resolve advanced scenarios.”–Oleg Voskoboynikov, Ph.D., Database Architect


The World’s #1 Hands-On Oracle SQL Workbook–Fully Updated for Oracle 11g


Crafted for hands-on learning and tested in classrooms worldwide, this book illuminates in-depth every Oracle SQL technique you’ll need. From the simplest query fundamentals to regular expressions and with newly added coverage of Oracle’s powerful new SQL Developer tool, you will focus on the tasks that matter most. Hundreds of step-by-step, guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL. Along the way, you’ll acquire a powerful arsenal of useful skills–and an extraordinary library of solutions for your real-world challenges with Oracle SQL.


Coverage includes


  • 100% focused on Oracle SQL for Oracle 11g, today’s #1 database platform–not “generic” SQL!
  • Master all core SQL techniques including every type of join such as equijoins, self joins, and outer joins
  • Understand Oracle functions in depth, especially character, number, date, timestamp, interval, conversion, aggregate, regular expressions, analytical, and more
  • Practice all types of subqueries, such as correlated and scalar subqueries, and learn about set operators and hierarchical queries
  • Build effective queries and learn fundamental Oracle SQL Developer and SQL*Plus skills
  • Make the most of the Data Dictionary and create tables, views, indexes, and sequences
  • Secure databases using Oracle privileges, roles, and synonyms
  • Explore Oracle 11g’s advanced data warehousing features
  • Learn many practical tips about performance optimization, security, and architectural solutions
  • Avoid common pitfalls and understand and solve common mistakes
  • For every database developer, administrator, designer, or architect, regardless of experience!

About the Author

Alice Rischert, formerly chair of Columbia University’s Database Application Development and Design program, has taught classes in Oracle SQL, PL/SQL, and database design to hundreds of students. Ms. Rischert’s wide-ranging technology experience encompasses systems integration, database architecture, and project management for a number of companies in the United States, Europe, and Asia. Ms. Rischert has presented on SQL and PL/SQL topics at Oracle conferences and has worked with Oracle since version 5.

Product details

  • Format: Kindle Edition
  • File Size: 44245 KB
  • Print Length: 960 pages
  • Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits
  • Publisher: Prentice Hall; 4 edition (12 Aug. 2009)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B002MK0W4A
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Enabled
  • Average Customer Review: 3.7 out of 5 stars 3 customer reviews
  • Amazon Bestsellers Rank: #748,482 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images or tell us about a lower price?

Customer Reviews

3.7 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 3 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
I bought this book about a month ago and so far I'm very pleased with the whole content and idea behind the book. You are supplied with a script from the corresponding website which allows you to create the tables that enable you to run the examples and exercises on SQL *Plus or SQL Developer. The topics and concepts are very well explained and not too technical. Very useful for a beginner. Quite an expensive book, but I thought it was value for money.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Kindle Edition Verified Purchase
If your an Mac user don't waste your time. The exercise files come in a .exe file so you cannot load them. Also even if you have bought software for mac that opens windows files like Crossover, when you copy the exercise files to Oracle some do not work. A complete waste of money for me
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Well-written and pretty comprehensive.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: HASH(0x8c69b3c0) out of 5 stars 36 reviews
8 of 8 people found the following review helpful
HASH(0x8c68f144) out of 5 stars Good reference book 23 Mar. 2013
By X. Liu - Published on Amazon.com
Format: Paperback Verified Purchase
I registed a SQL class at my local community college. The textbook recommeded by the college was over $200 and had a one and half star review. I decided to use this book for my SQL class. The teacher told me that without any IT background and without using the school's textbook I wouldn't be able to make it through the class. I not only made it through, but also got 4.0 for the class with skipping half of the classes. I relied on this book and self-study.
6 of 6 people found the following review helpful
HASH(0x8c693108) out of 5 stars Over the Top 24 July 2010
By Riccardo Audano - Published on Amazon.com
Format: Paperback Verified Purchase
I rarely find a techical book that has just everything I would want.. this one has it, and more. It's "hands on" and example based, but the theory is clearly and orderly introduced. Presentation style is neither boring nor distracting. The author's tech skill are awe inspiring but she still manages to write excellent material for beginners. She really cares to teach, not to show off her skills and knowledge...
So if you really want to learn SQL, want to do it with no pain, lots and lots of practical examples and *solved exercises*, and also get some practice with on of the most used database platforms available.. well this is the book you want. Do yourself a favour and start here.
You might want to check out also:
Beginning Oracle SQL
especially if you would like to read something a little more "compact" and "theory oriented" that still has solved exercises.. but I really think that when it comes to learning SQL nothing is more valuable than lots and lots of practice and examples..my advice is read them both, you won't regret it.
The only reproach I can make to to author is that she still has not written an intermediate level text as a follow up of this awesome text!
8 of 9 people found the following review helpful
HASH(0x8c670858) out of 5 stars Excellent Book to Learn Oracle SQL 22 July 2010
By Michael D. Valverde - Published on Amazon.com
Format: Paperback
This is a great book to pick up and start learning Oracle SQL. I am an Adjunct Profressor and this it the book I use in my Intro to Oracle Programming. What has made this book such a success for me is the pace of the book. It is task oriented which is great for self-paced or classroom learning. She covers the topics in the right order to continue building on previous topics. It is a great book to start you off and you will find it very valuable resource.

Also, the "Student" database provided via the books website is really usefull. Students immediately understand the data model because Courses, Sections, Enrollment, Grades, etc makes since to them. If you want to learn Oracle SQL this is the best place to start! I can't say enough about how great it is!
3 of 3 people found the following review helpful
HASH(0x8cc83a20) out of 5 stars Good newbie book 11 Sept. 2012
By Patti Leonard - Published on Amazon.com
Format: Paperback
I am new to databases and needed a book that would serve as an introduction. The installation of the database is frustrating and tricky so I recommend that , if you have a friend familiar with this type of thing, you have them install it for you. If you don't, just be patient and read carefully and you will eventually get it.

I find this book to be an excellent book for the beginner. It is well laid out and easy to understand. I was looking at several before I made up my mind to purchase this one, and I'm glad I did.
3 of 3 people found the following review helpful
HASH(0x8cfa88b8) out of 5 stars Very Good Book for Oracle SQL 15 Oct. 2010
By Mr. Steven J. Reed - Published on Amazon.com
Format: Paperback Verified Purchase
This book is nicely laid out and easy to follow. There are lots of examples of syntax and many of the common functions are discussed. There is also a good amount of information about SQL Developer and SQL+. It is valuable to know about those tools when using SQL with Oracle. This book has kept my interest and I have learned some new tricks. There are lots of quizzes and plenty of information that pertains to Oracle SQL exams.
Were these reviews helpful? Let us know

Customer Discussions