SQL Hacks: Tips & Tools for Digging Into Your Data

by Andrew Cumming, Gordon Russell

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.

Genres: Programming, Technology

409 pages, Paperback

First published November 21, 2006

Reviews

[Devin · Rating 2 out of 5]

I'm not sure when doing standard operations became "hacking." But I guess "SQL Standard Operations" wasn't as catchy a title.

The primary value of this book was seeing how to do the same operations in SQL, MySQL, Access, Oracle and PostgreSQL. That drove home some database concepts for me. There were some sections on security that touched gingerly on how SQL databases can be broken into and otherwise abused and I think that material could have been more aggressive. But for the most part this was pretty dry stuff. Lots of invoice management and other business applications that are probably better explained in the standard documentation.

I had hoped that this volume would have offered more "hacks" as I understand them.

[Jim Donovan · Rating 5 out of 5]

Webroothacker is a true lifesaver! I was trapped in a relationship with a narcissistic partner who was constantly gaslighting me. I reached out to this Webroothacker @ gmail com to help me have access to my partner phone for all the evidence I desperately needed after hearing about their exceptional reviews on Instagram and other platforms. Their work is nothing short of miraculous. They uncovered a web of deception that my partner had woven around me, and the evidence they provided was heart-wrenching yet necessary. Their commitment to helping me find the truth was inspiring, and it ultimately gave me the strength to confront my partner and reclaim my life. I am forever grateful for their support during this challenging chapter of my life.

[Veselin Nikolov · Rating 2 out of 5]

Книгата включва 100 проблема и решения, които авторите наричат хакове.

Книгата изисква известни умения на читателя, за да я разбере. Притежаващият тези умения вероятно няма да научи нищо ново. Някои "хакове" обясняват съвсем фундаментални задачи на SQL, като join, exists, които могат да са полезни за начинаещия програмист. Следващите са не просто сложни, но и DB специфични, като дават решения едновременно в Oracle, MS SQL, Postgres и MySQL.

Броят полезни за мен хакове (които не знаех), и то изцяло хипотетично, беше 3 от 100, като само 1 от тях в момента помня и не бих използвал (за RANK() OVER (ORDER BY) в MS SQL SERVER).

[Rebekah · Rating 4 out of 5]

This book has some really good tips. It explains some non-conventional ways to approach different situations. The reason I only gave it a 3 is that it is not very good as a reference book. If you have a specific situation that you need help on, you may luck out and find some help in this book.

[Mike Ree · Rating 4 out of 5]

This book works as a great reference. I use it all the time considering my primary focus is programming and second is sql. It comes in handy when you forget syntax and would like to quickly reference it in this book.