Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-6231 - Maintaining a Microsoft SQL Server 2008 Database

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.

Click here to print this page »


  • 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

Detailed Class Syllabus

Module 1: Introduction to SQL Server 2008 R2 and its Toolset

Introduction to SQL Server Platform
Working with SQL Server Tools
Configuring SQL Server Services

Module 2: Preparing Systems for SQL Server 2008 R2

Overview of SQL Server 2008 R2 Architecture
Planning Server Resource Requirements
Pre-installation Testing for SQL Server 2008 R2

Module 3: Installing and Configuring SQL Server 2008 R2

Preparing to Install SQL Server 2008 R2
Installing SQL Server 2008 R2
Upgrading and Automating Installation

Module 4: Working with Databases

Overview of SQL Server Databases
Working with Files and Filegroups
Moving Database Files

Module 5: Understanding SQL Server 2008 R2 Recovery Models

Backup Strategies
Understanding SQL Server Transaction Logging
Planning a SQL Server Backup Strategy

Module 6: Backup of SQL Server 2008 R2 Databases

Backing up Databases and Transaction Logs
Managing Database Backups
Working with Backup Options

Module 7: Restoring SQL Server 2008 R2 Databases

Understanding the Restore Process
Restoring Databases
Working with Point-in-time Recovery
Restoring System Databases and Individual Files

Module 8: Importing and Exporting Data

Transferring Data To/From SQL Server 2008 R2
Importing & Exporting Table Data
Inserting Data in Bulk

Module 9: Authenticating and Authorizing Users

Authenticating Connections to SQL Server
Authorizing Logins to Access Databases
Authorization Across Servers

Module 10: Assigning Server and Database Roles

Working with Server Roles
Working with Fixed Database Roles
Creating User-defined Database Roles

Module 11: Authorizing Users to Access Resources

Authorizing User Access to Objects
Authorizing Users to Execute Code
Configuring Permissions at the Schema Level

Module 12: Auditing SQL Server Environments

Options for Auditing Data Access in SQL Server
Implementing SQL Server Audit
Managing SQL Server Audit

Module 13: Automating SQL Server 2008 R2 Management

Automating SQL Server Management
Working with SQL Server Agent
Managing SQL Server Agent Jobs

Module 14: Configuring Security for SQL Server Agent

Understanding SQL Server Agent Security
Configuring Credentials
Configuring Proxy Accounts

Module 15: Monitoring SQL Server 2008 R2 with Alerts and Notifications

Configuration of Database Mail
Monitoring SQL Server Errors
Configuring Operators, Alerts and Notifications

Module 16: Performing Ongoing Database Maintenance

Ensuring Database Integrity
Maintaining Indexes
Automating Routine Database Maintenance

Module 17: Tracing Access to SQL Server 2008 R2

Capturing Activity using SQL Server Profiler
Improving Performance with the Database Engine Tuning Advisor
Working with Tracing Options

Module 18: Monitoring SQL Server 2008 R2

Monitoring Activity
Capturing and Managing Performance Data
Analyzing Collected Performance Data

Module 19: Managing Multiple Servers

Working with Multiple Servers
Virtualizing SQL Server
Deploying and Upgrading Data-Tier Applications

Module 20: Troubleshooting Common SQL Server 2008 R2 Administrative Issues

SQL Server Troubleshooting Methodology
Resolving Service-related Issues
Resolving Concurrency Issues
Resolving Login and Connectivity Issues