Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query—including new features from Oracle versions 9i, 10g, and 11g—this guide will help information technology managers and programmers alike to gain new insight into complex queries, advanced aggregation, and analytics techniques. Introducing Model and XML as new ways to retrieve data out of the database, this sourcebook culminates as a perfect companion for advanced programmers and Oracle experts.
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details. Learn more. |
Book Description
Product details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, and more.
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
Customer Reviews
Most Helpful Customer Reviews
Format:Paperback
Usually we write simple equijoin queries. And for example I forgot that SQL language is very powerful, and new with new Oracle versions - SQL language has new features. ;)
This is the book that shows and teaches how to use the power of SQL language. I'm 3 years young Oracle Developer, and this book is very useful for me.
This is the book that shows and teaches how to use the power of SQL language. I'm 3 years young Oracle Developer, and this book is very useful for me.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
2.8 out of 5 stars
5 reviews
10 of 10 people found the following review helpful
3.0 out of 5 stars
Decent book on advanced SQL but much to be desired
22 Feb 2009
By Harsha N. Hegde
- Published on Amazon.com
Format:Paperback
I am an ardent reader of Laurent Schneider's blog: http://laurentschneider.com/. His deep understanding of databases is unparalleled. The tips he provides are very practical and handy. That's probably what raised my expectations from his book: "Advanced Oracle SQL Programming". I have just finished reading through this book and I can clearly say that I am a bit disappointed with the book.
- It feels more like a collection of Laurent's notes on various Oracle SQL topics.
- There is a disconnect between one topic and the next one.
- Topics are very brief, often not exceeding 3-4 sentences. Much more detailed discussion/analysis of each concept would have made the book more readable.
- More tips/tricks (like the ones in boxes with an explosive symbol) would have made me go back to this book often.
- This may sound trivial, but the formatting of the code unnecessarily takes up too much space. e.g, in the first chapter itself, all the "INSERT" statements run to 8 pages! They could have easily been arranged 2 columns/page. They are not even required because it is available for download anyway at the book's website.
Nice things I found in the book:
- Exercise problems are really good, will make you think.
- Explanation on Joins, Subquery and Hierarchical queries are so far the best I have read.
- It feels more like a collection of Laurent's notes on various Oracle SQL topics.
- There is a disconnect between one topic and the next one.
- Topics are very brief, often not exceeding 3-4 sentences. Much more detailed discussion/analysis of each concept would have made the book more readable.
- More tips/tricks (like the ones in boxes with an explosive symbol) would have made me go back to this book often.
- This may sound trivial, but the formatting of the code unnecessarily takes up too much space. e.g, in the first chapter itself, all the "INSERT" statements run to 8 pages! They could have easily been arranged 2 columns/page. They are not even required because it is available for download anyway at the book's website.
Nice things I found in the book:
- Exercise problems are really good, will make you think.
- Explanation on Joins, Subquery and Hierarchical queries are so far the best I have read.
5 of 6 people found the following review helpful
3.0 out of 5 stars
Advanced Oracal SQL
13 Nov 2009
By Richard John
- Published on Amazon.com
Format:Paperback|Amazon Verified Purchase
I found most of the book to be a rehash of other material Oracle published. Most of the SQL I would not consider advanced. I felt if a intermediate at best. I bought this book about 6 months ago and after reading I have only used it once or twice as reference. There is some stuff in one of the middle chapters, but overall I was disappointed.
3 of 4 people found the following review helpful
1.0 out of 5 stars
Poorly written, and confusing
12 April 2010
By Joshua E. Emery
- Published on Amazon.com
Format:Paperback
Probably the worst Technical book I have ever read. It is poorly formatted, and some paragraphs just do not make sense. Examples are weak, and not explained leaving you to toil over it to figure what the writter is trying to accomplish. I highly recommend avoiding this book. Do not make the costly mistake I did.
›
Go to Amazon.com to see all 5 reviews
2.8 out of 5 stars
Were these reviews helpful?
Let us know
Listmania!
|
|
Look for similar items by category
- Books > Business, Finance & Law > Management > Management Skills > Communication & Presentation > Writing Guides
- Books > Computing & Internet > Databases > Applications > SQL
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Design & Theory
- Books > Computing & Internet > Databases > Oracle > PL & SQL
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.
|
