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

[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).