SQL Hacks

Whether you need to merely sort the data as it comes out of the database or perform complex calculations, SQL Hacks reveals the secrets that database experts use to dig through their data and get the answers they need. It includes 100 hacks for sorting, sifting, shuffling, and pushing the limits of traditional SQL.Youll learn how to:Send SQL commands to your database from the command line and programsUse advanced join, filter, and grouping techniques to get data ready for reportsSolve puzzles using SQLPerform complicated searches and sorts on strings, dates, and moreSet up your transactions so that users dont collide with one anotherManage users and audit the changes they make to the databaseMinimize CPU and network overhead with efficient alternatives to common SQL operationsEven if youve been using the databases covered in this bookAccess, MySQL, SQL Server, Oracle, and PostgreSQLfor years, SQL Hacks will make sure you never look at your trusty SELECT, INSERT, UPDATE, and DELETE statements in the same way again.About the AuthorsAndrew 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 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.