This instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server. After completing this course, students will be able to use FOR XML and XPath queries, describe and use spatial data types in SQL Server, and implement and query full-text indexes.