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

Cumming, Andrew; Russell, Gordon

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

• 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