ASM Educational Center, Inc.
11200 Rockville Pike, Suite 220 - Rockville, MD 20852
Phone: (301) 984-7400 - E-mail: info@asmed.com - Website: www.asmed.com

Course Outline
MCTS (Microsoft Certified Technology Specialist)
SQL Server 2005  - Boot Camp Training


Day 1

  • Installing and Configuring SQL Server 2005
  • Managing Databases and Files
  • Disaster Recovery


Day 2
  • Managing Security
  • Monitoring SQL Server
  • Transferring Data
  • Automating Administrative Tasks

Day 3
  • Implementing Replication
  • Maintaining High Availability
  • Creating Databases and Database Files
  • Creating Data Types and Tables
  • Using XML

Day 4
  • Creating and Tuning Indexes
  • Implementing Data Integrity by Using Constraints
  • Implementing Data Integrity by Using Triggers and XML Schemas
  • Implementing Views
  • Implementing Stored Procedures

Day 5
  • Implementing Functions
  • Implementing Managed Code in the Database
  • Managing Transactions and Locks
  • Using Service Broker

Day 6 - Testing Day
  • General Review
  • Exam 70-431: Microsoft SQL Server 2005 - Implementation and Maintenance

Note: The student is not obligated to take the exam on the defined day of training. He/She can take the exam when he/she feels comfortable to do it, during or after the training period.

ASM Educational Center, Inc.
11200 Rockville Pike, Suite 220 - Rockville, MD 20852
Phone: (301) 984-7400 - E-mail: info@asmed.com - Website: www.asmed.com

URL: www.asmed.com/programs/outlines/mcts_SQL2005_outline.htm