Skip to content

SQL Hacks: Tips & Tools for Digging Into Your Data
Stock Photo: Cover May Be Different

SQL Hacks: Tips & Tools for Digging Into Your Data Paperback - 2006 - 1st Edition

by Andrew Cumming; Gordon Russell

This new book in the critically acclaimed "Hacks" series provides 100 unique tips and tools that push the limits of traditional SQL, from fun things like solving crosswords with SQL to complex data manipulation.


From the publisher

Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:

  • Wrangle data in the most efficient way possible
  • Aggregate and organize your data for meaningful and accurate reporting
  • Make the most of subqueries, joins, and unions
  • Stay on top of the performance of your queries and the server that runs them
  • Avoid common SQL security pitfalls, including the dreaded SQL injection attack

Let SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.

Details

  • Title SQL Hacks: Tips & Tools for Digging Into Your Data
  • Author Andrew Cumming; Gordon Russell
  • Binding Paperback
  • Edition number 1st
  • Edition 1
  • Pages 409
  • Volumes 1
  • Language ENG
  • Publisher O'Reilly Media, U. S. A.
  • Date 2006-12-26
  • Illustrated Yes
  • Features Illustrated, Index, Table of Contents
  • ISBN 9780596527990 / 0596527993
  • Weight 1.2 lbs (0.54 kg)
  • Dimensions 8.96 x 6.04 x 1 in (22.76 x 15.34 x 2.54 cm)
  • Library of Congress subjects SQL (Computer program language)
  • Dewey Decimal Code 005.756

Media reviews

Citations

  • Scitech Book News, 03/01/2007, Page 22

About the author

Andrew Cumming is the Zoo Keeper at http: //sqlzoo.net . He keeps a collection of tame SQL engines and presents these to the public. He cares for these beasts, protecting them from the abuse inflicted by SQL learners, and protecting SQL learners from the injuries that the wild engines can inflict. But mostly he shovels manure out the cages and hoses them down every now and then. Andrew also teaches at Napier University in Edinburgh, Scotland.

Dr. Gordon Russell is a Computing lecturer in Napier University, Scotland. He teaches databases, Linux, and networking. He also builds educational websites, concentrating on technology-driven online learning environments. These include db.grussell.org, whose claim-to-fame is its automatic checking of SQL assessments, and http: //linuxzoo.net, which offers online users root free access to Linux servers. But without database technology to support these sites, even he would be lost.

Back to Top

More Copies for Sale

SQL Hacks : Tips and Tools for Digging into Your Data
Stock Photo: Cover May Be Different

SQL Hacks : Tips and Tools for Digging into Your Data

by Cumming, Andrew, Russell, Gordon

  • Used
Condition
Used - Good
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
1
Seller
Mishawaka, Indiana, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
$6.88
FREE shipping to USA

Show Details

Description:
O'Reilly Media, Incorporated. Used - Good. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages.
Item Price
$6.88
FREE shipping to USA
SQL Hacks : Tips and Tools for Digging into Your Data
Stock Photo: Cover May Be Different

SQL Hacks : Tips and Tools for Digging into Your Data

by Cumming, Andrew, Russell, Gordon

  • Used
Condition
Used - Good
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
1
Seller
Reno, Nevada, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
$6.88
FREE shipping to USA

Show Details

Description:
O'Reilly Media, Incorporated. Used - Good. Former library book; may include library markings. Used book that is in clean, average condition without any missing pages.
Item Price
$6.88
FREE shipping to USA
SQL Hacks : Tips and Tools for Digging into Your Data
Stock Photo: Cover May Be Different

SQL Hacks : Tips and Tools for Digging into Your Data

by Cumming, Andrew, Russell, Gordon

  • Used
Condition
Used - Very Good
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
1
Seller
Mishawaka, Indiana, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
$6.99
FREE shipping to USA

Show Details

Description:
O'Reilly Media, Incorporated. Used - Very Good. Used book that is in excellent condition. May show signs of wear or have minor defects.
Item Price
$6.99
FREE shipping to USA
SQL Hacks : Tips and Tools for Digging into Your Data
Stock Photo: Cover May Be Different

SQL Hacks : Tips and Tools for Digging into Your Data

by Cumming, Andrew, Russell, Gordon

  • Used
Condition
Used - Good
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
1
Seller
Mishawaka, Indiana, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
$6.99
FREE shipping to USA

Show Details

Description:
O'Reilly Media, Incorporated. Used - Good. Used book that is in clean, average condition without any missing pages.
Item Price
$6.99
FREE shipping to USA
SQL Hacks : Tips and Tools for Digging into Your Data

SQL Hacks : Tips and Tools for Digging into Your Data

by Gordon Russell; Andrew Cumming

  • Used
  • good
  • Paperback
Condition
Used - Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
1
Seller
Seattle, Washington, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
$7.00
FREE shipping to USA

Show Details

Description:
O'Reilly Media, Incorporated, 2006. Paperback. Good. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Item Price
$7.00
FREE shipping to USA
SQL Hacks
Stock Photo: Cover May Be Different

SQL Hacks

by Andrew Cumming; Gordon Russell

  • Used
  • Paperback
Condition
Used: Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
1
Seller
HOUSTON, Texas, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
$7.80
FREE shipping to USA

Show Details

Description:
O'Reilly Media, 2006-11-28. Paperback. Used: Good. Excellent customer service. Prompt Customer Service.
Item Price
$7.80
FREE shipping to USA
SQL Hacks: Tips & Tools for Digging Into Your Data

SQL Hacks: Tips & Tools for Digging Into Your Data

by Russell, Gordon

  • Used
  • very good
  • Paperback
Condition
Used - Very Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
1
Seller
GORING BY SEA, West Sussex, United Kingdom
Seller rating:
This seller has earned a 2 of 5 Stars rating from Biblio customers.
Item Price
$20.22
$10.87 shipping to USA

Show Details

Description:
Paperback. Very Good.
Item Price
$20.22
$10.87 shipping to USA
SQL Hacks: Tips & Tools for Digging Into Your Data
Stock Photo: Cover May Be Different

SQL Hacks: Tips & Tools for Digging Into Your Data

by Cumming, Andrew; Russell, Gordon

  • New
Condition
New
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
40
Seller
Benton Harbor, Michigan, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
$19.81
$3.99 shipping to USA

Show Details

Description:
O'Reilly Media. New. BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!
Item Price
$19.81
$3.99 shipping to USA
SQL Hacks: Tips & Tools for Digging Into Your Data
Stock Photo: Cover May Be Different

SQL Hacks: Tips & Tools for Digging Into Your Data

by Cumming, Andrew; Russell, Gordon

  • Used
  • Paperback
Condition
Like New
Binding
Paperback
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
800
Seller
Fairfax Station, Virginia, United States
Seller rating:
This seller has earned a 2 of 5 Stars rating from Biblio customers.
Item Price
$21.18
$3.99 shipping to USA

Show Details

Description:
O'Reilly Media, 2006-12-12. Paperback. Like New.
Item Price
$21.18
$3.99 shipping to USA
SQL Hacks: Tips & Tools for Digging Into Your Data
Stock Photo: Cover May Be Different

SQL Hacks: Tips & Tools for Digging Into Your Data

by Cumming, Andrew; Russell, Gordon

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9780596527990 / 0596527993
Quantity Available
800
Seller
Fairfax Station, Virginia, United States
Seller rating:
This seller has earned a 2 of 5 Stars rating from Biblio customers.
Item Price
$21.34
$3.99 shipping to USA

Show Details

Description:
O'Reilly Media, 2006-12-12. Paperback. New.
Item Price
$21.34
$3.99 shipping to USA