SQL Hacks
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…
Specifikacia SQL Hacks
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 possibleAggregate and organize your data for meaningful and accurate reportingMake the most of subqueries, joins, and unionsStay on top of the performance of your queries and the server that runs themAvoid common SQL security pitfalls, including the dreaded SQL injection attackLet SQL Hacks serve as your toolbox
Excel Hacks
Fashion Hacks
Car Hacks
Astronomy Hacks
IRC Hacks
SQL
SQL Server T-SQL Recipes
SQL Server 2005 T-SQL Recipes
SQL Server 2012 T-SQL Recipes
Linux Server Hacks
Hacks for Alexa
Understanding Network Hacks
101 Life Hacks
Gut Health Hacks
WINDOWS SERVER HACKS
SQL Tuning