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. 
| Learn MoreYou may also be interested in |
Key Courses
Depending on your experience level with SQL Server 2005, more or less coursework may be required.
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.