SQL Server book recommendation

Question

Hello Experts,

I'm just a beginner in development field.Looking for SQL Server books. Please tell me which is good book to study from. Any suggestion and pointer will be really helpful . thanks

Answer 1

Beginner level:

• Head First SQL (not SQL Server specific)

• Beginning SQL Server 2008 for Developers

• Microsoft SQL Server 2008 T-SQL Fundamentals

• Learn SQL Server

Advanced:

• Microsoft SQL Server 2008 Internals

Online, free stuff:

• SQL Tutorial

• SQL Videos

• SQL Server 2005 Learning Resources

• SQL Server 2008 Learning Resources

Just found a similiar SO question: Reading recommendations for: Microsoft SQL Server

Answer 2

Look at the sql server books online, probably the best resource for anything SQL Server.

Answer 3

In addition to everything else, I would highly recommend the Database Design for Mere Mortals book by Michael Hernandez. It's very well written, touches on all the important points, works out the good and bad of database design, and is very useful overall.

It's not SQL Server specific, but all the concepts and ideas put forward here absolutely apply to anyone doing any serious work in SQL Server.

Once you've designed and set up your database, you might need to query it :-) and then I'd recommend the companion book SQL Queries for Mere Mortals which covers the querying techniques - what are the various JOIN types, what do they do, etc.