One generic book that I have kept around is Database Management and Design by Hansen & Hansen - 1996. It's a little out of date on some stuff but covers the basics very well.

I also agree on Kalen Delaney's Inside SQL # books.

Regards;

Greg