Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

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

Accepted Solution

lwadwell earned 1040 total points
ID: 38362283
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.

Author Comment

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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

571 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