Teach yourself how to design and create SQL Server 2008 databases one step at a time. Work at your own pace through the book's practical, skill-building lessons and the hands-on practice files on CD. YouÕll begin by learning to install and configure SQL Server 2008, design a model database, and work with tables and indexes. Next, you'll learn techniques to manipulate, maintain, and retrieve data. Finally, you'll learn more-advanced techniques, such as using views, functions, and triggers. As you complete each lesson, you can hone your skills using the practice exercises on the companion CD.
I had some of my webapps get upgraded from 2000 to 2008. I didn't need to rewrite much but I wanted to know what new features were available. I don't spend much time with SQL Server but I was able to get most of the info I needed to make a few optimizations to my old apps. If you aren't doing a lot of DBA type work this is a nice refresher for after a few years on ice.
Nice overview of every aspect of SQL Server 2008 -- no stone is left unturned. There was just enough SQL to serve as a brush-up. The book explained the new inner and outer join syntax. Not new for most people; I realized I had not written serious SQL code in 10 years. Of course, this is 2014 and the book only covers 2008... There is a 2012 "Step by Step" book but the author is Patrick LeBlanc.