Course Detail 
SQL2008-ADMINBOOTCAM - 00 MCTS: SQL Server 2008, Implementation and Maintenance Boot Camp  
Schedule
DateDayStart TimeEnd TimeDaysLocationRequest InfoRegistration
False2010/09/132010/09/1709:0017:00ef9c6288-0aff-4c4d-9b94-165d8c4a9de809/13/2010
09/14/2010
09/15/2010
09/16/2010
09/17/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/10/042010/10/0809:0017:00630e249a-3e3f-4439-8a4a-a3e85edb90bc10/04/2010
10/05/2010
10/06/2010
10/07/2010
10/08/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/10/112010/10/1509:0017:00ee47d906-354b-40d3-b414-49c62e46664f10/11/2010
10/12/2010
10/13/2010
10/14/2010
10/15/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New York City-Midtownrequest inforegister
False2010/10/182010/10/2209:0017:007494cf23-00ce-42b3-b789-9c84e9c4639710/18/2010
10/19/2010
10/20/2010
10/21/2010
10/22/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/11/012010/11/0509:0017:00b0cca7e9-f6ee-4c82-8432-29123229593f11/01/2010
11/02/2010
11/03/2010
11/04/2010
11/05/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/11/082010/11/1209:0017:006b9e7c5c-6212-4b83-91f6-59905617614511/08/2010
11/09/2010
11/10/2010
11/11/2010
11/12/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New York City-Midtownrequest inforegister
False2010/11/152010/11/1909:0017:0077e18168-072d-45fa-8034-538439c1f19111/15/2010
11/16/2010
11/17/2010
11/18/2010
11/19/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/11/292010/12/0309:0017:00c9f500d2-04ee-4e66-b917-c7d60b5b07be11/29/2010
11/30/2010
12/01/2010
12/02/2010
12/03/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister
False2010/12/062010/12/1009:0017:0060091848-9467-4fb4-8fc5-523432201c0212/06/2010
12/07/2010
12/08/2010
12/09/2010
12/10/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New York City-Midtownrequest inforegister
False2010/12/132010/12/1709:0017:002981523f-73f2-4336-9b7a-825592b0108012/13/2010
12/14/2010
12/15/2010
12/16/2010
12/17/2010
Monday
Tuesday
Wednesday
Thursday
Friday
9:00 AM
9:00 AM
9:00 AM
9:00 AM
9:00 AM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5:00 PM
5New Jerseyrequest inforegister

The MCTS: SQL Server 2008: Implementation and Maintenance bootcamp is for professionals who work with SQL Server 2008, or who anticipate doing so in the near future.

This Microsoft MCTS boot camp training includes 50 hours on intense training lectures, hands on labs, Microsoft Official Courseware, test prep material for the exam, and lunch.

This bootcamp consists of the following courses:

Training begins every morning at 8:00 AM and ends at 6:00 PM.

Module I of II

Course 6231 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services Boot Camp

This instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Course objectives:

  • Install and configure SQL Server 2008.
  • Manage database files.
  • Backup and restore databases.
  • Manage security.
  • Transfer data into and out of SQL Server.
  • Automate administrative tasks.
  • Replicate data between SQL Server instances.
  • Maintain high availability.
  • Monitor SQL Server.

Module II of II

Course 6232: Implementing a Microsoft SQL Server 2008 Database Boot Camp

This instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Course Objectives:

  • Create databases and database files.
  • Create data types and tables.
  • Use XML-related features in Microsoft SQL Server 2008.
  • Plan, create, and optimize indexes.
  • Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.
  • Implement data integrity in Microsoft SQL Server 2008 by using triggers.
  • Implement views.
  • Implement stored procedures.
  • Implement functions.
  • Implement managed code in the database.
  • Manage transactions and locks.
  • Use Service Broker to build a messaging-based solution.

You may also be interested in the following training course:

MCTS: SQL Server 2008, Business Intelligence Development and Maintenance Boot Camp