- Shopping Bag ( 0 items )
From Barnes & Noble
The Barnes & Noble ReviewDatabase developers can’t fob off performance issues on DBAs anymore: They need to write optimized SQL code right from the start. With The Art of SQL, they will.
Stéphane Faroult consciously follows Sun Tzu’s classic The Art of War. Like great generals, Faroult says, SQL developers must plan well (design databases for performance); master tactics and maneuvering; handle the terrain (physical implementation); manage multiple fronts (concurrency); recognize classic situations and the corresponding SQL patterns; and make the most of spies (monitoring tools).
This book covers all that, and more. You’ll go beyond writing mere “statements,” understanding your real goals and anticipating the countermoves your environment might throw at you. (What if table volume suddenly increases, your user base doubles, you’re moved onto new hardware?) There’s plenty of code here, but what Faroult really does is teach better ways to think about SQL. Bill Camarda, from the June 2006 Read Only
Overview
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.
In The Art of SQL, author and SQL expert Stephane Faroult argues that this "safe approach" ...