This instructor-led course provides students with the necessary knowledge to work with the data in SQL Server 2008R2. They will learn how to use the built in tools included with SQL Server to construct queries, do tuning, analyze a query and it’s performance, along with how to modify existing data, perform joins, create indexes, and work with XML. The new features are discussed and their impact is explained.