The Art of SQL,9780596008949

The Art of SQL

by
ISBN13: 9780596008949
ISBN10: 0596008945
Format: Paperback
Pub. Date: 2006-03-01
Publisher(s): Oreilly & Associates Inc
  • eCampus.com Device Compatibility Matrix

    Click the device icon to install or view instructions

    Apple iOS | iPad, iPhone, iPod
    Apple iOS | iPad, iPhone, iPod
    Android Devices | Android Tables & Phones OS 2.2 or higher | *Kindle Fire
    Android Devices | Android Tables & Phones OS 2.2 or higher | *Kindle Fire
    Windows 10 / 8 / 7 / Vista / XP
    Windows 10 / 8 / 7 / Vista / XP
    Mac OS X | **iMac / Macbook
    Mac OS X | **iMac / Macbook
    Enjoy offline reading with these devices
    Apple Devices
    Android Devices
    Windows Devices
    Mac Devices
    iPad, iPhone, iPod
    Our reader is compatible
     
     
     
    Android 2.2 +
     
    Our reader is compatible
     
     
    Kindle Fire
     
    Our reader is compatible
     
     
    Windows
    10 / 8 / 7 / Vista / XP
     
     
    Our reader is compatible
     
    Mac
     
     
     
    Our reader is compatible
List Price: $58.87

Buy New

Usually Ships in 2-3 Business Days
$56.07
Add to Cart

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

Rent Digital

Rent Digital Options
Online:1825 Days access
Downloadable:Lifetime Access
$43.19
*To support the delivery of the digital material to you, a digital delivery fee of $3.99 will be charged on each digital item.
$43.19*
Add to Cart

Used Book

We're Sorry
Sold Out

Buy from our Marketplace starting at $4.37

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

SQL is the universal mode of database access for the majority of products on the market today. Use of this query language is therefore a combination of the pragmatic, the technical and the strategic. In "The Art of SQL", authors Stephane Faroult and Peter Robson demonstrate that SQL operations can be thought of as a pile of Lego blocks. You have to put them together in different ways to solve different problems. In so doing, patterns of use, of good practice, and of bad practice emerge. But these patterns can be seen in a wider strategic context, and it is at this level that "The Art of SQL" brings these patterns and practices to life in an engaging format.

Author Biography

Stephane Faroult first discovered relational databases and the SQL language back in 1983. He joined Oracle France in their early days (after a brief spell with IBM and a bout of teaching at the University of Ottawa) and soon developed an interest in performance and tuning topics. After leaving Oracle in 1988, he briefly tried to reform and did a bit of operational research, but after one year, he succumbed again to relational databases. He has been continuously performing database consultancy since then, and founded RoughSea Ltd in 1998.

Graduated in geology from Durham University (1968), then taught at Edinburgh University, obtaining an M.Phil in geology 1975. Worked in Greece as a geologist (1973,74), and then in University of Newcastle specialising in geological databases. Joined the British Geological Survey 1980, and has steered the organisations' use of database ever since, as data architect and database administrator. Has worked with databases since 1977, relational databases since 1981, and Oracle since 1985. He has lectured widely in the UK on geological aspects of database and has specialised on aspects of the SQL system as well as data modelling from the corporate architecture down to the departmental level. He has presented at various Oracle database conferences both in the UK, Europe and North America. Currently a director on the board of the UK Oracle Users Group.

Table of Contents

Preface ix
Laying Plans
1(26)
Designing Databases for Performance
Waging War
27(28)
Accessing Databases Efficiently
Tactical Dispositions
55(20)
Indexing
Maneuvering
75(30)
Thinking SQL Statements
Terrain
105(22)
Understanding Physical Implementation
The Nine Situations
127(40)
Recognizing Classic SQL Patterns
Variations in Tactics
167(32)
Dealing with Hierarchical Data
Weaknesses and Strengths
199(26)
Recognizing and Handling Difficult Cases
Multiple Fronts
225(22)
Tackling Concurrency
Assembly of Forces
247(32)
Coping with Large Volumes of Data
Stratagems
279(28)
Trying to Salvage Response Times
Employment of Spies
307(26)
Monitoring Performance
Photo Credits 333(2)
Index 335

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.