Microsoft_MCTS_Microsoft_SQL_Server_2008__DDIM

Overview

MCTS: Microsoft SQL Server 2008, Database Development & Implementation and Maintenance

This course is targeted at the Technology Specialist Certification of SQL Server 2008 Database Development and Implementation and Maintenance. After the completion of this course, candidates will be able to implement tables and views, implement programmable objects, work with query fundamentals and apply additional query techniques in SQL Server 2008 R2.

They will also learn how to work with additional SQL Server 2008 R2 components, XML data and gather performance information. Apart from that the candidates will be able to install and configure SQL Server 2008 R2, maintain instances, manage security, maintain a database and perform data management tasks. They will also learn how to monitor and troubleshoot SQL Server, optimize performance and implement high availability.

Course Content / Exam(s)

Schedule for MCTS: Microsoft SQL Server 2008, Database Development & Implementation and Maintenance Boot Camp Training

Course#

Course Content

Exam#

Exam

Regular Track (days)

Fast Track (days)

Super Fast Track (days)

2778A

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

70-433

TS: Microsoft SQL Server 2008, Database Development

3

2

1 6232B

Implementing a Microsoft SQL Server 2008 R2 Database

6

4

2 6231B

Maintaining a Microsoft SQL Server 2008 R2 Database

70-432

TS: Microsoft SQL Server 2008, Implementation and Maintenance

6

4

2 Extra Days for Exam (if required)

4

3

2 Total Duration

19

13

7 Prerequisites:

Before attending this course, students must have: