Well i am not the kind that reads lots and lots of books (still i am trying to be like that), but one of the special books i have ever read is SQL Hacks

This book is really special , it can really change the way you write SQL. To clarify one thing first, if you are completely new to sql and have never worked with it before this book is not for you, to use this book you must have used sql at least very basic statments of it). Anyone with initial use of sql will find things that are hard to query or looks like imposible to do with sql if you are one of these people this book is best for you cause it will show you in very easy simple way that the thing you thought it is impossible is actually very easily done in sql!!

The book is devided into categories of sql uses (basic, search, web,…etc) which make all the information and tips & tricks easily accessable to the reader.

One of the most wonderful and helpful feature of the book that it is not specific to a signle DBMS solution, it provides the tips&tricks in all sql formats of the most used databases (Oracle, MYSQL, MSSQL, PostgreSQL, Access) and explains the differances between the sql statment of the current tip in each DBMS.

The SQL Recipes provided in the book covers reall world database related problems’ best solutions. Many of theser recipes (hacks) will improve sql you write day to day (it did improve mine few years ago) few others explain very special cases that you may face in rarely, but knowing the best solution will keep you ready to tackle that problem once you are facing it.

although the book is published in 2006 (it isn’t a new book) and i wanted to write about here long time ago but never got to write about till now, but this book don’t have time span. it never gets old. since the industry uses Oracle,MYSQL ,MSSQL Server , etc the book will be very valuable asset to any developer.

No related posts.