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.