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.
To get the free app, enter your email address or mobile phone number.
SQL Design Patterns: Expert Guide to SQL Programming (IT In-Focus series) (Volume 4) Paperback – April 1, 2007
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Customers Who Viewed This Item Also Viewed
About the Author
More About the Author
Top Customer Reviews
1) The author's english is a bit broken so in some places you will find yourself frustrated by having to read things twice or more to understand it.
2) The author has a great mathematics background, but again in a few places, this actually gets in the way as most of us do not have such a deep mathematics grounding and so won't understand what the math is trying to tell us. Knowing there is a sound mathematical set of principles behind things is nice but the details and symbols are often too deep for me.
3) For those of us who are actually ADVANCED developers, there may be little here in the way of new tips or tricks because you will already know and practice many of the techniques discussed.
INPSITE OF THESE DETRACTORS, I give the book five stars and suggest that anyone looking to go to the next level with their SQL skills should read it for a mind set, because it has the potential to actually change the way we work. Language issue aside, it clearly articulates the idea that it is possible to make a mental leap that will take you from average sql development to great sql development. I liken it to what my typing teacher in High School once told me: "when you stop thinking about the letters and start thinking about the words, your typing will improve dramatically with fewer errors and faster results". In the same way, this author shows us there is a mental leap to be made with sql. The number of lines of code does not matter. What matters is ideas.Read more ›
The author invented many techniques, the most famous is probably the row generator CONNECT BY LEVEL<10. Wise approach to constraint is to use a on-commit refreshable materialized view and a constraint on the materialized view to check the view is empty rather than using a trigger. This technique however requires COMMIT (like a deferred constraint).
Most Recent Customer Reviews
It is good book for average to advanced programmers. "Expert" in the name is somewhat misleading. Tips and tricks in this book are mostly well known. Read morePublished on October 17, 2013 by Amazon Customer
ok vadim knows his stff. but i want to see more emphasis on the practical sections (like sql servers pivot operator, which i use in practice all the time but only got 3 pages,... Read morePublished on September 11, 2009 by Pirc_defense_expert