Looking for good book for learning Sql queries for MS Sql server
Posted on 2012-09-03
Hello, I have been working with sql off and on for a few years now. Basically I am able to use Joins to extra data from one or more data tables. however I would like to learn how to perform sql queries using subqueries.
Can someone recommend a good sql book which would come with a Sql database which I could use to query against?
I did buy the book "Learning Sql" an Oreilly book by Alan Beaulieu. I like his explanation of subqueries, however I have no way of practicing because the sample database is written in MySql. I tried to convert it to a Sql server database, however that was a real nightmare.
So if someone knows of a good book which is geared tword sql server, I would appreciate it, since I have version of Sql server 2005 and 2008.
I would appreciate some help from someone who has actually read or has used the book personally. I can easily go on Amazon.com and do a search. However I am looking for some people who have actually used the material.