MCTS 70-431 SQL Server 2005 Implementation

Exam 70–431

MCTS Microsoft SQL Server 2005

Implementation and Maintenance

This certification helps you target specific technologies and distinguish yourself 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. They have extensive knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Technology Specialists generally become database administrators, developers, or business intelligence developers.

This course also greatly benefits you if you do not work with Microsoft SQL Server as part of your primary job role, but want to show your depth of technology experience, such as systems administrators, developers and many others. This also shows that you have sought out knowledge and experience with Microsoft SQL Server 2005 to enhance your technical expertise, and you can implement and maintain databases by using specific instructions and specifications.

·        Learning / Exam module:  70-431

·        Course Duration: 32 Hours

Learning Segments: 

Module-1 Creating Databases and Database Files

Creating Databases.

Creating Filegroups.

Creating Schemas.

Creating Database Snapshots

Module-2 Creating Data Types and Tables

Creating Data Types.

Creating Tables.

Creating Partitioned Tables.

Module-3 Using XML

Retrieving XML by Using FOR XML

Shredding XML by Using OPENXML

Using the xml Data Type

Module-4 Creating and Tuning Indexes

Planning Indexes

Creating Indexes

Optimising Indexes

Creating XML Indexes

Module-5 Implementing Data Integrity

Data Integrity Overview

Implementing Constraints

Implementing Triggers

Implementing XML Schemas

Module-6 Implementing Views

Introduction to Views

Creating and Managing Views

Optimizing Performance by Using Views

Module-7 Implementing Stored Procedures and Functions

Implementing Stored Procedures

Creating Parameterized Stored Procedures

Creating Functions

Handling Errors

Controlling Execution Context

Module-8 Implementing Managed Code in the Database

Introduction to the SQL Server Common Language Runtime

Importing and Configuring Assemblies

Creating Managed Database Objects

Module-9 Using Service Broker

Service Broker Overview

Creating Service Broker Objects

Sending and Receiving Messages

Maintaining a Microsoft SQL Server 2005 Database

Module-1 Installing and Configuring SQL Server 2005

Preparing to install SQL Server

Installing SQL Server

Managing a SQL Server 2005 Installation

Module-2 Managing Databases and Files

Planning databases

Creating databases

Managing databases

Module-3 Disaster Recovery

Planning a Backup Strategy

Backing Up User Databases

Restoring User Databases

Recovering Data from Database Snapshots

System Database and Disaster Recovery

Module-4 Managing Security

Overview of SQL Server Security

Securing the Server Scope

Securing the Database Scope

Managing Keys and Certificates in SQL Server

Module-5 Monitoring SQL Server

Viewing Current Activity

Using System Monitor

Using SQL Server Profiler

Using DDL Triggers

Using Event Notifications

Module-6 Transferring Data

Overview of Data Transfer

Introduction to SQL Server Integration Services

Using SQL Server Integration Services

Module-7 Automating Administrative Tasks

Automating Administrative Tasks in SQL Server 2005

Configuring the SQL Server Agent

Creating Jobs and Operators

Creating Alerts

Managing Multiple Servers

Managing SQL Server Agent Security

Module-8 Maintaining High Availability

Introduction to High Availability

Implementing Server Clustering

Implementing Database Mirroring

Implementing Log Shipping

Module-9 Introduction to Replication

Overview of Replication

Replication Scenarios