10 of 10 people found the following review helpful
I second Peter Lee,
This review is from: Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer) (Paperback)
I purchased T-SQL Fundamentals after reading Peter Lee's review and I was not misled; it is an excellent book. But I believe some additional information may be helpful.
If your interest is data extraction and manipulation then, whatever your existing knowledge, I do not see how you can go wrong with this book. It starts at a very basic level but by the end you will be tackling extremely difficult exercises with confidence. If you are a developer, this book will be a useful addition to your library but it only covers enough on create database, table etc. to enable you to understand data extraction and manipulation. It mentions filegroups and partitions, for example, but not the T-SQL to create and manage them.
I have only one significant criticism: Appendix A should be Chapter 1. Appendix A tells those who have no access to Sequel Server at work how to install it on their home computer so they can try out the exercises. I did not notice Appendix A until after I had messed up my first installation.
A lesser criticism is that the book recommends installing Sequel Server Enterprise Edition on a 120 day free trial. What do you do at the end of the free trial? Enterprise Edition is the fullest and most expensive edition. Developer Edition is a lot cheaper, is also available on free trial and the only minus is its functionality is limited by license to a development environment. However, I chose Express Edition which is free forever. OK, it is limited but it is more than adequate for a training environment. Once you have built up your knowledge, you can upgrade to the appropriate fuller edition.