Synopsis
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.
"synopsis" may belong to another edition of this title.
About the Authors
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.
"About this title" may belong to another edition of this title.
Other Popular Editions of the Same Title
Search results for SQL Hacks: Tips & Tools for Digging Into Your Data
Stock Image
SQL Hacks: Tips & Tools for Digging Into Your Data
Seller: Your Online Bookstore, Houston, TX, U.S.A.
Seller rating 5 out of 5 stars
paperback. Condition: Good. Seller Inventory # 0596527993-3-30669955
Stock Image
SQL Hacks : Tips and Tools for Digging into Your Data
Published by
O'Reilly Media, Incorporated, 2006
ISBN 10: 0596527993
ISBN 13: 9780596527990
Used
Softcover
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # 5662393-6
Stock Image
SQL Hacks : Tips and Tools for Digging into Your Data
Published by
O'Reilly Media, Incorporated, 2006
ISBN 10: 0596527993
ISBN 13: 9780596527990
Used
Softcover
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Former library copy. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Includes library markings. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # 11481717-6
Stock Image
SQL Hacks : Tips and Tools for Digging into Your Data
Published by
O'Reilly Media, Incorporated, 2006
ISBN 10: 0596527993
ISBN 13: 9780596527990
Used
Softcover
Seller: Better World Books: West, Reno, NV, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # 5662393-6
Stock Image
SQL Hacks : Tips and Tools for Digging into Your Data
Published by
O'Reilly Media, Incorporated, 2006
ISBN 10: 0596527993
ISBN 13: 9780596527990
Used
Softcover
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good. Seller Inventory # 11604796-75
Seller Image
SQL Hacks: Tips & Tools for Digging Into Your Data
Seller: Greenworld Books, Arlington, TX, U.S.A.
Seller rating 5 out of 5 stars
Condition: good. Fast Free Shipping â" Good condition. It may show normal signs of use, such as light writing, highlighting, or library markings, but all pages are intact and the book is fully readable. A solid, complete copy that's ready to enjoy. Seller Inventory # GWV.0596527993.G
Stock Image
SQL Hacks: Tips & Tools for Digging Into Your Data
Seller: Wonder Book, Frederick, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: As New. Like New condition. A near perfect copy that may have very minor cosmetic defects. Seller Inventory # E17B-01559
Stock Image
SQL Hacks: Tips & Tools for Digging Into Your Data
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G0596527993I4N00
Stock Image
SQL Hacks: Tips & Tools for Digging Into Your Data
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G0596527993I4N00
Stock Image
SQL Hacks: Tips & Tools for Digging Into Your Data
Seller: ThriftBooks-Phoenix, Phoenix, AZ, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G0596527993I4N00