- Used Books
- Staff Picks
- Gifts & Gift Cards
- Sell Books
- Stores & Events
- Let's Talk Books
Special Offers see all
More at Powell's
Recently Viewed clear list
New Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
SQL Hacksby Andrew Cumming
Synopses & Reviews
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.
Book News Annotation:
Two teachers at Napier University in Scotland provide 100 tips for handling text and numbers in SQL databases, organizing data, improving query performance, minimizing delays, and processing report data. Most of the code examples use the MySQL command line utility and note variations for SQL Server, Oracle, PostgreSQL, and Access. Annotation ©2007 Book News, Inc., Portland, OR (booknews.com)
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.
SQL is the cornerstone of database programming and this book provides 100 hacks that push the limits of traditional SQL, from fun stuff like solving crosswords with SQL to hardcore data wrangling. Written by the author of A Gentle Introduction to SQL (sqlzoo.net), it covers the most popular databases: Access, SQL Server, Oracle, MySQL, and PostgreSQL.
About the Author
Andrew Cumming is the Zoo Keeper at http://sqlzoo.net . He keeps a collection of tame SQL engines and presents these to the public. He cares for these beasts, protecting them from the abuse inflicted by SQL learners, and protecting SQL learners from the injuries that the wild engines can inflict. But mostly he shovels manure out the cages and hoses them down every now and then. Andrew also teaches at Napier University in Edinburgh, Scotland.
Dr. Gordon Russell is a Computing lecturer in Napier University, Scotland. He teaches databases, Linux, and networking. He also builds educational websites, concentrating on technology-driven online learning environments. These include db.grussell.org, whose claim-to-fame is its automatic checking of SQL assessments, and http://linuxzoo.net, which offers online users root free access to Linux servers. But without database technology to support these sites, even he would be lost.
Table of Contents
CreditsPrefaceChapter 1: SQL FundamentalsChapter 2: Joins, Unions, and ViewsChapter 3: Text HandlingChapter 4: Date HandlingChapter 5: Number CrunchingChapter 6: Online ApplicationsChapter 7: Organizing DataChapter 8: Storing Small Amounts of DataChapter 9: Locking and PerformanceChapter 10: ReportingChapter 11: Users and AdministrationChapter 12: Wider AccessColophon
What Our Readers Are Saying
Other books you might like
Computers and Internet » Computer Languages » SQL