-
Seasonal Offer:
This title is part of our Seasonal Offers promotion.
 Trade In this Item for up to £11.85
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Oracle Database 11g The Complete Reference (Oracle Press) for an Amazon.co.uk gift card of up to £11.85, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Special Offers and Product Promotions
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
The Definitive Guide to Oracle Database 11g
Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.
- Install Oracle Database 11g or upgrade from an earlier version
- Create database tables, sequences, indexes, views, and user accounts
- Construct SQL statements, procedures, queries, and subqueries
- Optimize security using virtual private databases and transparent data encryption
- Import and export data using SQL*Loader and Oracle Data Pump
- Use SQL replay, change management, and result caching
- Avoid human errors using flashback and automatic undo management
- Build and tune PL/SQL triggers, functions, and packages
- Develop database applications using Java, JDBC, and XML
- Optimize availability and scalability with Oracle Real Application Clusters
About the Author
Kevin Loney was named Consultant ofthe Year by ORACLE Magazine in 2002. He is an internationally recognized Oracle expert who frequently presents at Oracle user conferences in North America and Europe where he is regularly among the highest-rated presenters.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
Format:Hardcover
This book is an excellent go-to reference book for any developer who regularly works with the Oracle 11g database. It covers a huge range of issues at a fairly high level without presenting too much detail.
It's well laid out, easy to search and the examples are clear and concise. Most of the new 11g features are covered too, so you can get the most out of the database.
It's well laid out, easy to search and the examples are clear and concise. Most of the new 11g features are covered too, so you can get the most out of the database.
Format:Hardcover
Is what it is an updated book for 11g, follows the same style and form as those for 8, 9 and 10 the earlier versions. If you know/like those you'll find this useful.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
9 reviews
9 of 10 people found the following review helpful
Expensive Paperweight
24 Sep 2010
Format:Hardcover
If you have no internet access, this book is better than nothing, but otherwise stick with the free online books and docs provided by Oracle. Indeed, the last 1/3 or so of this book is just reference material copied directly from Oracle's free docs, but is more difficult to navigate without the hyperlinked crossreferences.
The book is not "complete" as the title suggests, not covering all new features (case-insensitivity using NLS_SORT, NLS_COMP is just one example).
Additionally, not all the information is accurate -- the author does not even know what the term "relational database" means, he thinks "relations" have something to do with foreign keys. A common misconception yes, but worrisome from a database "expert". I also found incorrect syntax in the transportable tablespace section, before I gave up with the book entirely.
Use at your own risk, and consider that the author has given his own book a 5 star rating on this site!
The book is not "complete" as the title suggests, not covering all new features (case-insensitivity using NLS_SORT, NLS_COMP is just one example).
Additionally, not all the information is accurate -- the author does not even know what the term "relational database" means, he thinks "relations" have something to do with foreign keys. A common misconception yes, but worrisome from a database "expert". I also found incorrect syntax in the transportable tablespace section, before I gave up with the book entirely.
Use at your own risk, and consider that the author has given his own book a 5 star rating on this site!
3 of 3 people found the following review helpful
Oracle complete reference
13 Nov 2009
Format:Hardcover|Amazon Verified Purchase
Generally the book is well written , but the approach is for very highly technical individuals. Since I am primary a SQL programmer, about half the book is not what I need. However, I use this book on PL/SQL more than I use the book "Oracle PL/SQL Programming". I found this book is better organized to check syntax on various functions. My DBA is usually checking the book for her job and she has found the book to be helpful for her needs. Overall I would recommend the book as a group reference.
2 of 3 people found the following review helpful
Great reference
17 Nov 2009
Format:Hardcover
I have been using this book or one of its earlier versions for six years. It does a great job of filling in the blanks for people like me who learned Oracle in the monkey-see monkey-do fashion of on the job training. It continues to be a great reference because it has a great index -- probably the best index in any technical book I own. I can find a term in the index very quickly and then flip to a focused explanation of that term. This usually much faster than flailing around the web doing word searches for the same information. It is an expensive book, but I have saved in frustration what I spent in dollars. It is very difficult to keep it on my desk because it is borrowed so often.
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
