MCTS SQL Server 2005 - Microsoft Certification Training

Microsoft Certification Training

You are here:

Home Microsoft Certification Training MCTS: SQL Server 2005

Microsoft Certified Technology Specialist (MCTS): SQL Server 2005

Certification Training

Overview

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

Quick Course Guide
Qualification	MCTS: .SQL Server 2005	Student support	24x7 support by expert mentors
Study time	23 hours	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

24/7 support - get help from expert mentors anytime
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.

Enquire to find out about pricing and course specials, and get instant access to a free demo.