SQL Hacks
Tips & Tools for Digging Into Your Data
Publisher: O'Reilly Media
Final Release Date: November 2006
Pages: 412

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.

Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews


by PowerReviews
oreillySQL Hacks

(based on 4 reviews)

Ratings Distribution

  • 5 Stars



  • 4 Stars



  • 3 Stars



  • 2 Stars



  • 1 Stars



Reviewed by 4 customers

Displaying reviews 1-4

Back to top


Hack 17 for SQL server sample does not work

By Girmachew

from Seattle, WA

Comments about oreilly SQL Hacks:

I like the book but some of the examples are not working for me. i.e --SQL Hacks, Hack 17: Anagram Solver--sqlserver version. I am hoping Andrew can look at it

(3 of 6 customers found this review helpful)


Highly recommended for some immediate problem solving

By Edmonton Linux Users Group

from Edmonton

Comments about oreilly SQL Hacks:

100 hacks in just over 360 pages. Another in O'Reilly's popular

'Hacks' series, this one follows the same familiar format of grouping

related hacks into chapters. These include various items for handling

text, dates, and numbers, web interaction, performance issues,

administration and more.

Although SQL is generally portable (they all follow the standards,

right?), the authors take the time to provide examples with specific

databases, such as MySQL, Oracle, PostgreSQL, Oracle, and SQL Server, or

interfacing with a variety of languages, such as Perl, C#, and PHP, where


In my case, I am browsing for particular hacks that may be

applicable to some projects I'm starting. I found several that will be

useful, and I find that the implementation is fairly easy to understand.

And as I'm going through, I'm making a mental note of a few others that

catch my eye, in case I need them for the future.

Great book - highly recommended for some immediate problem solving

and to better understand the language by following the examples.

Review: http://elug.ca/reviews/sql_hacks.shtml (http://elug.ca/reviews/sql_hacks.shtml)

(3 of 6 customers found this review helpful)


Great Book

By guitarbuff0101

from Undisclosed

Comments about oreilly SQL Hacks:

This Hacks book is very good and well written. I haven't yet downloaded the sample DDL or DML statements from the O'Reilly Website because they don't exist(?).

Well worth the investment in SQL HACKS for intermediate database techniques.

(2 of 5 customers found this review helpful)


Fun book for exploring SQL,

By Anonymous

from Undisclosed

Comments about oreilly SQL Hacks:

I have not had that much fun with SQL queries till I started reading and experimenting with SQL Hacks.

SQL is often taken much for granted and this books helps explore different ways of approaching SQL queries. The different DBMS vendors have their unique flavor of SQL which SQL Hacks admiringly encompasses.

This book is a great reference/tutorial for readers with differing backgrounds except for the most experienced DBAs.

Displaying reviews 1-4

Back to top

Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook:  $23.99
Formats:  DAISY, ePub, Mobi, PDF
Print & Ebook:  $32.99
Print:  $29.99