Information Technology - IT Courses

You are here:

Home Information Technology - IT CoursesMCTS: SQL Server 2005

Microsoft Certified Technology Specialist (MCTS): SQL Server 2005

Certification Training

Validate your in-depth knowledge of SQL Server 2005 with this globally recognised Microsoft certification.

SEEK Learning will provide you with all the training you need to pass the MCTS exam (70-431) and get certified - guaranteed.

Who is this course for?

SQL developers
Database administrators
Database developers
Enterprise developers

View all Microsoft courses

Quick Course Guide

Qualification: MCTS: .SQL Server 2005
Student support: Weekday email support by expert mentors

Study time: 7 weeks
Pre-requisites: None

Enrolment dates: Enrol anytime - start now!
Assessment: MCTS exam 70-431 (by external provider)

Delivered by: SkillSoft
Resources required: Internet, email

Master One of the World's Most Popular Databases

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.

Find out if the MCTS: SQL Server 2005 is right for you - contact a SEEK Learning consultant for free expert advice.

Skills You'll Gain

As an MCTS: SQL Server 2005 certified professional, you'll 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

What's Included

Weekday email support by expert mentors
Access to online library Books 24x7
Hands-on interactive exercises
Practice exam questions
Self-paced study format
Certification guarantee - get certified or your money back

MCTS: SQL Server 2005 Course Details

Course Outline

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

SEEK Learning's MCTS certification training will fully prepare you for the MCTS: SQL Server 2005 exam (70-431).

Please note that the MCTS exams are held by an external provider. For your convenience, SEEK Learning will help you find your nearest exam centre. Contact a SEEK Learning consultant for further information or assistance.

Take the Next Step Toward Becoming an MCITP

As a Microsoft Certified IT Professional (MCITP), you distinguish yourself with more comprehensive skills and advanced expertise in Microsoft technologies.

This MCTS course is the first step towards the following Microsoft Certified IT Professional (MCITP) certifications:

SEEK Learning offers package deals to help you save while you skill up. Contact a SEEK Learning consultant now for more information.

Training Exclusively Through SEEK Learning

SEEK Learning provides training from SkillSoft, the premier global provider of IT e-learning courseware.

SkillSoft does not generally offer courses directly to individuals, but our partnership enables us to exclusively offer MCTS training directly to you.

SkillSoft courses are developed according to the certification specifications of leading vendors.