Ah... sorry. My bad. I was being lazy.

The book title is "MCSE Training Guide / SQL Server 6.5 Design & Implementation. It was written to cover the old exam 70-27. It was published by New Riders Publishing and has a copyright of 1997. ISBN is 1-56205-830-4.

The book says its "target audience" is for advanced users but I've found it to be an excellent book for learning all of the basics of T_SQL, indexes, tables, data modeling, etc, etc. If you lookup some of the things that they're talking about in BOL, you have a very powerful teaching combination. What's really neat is, not only do they have review questions with the answers, they also have some nice, simple exercises at the end of each chapter.

My favorite paragraph in the whole books reads as follows (from the chapter on "Programmability")...

"As a rule, SQL Server can minipulate an arbitrarily large set of data as a set faster than it can respond to an interative series of commands. Because most iterative solutions can be expressed as set operations with little work, cursors should generally be avoided. Thinking in terms of whole sets of data instead of individual rows is what makes the SQL language so different from other traditional programming languages. Looking for set-oriented solutions to problems is, however, an important transition to make."