(MCTS) SQL Server 2005

Face-to-face Instructor Led Courses, IT and Computing, Databases

What Is (MCTS) SQL Server 2005 Training?

The MCTS credential enables you to target specific technologies and gain capabilities in implementing, building, troubleshooting and debugging those technologies. As a Microsoft Certified Technology Specialist in Microsoft SQL Server 2005, you'll have thorough knowledge of the product, understand how to use the tools and Transact-SQL language and know how to explore the user interface. By the end of the course delegates will be able to : Install, configure and troubleshoot SQL Server 2005 - Create data types and tables - Use XML-related features in Microsoft SQL Server 2005 - Plan, create and optimise indexes - Implement data integrity by using constraints, triggers and XML schemas - Manage database files and security - Transfer data - Back up and restore databases.

Who Should Attend

Any person who requires the need to be trained in (MCTS) SQL Server 2005 through the course of their normal working duties. This course is suitable for anyone working in the Databases arena or IT and Computing sector, pre-requisites may be required.

Course Agenda

- Installing SQL Server 2005
- Configuring SQL Server 2005
- Creating and Implementing Database Objects in SQL Server 2005
- Retrieving Data and Running Queries in SQL Server 2005
- SQL Server 2005 Messaging and Querying Tools
- Managing and Maintaining SQL Server 2005 Databases
- SQL Server 2005 Database Performance and Optimization
- Monitoring and Diagnosing Database Problems in SQL Server 2005
- SQL Server 2005 High Availability and Disaster Recovery
- SQL Server 2005 Backup and Restores.


Available onsite or nationwide at any of over 50 centres, see below our open course availability. Alternatively, call 0844 335 8882.


The (MCTS) SQL Server 2005 course will be accredited to the latest in recognised certificating award. All successful delegates will also receive an Xyz certificate of attendance. Enrolled subscribers of the National Training Card will also have any certificate, qualification and/or ID card (where applicable) automatically added to their member account.

More Information

Please note that the MCTS exams are held by an external provider.

Course Availability

Available on client premises as an in-house course or at one of training venues, provided minimum delegate numbers are achieved. Whatever your requirement, simply complete the enquiry form below and we'll send you our quotation by return.

Make A (MCTS) SQL Server 2005 General Enquiry Here

Complete the form below and we'll send you some training options and / or a quote by return. Please only use this form if you are interested in (MCTS) SQL Server 2005 courses. For all other enquiries, please use the general contact page, refine your search above or call us on 0844 335 8882.

(MCTS) SQL Server 2005 Training Enquiry

Open / Public Course Dates
Open Courses Unavailable
eLearning Options
eLearning Currently Unavailable
(MCTS) SQL Server 2005
Part of our Databases range of training courses

Course Information

  • Course Duration 7 weeks
  • Max Class Size 12

  • All prices exclude VAT. Discounts available for larger groups & for corporate clients.
Our (MCTS) SQL Server 2005 Training Courses

Rated 4.4 / 5
*based on 103 client reviews.