Course MS E6231 - Maintaining a Microsoft SQL Server 2008 Database

Imprimer Retour

Goal

Maintaining a Microsoft SQL Server 2008 Database five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. This Maintaining a Microsoft SQL Server 2008 Database course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database. This Maintaining a Microsoft SQL Server 2008 Database course is intended for IT Professionals who administer and maintain SQL Server databases.

Prerequisites

Before attending this course, students must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of Relational databases.
  • Core Windows Server skills.
  • Database design skills.

In addition, it is recommended, but not required, that students have completed:

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

Content

  • Install and configure SQL Server 2008.
  • Manage database files.
  • Backup and restore databases.
  • Manage security.
  • Transfer data into and out of SQL Server.
  • Automate administrative tasks.
  • Replicate data between SQL Server instances.
  • Maintain high availability.
  • Monitor SQL Server.

Course Language

FR

Course material

  • Official Microsoft MS 6231 coursebook

Duration

5 day(s)

Our group lessons

Availability on request

General conditions of sales

If you have any difficulties with physical access or require any assistance please contact our teams.