Oracle Database 11g SQL (Oracle Press) and over one million other books are available for Amazon Kindle. Learn more

Oracle Database 11g SQL (Oracle Press) 1st Edition

23 customer reviews
ISBN-13: 978-0071498500
ISBN-10: 0071498508
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $6.78
Learn More
Trade in now
Have one to sell? Sell on Amazon
Buy used
$27.45
Buy new
$29.67
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, November 5, 2007
"Please retry"
$29.67
$23.99 $13.82
More Buying Choices
31 New from $23.99 27 Used from $13.82

There is a newer edition of this item:

Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


InterDesign Brand Store Awareness Rent Textbooks
$29.67 FREE Shipping on orders over $35. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

Oracle Database 11g SQL (Oracle Press) + Oracle Database 11g PL/SQL Programming (Oracle Press) + Oracle Database 11g PL/SQL Programming Workbook (Oracle Press)
Price for all three: $101.66

Buy the selected items together

Editorial Reviews

About the Author

Jason Price is a freelance consultant and former product manager at Oracle Corporation. He has contributed to many of Oracle's products and is an Oracle Certified Database Administrator and Application Developer.

NO_CONTENT_IN_FEATURE


Best Books of the Month
Best Books of the Month
Want to know our Editors' picks for the best books of the month? Browse Best Books of the Month, featuring our favorite new books in more than a dozen categories.

Product Details

  • Series: Oracle Press
  • Paperback: 688 pages
  • Publisher: McGraw-Hill Education; 1 edition (November 26, 2007)
  • Language: English
  • ISBN-10: 0071498508
  • ISBN-13: 978-0071498500
  • Product Dimensions: 7.1 x 1.4 x 9.5 inches
  • Shipping Weight: 2.6 pounds (View shipping rates and policies)
  • Average Customer Review: 3.8 out of 5 stars  See all reviews (23 customer reviews)
  • Amazon Best Sellers Rank: #267,381 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

25 of 26 people found the following review helpful By Robert A. Mara on June 28, 2009
Format: Paperback Verified Purchase
This book is good for beginner and intermediate users. When I bought the book last year, I was intermediate SQL and beginner Oracle. On my previous database projects, I used SQL Server and Sybase and used GUIs to create my tables and relationships. My current project requires PL/SQL scripts that can be run in batch. Since I had done a lot of DML (Data Manipulation Language, e.g., SELECT), little DDL (Data Definition Language, e.g., CREATE TABLE), and virtually no Oracle, I needed help! This book rescued me.

This is now my main reference for SQL, and especially Oracle-specific SQL. It has many examples of SQL for specific basic tasks. Not system administration tasks, mind you, but DML and DDL. These examples are the biggest strength. Oracle's syntax flowcharts and O'Reilly's "SQL In A Nutshell" are fine, but I need examples. "Show me".

One last note: the book is a SQL book, not a PL/SQL book. If you need to do PL/SQL you will need another PL/SQL-specific book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
13 of 14 people found the following review helpful By Honest guy on January 16, 2009
Format: Paperback Verified Purchase
It's a great reference book. it has nice examples for a beginner. would highly recommend for beginner/intermediate users.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
13 of 15 people found the following review helpful By Oracle geek on October 8, 2008
Format: Paperback
I'm an experienced Oracle developer and I use this book all the time. I have several books on SQL, and this book is by far the best. It has good examples. I highly recommend it.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 9 people found the following review helpful By faraumont on February 4, 2011
Format: Paperback Verified Purchase
This is a great book to learn SQL. I used it to help study to the Oracle 10g SQL Expert certification test. Since it goes deeper in many subjects than the oficial Oracle University books, it was certainly a great aid to help pass the exam.

If you wish to gain a solid SQL knowledge starting from zero, this book is all you need.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
6 of 7 people found the following review helpful By MR on May 12, 2012
Format: Kindle Edition Verified Purchase
This book covers many details not only regarding SQL and PL/SQL, but also on connecting to a server. I've done college coursework on databases and had to struggle through learning to use the environment (SQLPlus). This book wouldn't have changed my grades, but even the first chapter would have made the classes easier (answers questions even the experienced instructor didn't know ^_^). Anyone taking database coursework at UMUC should purchase this as well. ;)

By the way, if you're buying the Kindle version, there is a CDRom that came with the book version which is not delivered through the Kindle digital download. You can find that material here:

[...]

I'm deducting one star because it would have been very simple for someone to put that link in, or find SOME way to offer the information on the CD rather than making us hunt for it. The book isn't completely useless without the CD - but it is greatly crippled.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Christopher Newton on April 8, 2014
Format: Paperback Verified Purchase
I bought this book blindly, going off others reviews. When I got it and started to run the practice examples, I found that many of them don't work as the author didn't take into account the relational database model when creating his examples. For example, at the very beginning where he talks about deleting a row from the database, having followed the book line for line up to that point, the example he gives throws an integrity constraint as the customer he is attempting to remove has purchases in the purchases table. I had two other people verify that they get the same results when trying to run this example.

The DBA at the company I work for also told me that I wasted my money and that I should not use this book to learn from. I should return the book if i still can.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 3 people found the following review helpful By Harviy E. Lopez on March 2, 2014
Format: Paperback Verified Purchase
Great book. Really gives examples or every query. Worth gold. If you want to learn about SQL this is the book.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
An experienced hand is probably going to find this book a little sparse, but such a person really doesn't need this book, they should be using any of the excellent Oracle manuals that can be had for free just by asking.

For the new student or the old student reacquainting themselves with Oracle SQL after a few years away from it, the pace is about right and the info load perfect for the careful reader.

I see people complaining that the text is not clear and not easily understood but I have to question that judgement. Perhaps a little less multi-tasking during the book sessions would help (I speak as an easily distracted student myself). I don't know. All I can say is that the text is not dense, the explanations are adequate especially when used as examples for self-study at the computer (i.e. vamping on the theme for a few minutes in the example database that can be downloaded from the address printed on the book cover) and the pacing seems good - if you are a really bright student you can always speed read the bits you "get" but I'd be careful when deciding to do that. There is a large amount of information to be found there and sometimes your assumptions may hide a nifty feature Oracle built in.

That said, the book is missing one important piece of information necessary if the student is using a database with schemas other than the test one supplied in the download - the "ALTER SESSION SET CURRENT_SCHEMA = store;" command, which will be needed to get the syntax in the book to work seamlessly. There's also a referential integrity issue that can get in the way of testing the earliest example DELETE command, but that might usefully be seen as a debugging lab after reading on a little.

Will the reader benefit from other sources? Of course.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Oracle Database 11g SQL (Oracle Press)
This item: Oracle Database 11g SQL (Oracle Press)
Price: $29.67
Ships from and sold by Amazon.com

Want to discover more products? Check out these pages to see more: best oracle 11g sql pl sql books, best oracle text books