microsoft sql server 2008 T-sql fundamentals

chapter1:background to t-sql query chapter2:single-table queries chapter3:joins chapter4:subqueries chapter5:table expressions chapter6:set operations chapter7:pivot ,unpivot,and groupint sets chapter8:data modification chapter9:transactions and concurrency chapter10:programmable objects