Limit search to available items
Book Cover
E-book
Author Cumming, Andrew.

Title SQL hacks / by Andrew Cumming, Gordon Russell
Edition First edition
Published Sebastopol, Calif. : O'Reilly, 2006
Online access available from:
Safari O'Reilly books online    View Resource Record  

Copies

Description 1 online resource
Series Hacks series
Hacks series.
Contents Ch. 1. SQL fundamentals -- Ch. 2. Joins, unions, and views -- Ch. 3. Text handling -- Ch. 4. Date handling -- Ch. 5. Number crunching -- Ch. 6. Online applications -- Ch. 7. Organizing data -- Ch. 8. Storing small amounts of data -- Ch. 9. Locking and performance -- Ch. 10. Reporting -- Ch. 11. Users and administration -- Ch. 12. Wider access
Summary 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
Notes Print version record
Subject SQL (Computer program language)
Form Electronic book
Author Russell, Gordon, 1969-
ISBN 0596527993
0596551428
9780596527990
9780596551421