Tuesday, February 7, 2012

T-SQL Fundamentals Book Review

I just finished an excellent SQL book...

Ben-Gan, I. (2009). Microsoft SQL Server 2008 T-SQL Fundamentals. Redmond: Microsoft Press.
It is one of the best SQL books I have read. It is written in  a very straightforward style. There are 10 chapters covering all the usual topics from table creation up through triggers and stored procedures. What I especially liked about this book was that it goes into some more advanced topics. It discusses pivot and unpivot, common table expressions, the newer with clause and window functions for example. The author also has some good example exercises for testing transactions. It you are looking for a straightfoward presentation of these more advanced topics, this is your book.

Our intermediate level SQL class will feature some material drawn from this book, although adapted to our sample classroom databases.

No comments:

Post a Comment