MCTS - Microsoft Certified Technology Specialist

• 
• 

The new Microsoft Certified Technology Specialist (MCTS) certification provides IT professionals with a simpler and more targeted framework to showcase their technical knowledge and expertise.

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface.

Prerequisites

Most candidates for this certification are IT professionals such as a database administrators, database developers, or business intelligence developers. They can also be people who do not work with Microsoft SQL Server but who want to enhance their technical expertise.

---

Learning Objectives

You must take the following core exam:

• 70-431

  Microsoft SQL Server 2005 - Implementation and Maintenance

  On completion of this module you will understand how to:

  • Install and configure SQL Server
  • Create tables and indexes, define columns, and implement constraints
  • Implement functions, stored procedures, and triggers by using Transact-SQL
  • Work with relational and XML data
  • Monitor, troubleshoot and tune queries
  • Maintain database availability with log shipping, database mirroring, and replication
  • Prepare a backup strategy and restore a database

Certifications

You will achieve the following certifications from this programme:

• MCTS (no more exams)

  MCTS (no more exams)

Related Courses

• MCITP MCITP Database Administrator
• 70-444 Optimizing and Maintaining a Database Administration Solution by Using Microsoft SQL Server 2005 (70-444)
• 70-443 Designing a Database Server Infrastructure by Using Microsoft SQL Server 2005 (70-443)

System Requirements

• 512MB RAM (1GB recommended)
• 8 GB available hard drive space
• 1024 x 768 resolution and 16 bit display
• CD/ DVD drive (DVD drive recommended)
• Microsoft Internet Explorer 6 Web browser
• Broadband Internet connection
• 600MHz Pentium III processor
• (1 GHz or faster recommended)
• Recommended Operating Systems:
• Microsoft Windows 2000 Professional or
• Server with Service Pack 4/
• Windows XP Professional with Service Pack 2/
• Windows Server 2003 Standard with Service Pack 1/
• Windows Server 2003 Enterprise with Service Pack 1/
• Windows Server 2003 Datacentre Edition with Service Pack 1

---