A brief history of New Horizons

For the past 30 years our innovative, award-winning learning methods have revolutionized the way students learn, retain and apply new knowledge.

A brief history of New Horizons

SQL_Server_2005_Banner.jpg

MCTS: SQL Server 2005


Overview

New Horizons is the place to train and prepare for your MCTS SQL Server 2005 certification.

If you work with Microsoft SQL Server 2005, the Microsoft Certified Technology Specialist (MCTS) certification is a perfect foundation certification to establish your SQL Server 2005 expertise.

SQL2005

Learn More

You may also be interested in

Key Courses

Depending on your experience level with SQL Server 2005, more or less coursework may be required.
Outline2779 Implementing a Microsoft SQL Server 2005 Database
Outline2780 Maintaining a Microsoft SQL Server 2005 Database

Who's It For?

The MCTS SQL Server 2005 certification is an ideal foundation for any database professional who works with Microsoft SQL Server 2005 on a regular basis. With certification training at New Horizons, the student will learn:
  • Installing and configuring SQL Server 2005
  • Creating databases and understanding file structure
  • Enforcing data integrity with constraints and triggers
  • Creating and maintaining views, stored procedures and functions
  • Transactions and locks
  • Backup and restore
  • SQL Server 2005 administration
  • Replication

Certification and Exams

The MCTS SQL Server 2005 certification candidate must pass a single exam.
CertificationExams
MCTS: SQL Server 200570-431: TS: Microsoft SQL Server 2005 - Implementation & Maintenance