INSPIRING FUTURES

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

Cumming, Andrew and Russell, Gordon (2007) SQL Hacks. Tips and tools for digging into your data. Hacks Series . O'Reilly, Cambridge. ISBN 0596527993

Full text not available from this repository. (Request a copy)

Abstract/Description

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

Item Type: Book
ISBN: 0596527993
Additional Information: Alphabetical Subject Index, p367-386.
Uncontrolled Keywords: SQL; Applications; Efficiency;
University Divisions/Research Centres: Faculty of Engineering, Computing and Creative Industries > School of Computing
Dewey Decimal Subjects: 000 Computer science, information & general works > 000 Computer science, knowledge & systems > 005 Computer programming, programs & data
Library of Congress Subjects: Q Science > QA Mathematics > QA76 Computer software
Item ID: 1812
Depositing User: RAE Import
Date Deposited: 18 Jul 2008 16:57
Last Modified: 10 Dec 2013 13:58
URI: http://researchrepository.napier.ac.uk/id/eprint/1812

Actions (login required)

View Item

Edinburgh Napier University is a registered Scottish charity. Registration number SC018373