For the Spring 2009 Quarter, I will be teaching MCIS 4423 SQL Server With Lab, MCIS 4428 Advanced Database Design, and MCIS 4440 T-SQL Programming. MCIS 4423 will be Online, while MCIS 4428 and MCIS 4440 will be on campus.
The textbook for MCIS 4428 will be Pro SQL Server 2008 Relational Database Design and Implementation.
The text book for MCIS 4440 will be Microsoft SQL Server 2008 T-SQL Fundamentals
The text book for MCIS 4423 will be Beginning SQL Server 2008 for Developers: From Novice to Professional
These are all very good books, two of them written by SQL Server MVPs.
Glenn Berry's SQL Server Performance 