Skip to main content

SQL Hacks

by Andrew Cumming

Series:Hacks

77 Members ½ (3.67)

On This Page

Recommendations

Author Information

Common Knowledge

Classifications

Description

Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to: Wrangle data in the show more most efficient way possibleAggregate and organize your data for meaningful show less

Tags

Recommendations

SQL Cookbook by Anthony Molinaro

Anthony Molinaro

MySQL Cookbook by Paul DuBois

Learning SQL by Alan Beaulieu

Learning Perl, Second Edition by Randal L. Schwartz

Learning Perl, Second Edition

Randal L. Schwartz

MySQL by Paul DuBois

Database System Concepts by Abraham Silberschatz

Database System Concepts

Abraham Silberschatz

SQL in a Nutshell: A Desktop Quick Reference by Kevin Kline

SQL in a Nutshell: A Desktop Quick Reference

Sams Teach Yourself SQL in 10 Minutes (3rd Edition) by Ben Forta

Sams Teach Yourself SQL in 10 Minutes (3rd Edition)

The Art of SQL by Stephane Faroult

Stephane Faroult

SQL for Dummies by Allen G. Taylor

SQL for Dummies

Allen G. Taylor

High Performance MySQL: Optimization, Backups, Replication, and Load Balancing by Jeremy D. Zawodny

High Performance MySQL: Optimization, Backups, Replication, and Load Balancing

Jeremy D. Zawodny

SQL Pocket Guide by Jonathan Gennick

SQL Pocket Guide

Jonathan Gennick

Web Database Applications with PHP and MySQL by Hugh E. Williams

Web Database Applications with PHP and MySQL

Hugh E. Williams

Time Series Databases: New Ways to Store and Access Data by Ted Dunning

Time Series Databases: New Ways to Store and Access Data

Statistics Hacks: Tips & Tools for Measuring the World and Beating the Odds by Bruce Frey

Statistics Hacks: Tips & Tools for Measuring the World and Beating the Odds

Perl Hacks: Tips & Tools for Programming, Debugging, and Surviving by Chromatic

Perl Hacks: Tips & Tools for Programming, Debugging, and Surviving

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design by Michael J. Hernandez

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design

Michael J. Hernandez

Cassandra: The Definitive Guide: Distributed Data at Web Scale by Jeff Carpenter

Cassandra: The Definitive Guide: Distributed Data at Web Scale

Programming the Perl DBI by Tim Bunce

Programming the Perl DBI

Access Database; Design & Programming by Steven Roman

Access Database; Design & Programming

The C Programming Language (2nd Edition) by Brian W. Kernighan

The C Programming Language (2nd Edition)

Brian W. Kernighan

Programming Perl [4th edition, blue camel] by Larry Wall

Programming Perl [4th edition, blue camel]

Fundamentals of Database Systems by Ramez Elmasri

Fundamentals of Database Systems

Managing and Using MySQL (2nd Edition) by Tim King

Managing and Using MySQL (2nd Edition)

Mastering Regular Expressions by Jeffrey E. F. Friedl

Mastering Regular Expressions

Jeffrey E. F. Friedl

An Introduction to Database Systems by C. J. Date

An Introduction to Database Systems

Practical Machine Learning with H2O: Powerful, Scalable Techniques for Deep Learning and AI by Darren Cook

Practical Machine Learning with H2O: Powerful, Scalable Techniques for Deep Learning and AI

The Practical SQL Handbook: Using Structured Query Language (3rd Edition) by Judith S. Bowman

The Practical SQL Handbook: Using Structured Query Language (3rd Edition)

Judith S. Bowman

Raspberry Pi Hacks: Tips & Tools for Making Things with the Inexpensive Linux Computer by Ruth Suehle

Raspberry Pi Hacks: Tips & Tools for Making Things with the Inexpensive Linux Computer

Extreme Programming Explained: Embrace Change by Kent Beck

Extreme Programming Explained: Embrace Change

PHP and MySQL Web Development by Luke Welling

PHP and MySQL Web Development

High Performance Spark: Best Practices for Scaling and Optimizing Apache Spark by Holden Karau

High Performance Spark: Best Practices for Scaling and Optimizing Apache Spark

Practical Machine Learning: A New Look at Anomaly Detection by Ted Dunning

Practical Machine Learning: A New Look at Anomaly Detection

Practical Machine Learning: Innovations in Recommendation by Ted Dunning

Practical Machine Learning: Innovations in Recommendation

Code Complete: A Practical Handbook of Software Construction by Steve McConnell

Code Complete: A Practical Handbook of Software Construction

Steve McConnell

MySQL, Second Edition by Larry Ullman

MySQL, Second Edition

XML Pocket Reference by Robert Eckstein

XML Pocket Reference

Robert Eckstein

Python High Performance: Build high-performing, concurrent, and distributed applications, 2nd Edition by Gabriele Lanaro

Python High Performance: Build high-performing, concurrent, and distributed applications, 2nd Edition

Gabriele Lanaro

Think Bayes: Bayesian Statistics in Python by Allen B. Downey

Think Bayes: Bayesian Statistics in Python

Allen B. Downey

Head First Data Analysis: A Learner's Guide to Big Numbers, Statistics, and Good Decisions by Michael Milton

Head First Data Analysis: A Learner's Guide to Big Numbers, Statistics, and Good Decisions

Head First SQL: Your Brain on SQL: A Learner's Guide by Lynn Beighley

Head First SQL: Your Brain on SQL: A Learner's Guide

Data Science at the Command Line: Facing the Future with Time-Tested Tools by Jeroen Janssens

Data Science at the Command Line: Facing the Future with Time-Tested Tools

Jeroen Janssens

Thoughtful Machine Learning with Python: A Test-Driven Approach by Matthew Kirk

Thoughtful Machine Learning with Python: A Test-Driven Approach

Python Data Science Essentials by Alberto Boschetti

Python Data Science Essentials

Alberto Boschetti

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Michael J. Hernandez

CSS Cookbook by Christopher Schmitt

Christopher Schmitt

MySQL Stored Procedure Programming by Guy Harrison

MySQL Stored Procedure Programming

PHP Cookbook by David Sklar

Excel Hacks: 100 Industrial-Strength Tips and Tools by Raina Hawley

Excel Hacks: 100 Industrial-Strength Tips and Tools

Graph Databases by Ian Robinson

Graph Databases

Complete Recommendations

Member Reviews

Members

Recently Added By: qta, trohrer, MikkilLib, smong, DavidCraddock, szarka, dasinck

Author Information

5 Works 83 Members

Series

Common Knowledge

Original publication date: 2006

Statistics

Members: 77
Popularity: 410,585
Rating: ½ (3.67)

Languages: English
Media: Paper, Ebook
ISBNs: 3
UPCs: 1
ASINs: 1

Quick Facts

Published: 2006
Genres: Technology, Nonfiction
DDC/MDS: 005.133
LCC: QA76.73 .S67 .C86

Author

Picture of author.

5 Works 83 Members

Popular Covers

Find It

Links

No links

Ratings

Stars: ½ (3.67)

Click to expand

Click to reduce

Helpers

Verdana Standard Verdana Small The Lorax System Standard System Large Georgia Large Text Atkinson