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 »

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

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