Updates

Latest Tweet



What's New?

Check out for latest innovation, a computer based training video collection


Like this Page

Beginning Transact-SQL With SQL Server 2000 and 2005 Review by James Counihan

Practical and Usable

The authors have experience both as T-SQL developers and trainers, and it shows. Essential concepts and techniques are explained clearly without talking down to the reader. There's thorough coverage of the most commonly used T-SQL elements, in an easy-to-read style. It's well organized and includes appendices and a good index, making it easy to use as a reference. I work with both SQL Server 2000 and 2005, so it's ideal that the book covers both environments.

There are tons of code samples; most of them use the AdventureWorks database so reproducing them is easy. The exercises at the end of each chapter are good practice - not too difficult, but still good at reinforcing the content (answers are in the back of the book). Parts of my work involve reporting, so I found the chapter on doing Reporting Services development helpful as well. The biggest drawback I've found to this book is that my copy keeps getting borrowed..