{"product_id":"sql-hacks-tips-tools-for-digging-into-your-data-paperback","title":"SQL Hacks: Tips \u0026 Tools for Digging Into Your Data - Paperback","description":"\u003cp\u003eby \u003cb\u003eAndrew Cumming\u003c\/b\u003e (Author), \u003cb\u003eGordon Russell\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eWhether 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: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWrangle data in the most efficient way possible\u003c\/li\u003e \u003cli\u003eAggregate and organize your data for meaningful and accurate reporting\u003c\/li\u003e \u003cli\u003eMake the most of subqueries, joins, and unions\u003c\/li\u003e \u003cli\u003eStay on top of the performance of your queries and the server that runs them\u003c\/li\u003e \u003cli\u003eAvoid common SQL security pitfalls, including the dreaded SQL injection attack\u003c\/li\u003e\n\u003c\/ul\u003e \u003cp\u003eLet \u003ci\u003eSQL Hacks\u003c\/i\u003e 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.\u003c\/p\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eAndrew 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.\u003c\/p\u003e\u003cp\u003eDr. 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.\u003c\/p\u003e\u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 409\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 1 x 8.96 x 6.04 IN\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e December 26, 2006\u003c\/div\u003e","brand":"Books by splitShops","offers":[{"title":"Default Title","offer_id":42737090166847,"sku":"9780596527990","price":29.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0105\/8226\/1823\/files\/7cb3c89e2e70461bac5b81f83b278d04.webp?v=1765148802","url":"https:\/\/dhl-adrianne.myshopify.com\/products\/sql-hacks-tips-tools-for-digging-into-your-data-paperback","provider":"BBB","version":"1.0","type":"link"}