> Nearby Locations
Gainesville - Tallahassee - Pensacola
My Account  |  View Cart

The information on this site is not intended for Veterans Administration benefit training. Please contact us directly to get information on our CCTV delivery options of approved VA programs.

MCTS: SQL Server 2005


New Horizons Gainesville 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 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.
Outline 2779 Implementing a Microsoft SQL Server 2005 Database
Outline 2780 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 Gainesville, 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.

Certification Exams
MCTS: SQL Server 2005 70-431: TS: Microsoft SQL Server 2005 - Implementation & Maintenance