Andrew Cumming A.Cumming@napier.ac.uk
TRACKER Officer
Andrew Cumming A.Cumming@napier.ac.uk
TRACKER Officer
Dr Gordon Russell G.Russell@napier.ac.uk
Associate Professor
...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...
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 |
PLC Memory Attack Detection and Response in a Clean Water Supply System
(2019)
Journal Article
Decrypting Live SSH Traffic in Virtual Environments
(2019)
Journal Article
Fingerprinting JPEGs With Optimised Huffman Tables
(2018)
Journal Article
Risk assessment for mobile systems through a multilayered hierarchical Bayesian network.
(2016)
Journal Article
About Edinburgh Napier Research Repository
Administrator e-mail: repository@napier.ac.uk
This application uses the following open-source libraries:
Apache License Version 2.0 (http://www.apache.org/licenses/)
Apache License Version 2.0 (http://www.apache.org/licenses/)
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 © 2025
Advanced Search