SQL Hacks

Tips & Tools for Digging Into Your Data

By: Andrew Cumming

Write A Review

Paperback | 28 November 2006

At a Glance

Paperback
410 Pages

Dimensions(cm)
26 x 153 x 228

Paperback

RRP $57.00

$30.75

46%OFF

or 4 interest-free payments of $7.69 with

Ships in 15 to 25 business days

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. It 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 most efficient way possible; aggregate and organize your data for meaningful and accurate reporting; make the most of subqueries, joins, and unions; stay on top of the performance of your queries and the server that runs them; and, avoid common SQL security pitfalls, including the dreaded SQL injection attack. Let "SQL Hacks" serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and "SQL Hacks" is the must-have book for you.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $89.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

You Can Find This Book In

Non-Fiction Computing & I.T.Computer Programming & Software Development Database Programming Computer Security Data Encryption Databases Data Mining Booktopia Publisher Services John Wiley & Sons Publishers UK Data Warehousing

Credits Preface
SQL Fundamentals
Run SQL from the Command Line
Connect to SQL from a Program
Perform Conditional INSERTs
UPDATE the Database
Solve a Crossword Puzzle Using SQL
Don't Perform the Same Calculation Over and Over
Joins, Unions, and Views
Modify a Schema Without Breaking Existing Queries
Filter Rows and Columns
Filter on Indexed Columns
Convert Subqueries to JOINs
Convert Aggregate Subqueries to JOINs
Simplify Complicated Updates
Choose the Right Join Style for Your Relationships
Generate Combinations
Text Handling
Search for Keywords Without LIKE
Search for a String Across Columns
Solve Anagrams
Sort Your Email
Date Handling
Convert Strings to Dates
Uncover Trends in Your Data
Report on Any Date Criteria
Generate Quarterly Reports
Second Tuesday of the Month
Number Crunching
Multiply Across a Result Set
Keep a Running Total
Include the Rows Your JOIN Forgot
Identify Overlapping Ranges
Avoid Dividing by Zero
Other Ways to COUNT
Calculate the Maximum of Two Fields
Disaggregate a COUNT
Cope with Rounding Errors
Get Values and Subtotals in One Shot
Calculate the Median
Tally Results into a Chart
Calculate the Distance Between GPS Locations
Reconcile Invoices and Remittances
Find Transposition Errors
Apply a Progressive Tax
Calculate Rank
Online Applications
Copy Web Pages into a Table
Present Data Graphically Using SVG
Add Navigation Features to Web Applications
Tunnel into MySQL from Microsoft Access
Process Web Server Logs
Store Images in a Database
Exploit an SQL Injection Vulnerability
Prevent an SQL Injection Attack
Organizing Data
Keep Track of Infrequently Changing Values
Combine Tables Containing Different Data
Display Rows As Columns
Display Columns As Rows
Clean Inconsistent Records
Denormalize Your Tables
Import Someone Else's Data
Play Matchmaker
Generate Unique Sequential Numbers
Storing Small Amounts of Data
Store Parameters in the Database
Define Personalized Parameters
Create a List of Personalized Parameters
Set Security Based on Rows
Issue Queries Without Using a Table
Generate Rows Without Tables
Locking and Performance
Determine Your Isolation Level
Use Pessimistic Locking
Use Optimistic Locking
Lock Implicitly Within Transactions
Cope with Unexpected Redo
Execute Functions in the Database
Combine Your Queries
Extract Lots of Rows
Extract a Subset of the Results
Mix File and Database Storage
Compare and Synchronize Tables
Minimize Bandwidth in One-to-Many Joins
Compress to Avoid LOBs
Reporting
Fill in Missing Values in a Pivot Table
Break It Down by Range
Identify Updates Uniquely
Play Six Degrees of Kevin Bacon
Build Decision Tables
Generate Sequential or Missing Data
Find the Top n in Each Group
Store Comma-Delimited Lists in a Column
Traverse a Simple Tree
Set Up Queuing in the Database
Generate a Calendar
Test Two Values from a Subquery
Choose Any Three of Five
Users and Administration
Implement Application-Level Accounts
Export and Import Table Definitions
Deploy Applications
Auto-Create Database Users
Create Users and Administrators
Issue Automatic Updates
Create an Audit Trail
Table of Contents provided by Publisher. All Rights Reserved.

SQL Hacks

Tips & Tools for Digging Into Your Data

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Database Programming

Analytics Engineering with SQL and Dbt

Building Meaningful Data Models at Scale

SQL All-in-One For Dummies

For Dummies (Computer/Tech)

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

SQL for Data Analysis

Advanced Techniques for Transforming Data Into Insights

Learning Php, MySQL & JavaScript

A Step-By-Step Guide to Creating Dynamic Websites

SQL Tuning

O'Reilly Ser.

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

Mastering Regular Expressions

Understand Your Data and Be More Productive

T-SQL Fundamentals

Developer Reference

SQL Essentials For Dummies

For Dummies (Computer/Tech)

SQL in a Week

A Fast-Track Guide to Writing and Optimizing Queries Like a Pro

Domain-Specific Small Language Models

PostgreSQL : Up and Running

A Practical Guide to the Advanced Open Source Database : 3rd Edition

Learning SQL

Generate, Manipulate, and Retrieve Data

SQL Pocket Guide

A Guide to SQL Usage

Learning Oracle PL/SQL

Learning Ser.

Transact-SQL Cookbook

Cookbooks Ser.

Web Database Applications with PHP and MySQL

OREILLY

Mastering Oracle SQL

O'Reilly Ser.

Oracle PL/SQL Best Practices

Write the Best PL/SQL Code of Your Life

MySQL in a Nutshell

A Desktop Quick Reference

Linq Pocket Reference

Learn and Implement Linq for .Net Applications

Head First PHP & MySQL

A Brain-Friendly Guide

This product is categorised by