Want a NOOK? Explore Now
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:
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.
This new book in the critically acclaimed "Hacks" series provides 100 unique tips and tools that push the limits of traditional SQL, from fun things like solving crosswords with SQL to complex data manipulation.
Credits
Preface
Chapter 1: SQL Fundamentals
Chapter 2: Joins, Unions, and Views
Chapter 3: Text Handling
Chapter 4: Date Handling
Chapter 5: Number Crunching
Chapter 6: Online Applications
Chapter 7: Organizing Data
Chapter 8: Storing Small Amounts of Data
Chapter 9: Locking and Performance
Chapter 10: Reporting
Chapter 11: Users and Administration
Chapter 12: Wider Access
Colophon
Overview
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...