Database and transact-sql in sql server 2008
querying and filtering data
grouping and summarizing data
joining data from multiple tables
working with subqueries
modifying data in tables
querying metadata, xml, and full-text indexes
using programming objects for data retrieval
using advanced