Microsoft Course 6231 - Maintaining a Microsoft SQL Server 2008 Database — A 5 day course

contact usEnquire about this course

Synopsis

Th Microsoft M6231 course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Objectives

After completing the Microsoft M6231 training course the student will be able to:

Contents

Installing and Configuring SQL Server

The students will be introduced to planning for a SQL Server installation. The students will then be introduced to installing, configuring, and managing SQL Server.

Managing Databases and Files

The students will be introduced to database planning and creation, and using database options to control database behaviour.

Disaster Recovery

The students will be introduced to disaster recovery techniques for SQL Server. They will learn how to perform different types of backup and restore operations, including online restores and backup and restores of system databases.

Managing Security

The students will be introduced to protecting SQL Server. Students will learn about the SQL Server security model and how to use SQL Server security features to control access to databases and their contents.

Transferring Data

The students will be introduced to transfer data to and from SQL Server using UI and command-line tools, and learn about transferring and transforming data with SQL Server Integration Services.

Automating Administrative Tasks

The students will learn how to automate routine administrative tasks using jobs, operators, and alerts.

Implementing Replication

The students will be introduced to techniques for configuring SQL Server replication.

Maintaining High Availability

The students will be introduced to concepts and methods for maintaining high availability with SQL Server.

Monitoring SQL Server

The students will be introduced to monitoring SQL Server performance and activity.

Troubleshooting and Performance Tuning

The students will learn how to troubleshoot a variety of common SQL Server problems. Students will also learn how to tune SQL Server for improved performance using a variety of tools.

Publicly scheduled dates, locations, and prices

A schedule of dates for this subject is not currently available. Please call 0333 210 0140 or use our contact form to enquire about places and availability.

Suitable For

The Microsoft MS6231 course is intended for IT Professionals who administer and maintain SQL Server databases.

Follow-On Courses

M6232 - Implementing a Microsoft SQL Server 2008 Database

M6234 - Implementing and Maintaining Microsoft SQL Server 2008 Analysis Service

M6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

M6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Prerequisites

Before attending the Microsoft 6231 course, students should have the following prerequisites:

Basic knowledge of the Microsoft Windows operating system and its core functionality

Working knowledge of Transact-SQL

Working knowledge of relational databases

Some experience with database design

Completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

Examination

This course along with M6232 - Implementing a Microsoft SQL Server 2008 Database helps candidates prepare for the Exam 70-432.

When you pass Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance, you complete the requirements for the following certification(s):

Microsoft Certified Technology Specialist (MCTS): Microsoft SQL Server 2008, Implementation and Maintenance