• Career
• Valued Customers

MCTS: Microsoft SQL Server 2005-Implementation and Maintenance

Overview & Objectives:
The Technology Specialist certifications enable professionals to target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.

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. Technology Specialists

Who should attend:
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database. Before attending this course, students must have:

• Basic Knowledge of the Microsoft Windows Operating System and its Core Functionality
• Working Knowledge of Transact-SQL
• Knowledge of relational Databases
• Some Experience with Database Design

Course Duration:
Fives Fays or 30 Hours

Course modules:

70-431 TS: Microsoft SQL Server 2005 - Implementation and Maintenance

Course 2779 - Two Days
Module 1: Creating Databases and Database Files
Module 2: Creating Data Types and Tables
Module 3: Using XML
Module 4: Creating and Tuning Indexes
Module 5: Implementing Data Integrity
Module 6: Implementing Views
Module 7: Implementing Stored Procedures and Functions
Module 8: Implementing Managed Code in the Database
Module 9: Using Service Broker

Course 2780 - Three Days
Module 1: Installing and Configuring SQL Server 2005
Module 2: Managing Databases and Files
Module 3: Disaster Recovery
Module 4: Managing Security
Module 5: Monitoring SQL Server
Module 6: Transferring Data
Module 7: Automating Administrative Tasks
Module 8: Maintaining High Availability
Module 9: Introduction to Replication