Andrew Cumming A.Cumming@napier.ac.uk
TRACKER Officer
SQL Hacks. Tips and tools for digging into your data.
Cumming, Andrew; Russell, Gordon
Authors
Dr Gordon Russell G.Russell@napier.ac.uk
Associate Professor
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
Detection of Ransomware
(2024)
Patent
An Auditable Framework for Evidence Sharing and Management using Smart Lockers and Distributed Technologies: Law Enforcement Use Case
(2024)
Presentation / Conference Contribution
Forensic Considerations for the High Efficiency Image File Format (HEIF)
(2020)
Presentation / Conference Contribution
WaterLeakage: A Stealthy Malware for Data Exfiltration on Industrial Control Systems Using Visual Channels
(2019)
Presentation / Conference Contribution
Downloadable Citations
About Edinburgh Napier Research Repository
Administrator e-mail: repository@napier.ac.uk
This application uses the following open-source libraries:
SheetJS Community Edition
Apache License Version 2.0 (http://www.apache.org/licenses/)
PDF.js
Apache License Version 2.0 (http://www.apache.org/licenses/)
Font Awesome
SIL OFL 1.1 (http://scripts.sil.org/OFL)
MIT License (http://opensource.org/licenses/mit-license.html)
CC BY 3.0 ( http://creativecommons.org/licenses/by/3.0/)
Powered by Worktribe © 2024
Advanced Search