Share
Create bookmark
SQL Hacks
Notes
Please login to add notes
- Contents
- + Credits
- + Preface
- + SQL Fundamentals
- + Joins, Unions, and Views
-
+
Text Handling
-
+
Date Handling
-
+
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
- + Organizing Data
-
+
Storing Small Amounts of Data
-
+
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
-
+
Wider Access
- Index
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 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
- 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.
Test the closed alpha on paperc.com
Book Details
Authors
Andrew Cumming and Gordon Russell
Categories
Computers > Programming > General
Publishers
Publication year : 2007
License: All rights reserved ©
Times read: 2,443
