Skip to main content

Research Repository

Advanced Search

SQL Hacks. Tips and tools for digging into your data.

Cumming, Andrew; Russell, Gordon

Authors

Andrew Cumming



Abstract

...SQL Hacks reveals the secrets that database experts use to dig through their data and get the answers they need. It includes 100 hacks for sorting, sifting, shuffling, and pushing the limits of traditional SQL. You'll learn how to:

Send SQL commands to your database from the command line and programs.
Use advanced join, filter and grouping techniques to get data ready for reports...
Perform complicated searches and sorts on strings, dates and more...
Manage users and audit the changes they make to the database.
Minimize CPU and network overhead with efficient alternatives to common SQL operations...

Citation

Cumming, A., & Russell, G. (2007). SQL Hacks. Tips and tools for digging into your data. O'Reilly

Book Type Authored Book
Publication Date 2007-11
Deposit Date Jul 18, 2008
Peer Reviewed Peer Reviewed
Book Title SQL Hacks. Tips and tools for digging into your data.
ISBN 596527993
Keywords SQL; Applications; Efficiency;
Public URL http://researchrepository.napier.ac.uk/id/eprint/1812






You might also like



Downloadable Citations