For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any “bad SQL” later.
The Art of SQL
1 Reviews
0 Reviews
| Author | Stephane Faroult |
| Author | Peter Robson |
| Publisher | O'Reilly |
| Year | 2006 |
| Pages | 367 |
| ISBN | 0596008945 |
One review for “The Art of SQL”
-
review by erniel October 16th, 2007 - 7:34 am
Starting with a small negative. This book frustrated me at times. There is no shortage of great (and essential) information from start to finish, but the constant ‘battle’ references, and over explanation on non essential points drove me crazy. eg. In the discussion of atomicity, an extra couple of sentences on its 5th century Greek origins is a distraction. That aside, this is the best practical SQL/Relation model book I have read. Chapter 6, ‘The Nine Situations’ is perfect to make yourself look at data situations in different ways, and the different ways of handling them. I had not thought of breaking them down like this.
Don’t even think of reading this book unless you have a number of years of RDBMS experience & some failure, as you will be left behind. Even experienced database developers will be challenged, and may have to come back to a topic later (like I did a number of times), for it to make its point.
An almost brilliant book.