SQL Hacks - Tips & Tools for Digging into Your Data (NEW - With Source Code)
Andrew Cumming, Gordon Russell "SQL Hacks - Tips & Tools for Digging into Your Data (With Source Code)"
November 2006 | English | ISBN-13: 978-0-596-52799-0 | 304 Pages | CHM | 7.60 MB
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

(A book in the American Girl : History Mysteries series) (2002)
A novel byKathryn ReissNext book >> in the series
Grade 4-7-Set amid the rubble and confusion of the 1906 San Francisco earthquake, this story is full of suspense and action. Clara, 12, and her family are awakened in the early morning to a damaged home, but one that, miraculously, remains standing. In the aftermath of chaos and fire, she finds an abandoned baby on her doorstep. The mystery deepens when she discovers that the infant is really a girl who has been disguised as a boy. As Clara and her family care for her, they soon discover that the child had been kidnapped and is in danger. The plot unfolds smoothly and builds to a satisfying conclusion. Mystery fans will be hooked by the daring rescues, escapes, and sinister criminals. Details about the earthquake are seamlessly incorporated into the narrative, giving it a real context. A well-done afterword gives more information about the period.
Kristen Oravec, Cuyahoga County Public Library, Strongsville, OH
Copyright 2002 Reed Business Information, Inc.