MOC 6232 - Implementing a Microsoft SQL Server 2008 R2 Database

Course duration

5 Days

Course Outline

This SQL Server training class 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.

The class is intended for IT Professionals who want to become skilled on SQL Server 2008 R2 product features and technologies for implementing a database.

Understand the product, its components, and basic configuration.

Learn to work with the data types supported by SQL Server.

Learn to design and implement tables and work with schemas.

Learn to design and implement views and partitioned views.

Learn the concept of an index and determine the appropriate data type for indexes and composite index structures.

Learn to identify the appropriate table structures and implement clustered indexes and heaps.

Learn to describe and capture execution plans.

Learn to design and implement non-clustered indexes, covering indexes, and included columns.