| Welcome to vBulletin FAQ |
vBulletin FAQ Navigation
Getting Started
Customizing your vBulletin
Search Engines & SEO
Making Money with a Forum
Promoting your Community
|
| Get your own vBulletin Today |
|
| Webmaster Help |
|
|
|
The Art of SQL (Art of)
vBulletin Book Store > vBulletin books beginning with A
|
The Art of SQL (Art of) |
Author: Stephane Faroult
Published: 2006-03-01 |
List price: $44.99
Our price: $29.69
|
Usually ships in 24 hours
As of: November 20th, 2008 01:24:00 PM
|
|
|
Customer comments on this selection.
 If Sun Tzu Wrote SQL...
...he might write a book like "The Art of SQL". There are a lot of SQL books on the market - some of them very good. So why would there need to be a new book written about the subject? You know, when I first picked up this book I thought the very same thing. But then, after reading through it, I'm convinced that we need Stephane Faroult's "The Art of SQL."
br /
br /This book deals with SQL performance through the lens of Sun Tzu's venerable treatise "The Art of War." For those who do not know it, "The Art of War" is an ancient Chinese military treatise written during the 6th century BC by Sun Tzu. It consists of 13 chapters; each one is devoted to a single aspect of warfare. Many view it as the definitive work on military strategies and tactics. This ancient book is still being read and followed to this day. For such a work to still be viable thousands of years later is a credit to its usefulness and importance.
br /
br /It is also noteworthy that there have been several attempts by various authors to translate Sun Tzu's tenets into modern day applications such as business philosophy and sales training, but this new book is the first that I know of to translate these concepts into database programming and SQL. The author actually uses the exact same title chapters for The Art of SQL that Sun Tzu used in The Art of War. Amazingly enough, the tactic works.
br /
br /Consider, for example, the chapter titled "Laying Plans," in which Faroult examines how to design databases for performance. As anyone who ever built database applications knows an improperly designed database can be the biggest impediment to flawless application performance.
br /
br /The chapter titled "Tactical Dispositions" covers the topic of indexing and in "The Nine Situations" the author examines several calssic SQL patterns and how best to approach them.
br /
br /This book is not for a novice who wants to learn SQL from scratch. The author assumes the reader is conversant with SQL as he describes how to apply SQL in a practical manner. If you can't code an outer join or don't know what a nested table expression or in-line view is, then this is not the book for you.
br /
br /Neither is the book a list of SQL scripts that you can pluck out and use. Instead, The Art of SQL skillfully manages to explain how to properly attack the job of coding SQL to effectively and efficiently access your data. The book offers best practices that teach experienced SQL users to focus on strategy rather than specifics.
br /
br /As the author points out, "You need knowledge, you need skills, and you need talent. Talent cannot be taught, but it can be nurtured. This is what most strategists, from Sun Tzu to modern-day generals, have believed." And now Faroult's book, The Art of SQL, is there to help nurture your talent.
An excellent book to read after you think you know databases
This is a book in a somewhat-similar vein to Effective C++: 55 Specific Ways to Improve Your Programs and Designs (3rd Edition) (Addison-Wesley Professional Computing Series): it spends most of its time shining light on the dark nooks and crannies of database design and query optimization, and assumes that you've already at least learned that those dark nooks and crannies exist.
br /
br /It is also written with the database programmer in mind, rather than the database administrator. There are not many books written for us, and I'm really pleased that one of them is a book this excellent.
Excellent
This book is very well written and goes into depth on the practical reasons behind best-practices as well as real-world examples.
This is the book to have if you want to discover better practices for your SQL
This book review was submitted by a Roanoke Valley SQL Server Users Group member as part of the Book Review Program.
br /
br /Reviewed by Jerry Ellis
br /
br /The Art of SQL does not fall into the trap of becoming "just another reference" for SQL users. It tackles real world problems with the point of view that you know how to write SQL code, but may need help in the proper tactics to most effectively handle them. What is refreshing is that it does not say here is a piece of code that will do this...it says, that may work, but here is a better way and why.
br /
br /This is the book to have if you want to discover better practices for your SQL.
br /
br /Jerry Ellis
br /
 Not practical
I'm torn in giving stars to this book. On the one hand there a number of fascinating topics covered, topics not found in other books in my library. They tend to be of a quite academic nature, discussing the internals of how the optimizer and the DBMS engine work. From that standpoint this book would earn 5 stars.
br /
br /On the other hand, I purchased the book because I have real-world problems to solve in my job. Despite what the quotes on the back cover and first pages say, virtually nothing covered in this book is of any value in solving real-world problems. The book introduces what seems like a promising new sql construct or optimization idea, describes it in detail, and then unfailingly proceeds to state all the disadvantages of using the new idea and concludes that you shouldn't bother with it. I was interested in finding new techniques to apply to real-world problems, and came away instead with a long list of new techniques to forget about. From a practical standpoint this book would earn 1 star.
br /
br /So overall I give it 3 stars, an interesting read, but of little value on the job.
|
|
Our vBulletin book picks:
|
|
Find more vBulletin related products of interest.
|
