Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:


SQL Server 2008 for Administration

Gain the knowledge and skills to maintain a SQL Server 2008 R2 database.

Vendor# M6231

GK# 6182

Course Overview

This instructor-led course provides you with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. You will learn to use SQL Server 2008 R2 product features and tools to install and configure a database, manage database files, and create and tune indexes.

This course incorporates materials from the Official Microsoft Learning Product 6231: Maintaining a Microsoft SQL Server 2008 R2 Database.

Delivery Format Options

  • Classroom Live

    Classroom Live

    Receive face-to-face instruction at one of our training center locations.


    $2795 CAD

    5 day

  • Virtual Classroom Live

    Virtual Classroom Live

    Experience expert-led online training from the convenience of your home, office or anywhere with an Internet connection.


    $2995 CAD

    5 day

  • Virtual Classroom Fit

    Virtual Classroom Fit

    Attend live, online training sessions for a total of 24 hours spread over four weeks.


    $2795 CAD

    5 day

  • Private Group Training

    Private Group Training

    Train your entire team in a private, coordinated professional development session at the location of your choice.

    Receive private training for teams online and in-person.

Request a date or location for this course.

What You'll Learn

  • Plan, install, and configure SQL Server 2008 R2
  • Manage database files
  • Back up and restore databases
  • Manage security
  • Implement SQL Server 2008 R2 audits
  • Configure and assign permissions
  • Monitor data by using dynamic management views
  • Manage SQL Server 2008 R2 agent and jobs
  • Execute multi-server queries and configure a central management server
  • Deploy a data-tier-application
  • Troubleshoot common issues

Who Needs To Attend

  • IT professionals who administer and maintain SQL Server databases
  • Individuals who develop applications that deliver content from SQL Server databases

Course Outline

Download Course Outline

Training Exclusives

This course comes with 12 months access to the following benefits:

  • Practice Labs
  • 24x7 Mentoring
  • Indexed Class Recordings
  • Unlimited Retakes
  • Digital Courseware
Find out more