New Horizons Ireland
+353 1 8898700
 
 
My Account  |  View Cart

MCTS: SQL Server 2005



Overview


New Horizons Ireland - Dublin and Galway 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.

SQL Server 2005 Certifications

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 Ireland - Dublin and Galway, 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


Times Course Title Duration Outline
Microsoft SQL Server 2005
 - Microsoft SQL Server 2005 Training
2779 Implementing a Microsoft SQL Server 2005 Database
5 Day(s) Outline
2780 Maintaining a Microsoft SQL Server 2005 Database
5 Day(s) Outline
2781 Designing Microsoft SQL Server 2005 Server-Side Solutions
3 Day(s) Outline
2782 Designing Microsoft SQL Server 2005 Databases
2 Day(s) Outline
2783 Designing the Data Tier for Microsoft SQL Server 2005
1 Day(s) Outline
2784 Tuning and Optimizing Queries Using Microsoft SQL Server 2005
3 Day(s) Outline
2786 Designing Microsoft SQL Server 2005 Infrastructure and Services
2 Day(s) Outline
2787 Designing Security for Microsoft SQL Server 2005
2 Day(s) Outline
2788 Designing a High Availability Database Solutions Using Microsoft SQL Server 2005
3 Day(s) Outline
2789 Administering and Automating Microsoft SQL Server 2005 Databases and Servers
1 Day(s) Outline
2790 Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005
2 Day(s) Outline
2791 Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services
3 Day(s) Outline
2792 Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
3 Day(s) Outline
2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services
3 Day(s) Outline