CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS6231 - Maintaining a Microsoft SQL Server 2008 Database

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

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 for a printer-friendly version of this page

Upcoming classes

Number	Class Date	Location	Length	Cost	Sign up
MS6231	Jun 11, 2012 - Jun 15, 2012	Bloomington	5 days	$2095.00	Register
MS6231	Aug 20, 2012 - Aug 24, 2012	Springfield	5 days	$2095.00	Register

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