Looking for good book for learning Sql queries for MS Sql server

Posted on 2012-09-03
Last Modified: 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 and do a search. However I am looking for some people who have actually used the material.
Question by:brgdotnet
    LVL 25

    Accepted Solution

    Cannot help you with a book recommendation ... I have never read a good one.  But I did take the code from the O'Reilly site for 'Learning SQL' and converted it to SQL Server so you can continue with it until you find a better book.

    Please wait to see what other experts recommend and award them the points.
    LVL 2

    Author Comment

    Oh my. Thank you so, so much. You have made my day. God Bless you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now