If you’re a regular reader of my blog then you probably know that I’m a big fan of the Murach’s books and Murach’s SQL Server 2005 for Developers is no exception.
If I were teaching a course on SQL for Developers this would be the text book that I’d use. It even comes with an Instructor’s DVD.
While it contains the expected academics, it also includes lots of “real world stuff”. In addition to the basic mechanics of programming against SQL Server it includes great sections on things like SQL Database Design and a SQL CLR drill down. It also includes cool advances sections like all about working with temp tables.
This one will stay on my in-reach book case. Hope you pick up a copy.