shop by
Category
items
0 

The Art of SQL (Paperback)

Customer Reviews   Write a Review

AVERAGE RATING
5 out of 5
5
1
4
0
3
0
2
0
1
0
Total Reviews
1
5
Overall Satisfaction
3
Value
5
Ease of Use
5
Performance

Excellent for anyone looking to improve

on 7/6/2006

Nicely presented; easily holds your interest. Chock full of tradeoffs and other criteria to consider in many common data modelling situations. Plenty of attention to writing efficient SQL queries.

Was this review helpful to you?

YESNO

Product 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" only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.

"The Art of SQL" offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.

Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the numberof users doubles? What if you want to keep several years of data online? Faroult's way of looking at SQL performance may be unconventional and unique, but he's deadly serious about writing good SQL and using SQL well. "The Art of SQL" is not a cookbook, listing problems and giving recipes. The aim is to get you-and your manager-to raise good questions.

Specifications

Publisher Oreilly & Associates Inc
Mfg Part# 9780596008949
SKU 202099318
Format Paperback
ISBN10 0596008945
Release Date 4/10/2007
Product Attributes
eBooks Kobo
Book Format Paperback
Number of Pages 0349
Publisher O'Reilly Media
loading
$38.26 + free shipping
$44.99 You save $6.73 (14%)
Rakuten Super Points Earn 39 ($0.39) Rakuten Super Points™
What are Rakuten Super Points™?
Get rewarded when you shop! Earn 1 point per dollar spent. That's like getting cash back on every purchase. Easy to see matured points in checkout. Use points just like cash.
Learn More
Get this item for
(price with shipping)
(redeem points)
Format: Paperback
Condition: Brand New
In Stock. Usually Ships in 1 to 2 business days
Please select an option to buy
Add to Cart

Sold By:  VNHM SHOP
What is a Marketplace and Shop Owner?
  • Our marketplace is a platform where approved third-party retailers (Shop Owners) can sell their products
  • Items are sold and shipped by Shop Owners
  • Your credit card and personal information remain secure; Rakuten.com meets all PCI Security Standards.
  • Purchases can only be returned to the Shop Owner
  • All purchases receive Rakuten Super Points™
ADVERTISEMENT
Promotions & Offers (1)
  •  custom promo
    5% Back* Sitewide with Promo Code Rewardme *See page for details
Buy From Other Sellers (1)
kobo
  • Take your library with you wherever you go
  • Use the device you want to use… smartphone, desktop and many of today’s most popular eReaders

WHY KOBO?

We love the Kobo eReading service… and we know you will too. We’ve partnered with them to bring you the most flexible, enjoyable eReading experience in the U.S.

SHOPPING ON KOBO

You’ll be asked to sign in or create a new account with Kobo. Once you do, you’ll immediately get access to millions of titles and be ready to start eReading. Anytime. Anyplace.

continue to kobo
Recent Product Reviews


Excellent for anyone looking to improve on Jul 06, 2006

ADVERTISEMENT
ADVERTISEMENT