6231 Maintaining a Microsoft SQL Server 2008 R2 Database

This 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.

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

• Introduction to SQL Server Platform
• Working with SQL Server Tools
• Configuring SQL Server Services
• Lab : Introduction to SQL Server 2008 R2 and its Toolset

Lesson 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
• Lab : Preparing Systems for SQL Server 2008 R2

Lesson 3: Installing and Configuring SQL Server 2008 R2

• Preparing to Install SQL Server 2008 R2
• Installing SQL Server 2008 R2
• Upgrading and Automating Installation
• Lab : Installing and Configuring SQL Server 2008 R2

Lesson 4: Working with Databases

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

Lesson 5: Understanding SQL Server 2008 R2 Recovery Models

• Backup Strategies
• Understanding SQL Server Transaction Logging
• Planning a SQL Server Backup Strategy
• Lab : Understanding SQL Server 2008 R2 Recovery Models

Lesson 6: Backup of SQL Server 2008 R2 Databases

• Backing up Databases and Transaction Logs
• Managing Database Backups
• Working with Backup Options
• Lab : Backup of SQL Server 2008 R2 Databases

Lesson 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
• Lab : Restoring SQL Server 2008 R2 Databases

Lesson 8: Importing and Exporting Data

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

Lesson 9: Authenticating and Authorizing Users

• Authenticating Connections to SQL Server
• Authorizing Logins to Access Databases
• Authorization Across Servers
• Lab : Authenticating and Authorizing Users

Lesson 10: Assigning Server and Database Roles

• Working with Server Roles
• Working with Fixed Database Roles
• Creating User-defined Database Roles
• Lab : Assigning Server and Database Roles

Lesson 11: Authorizing Users to Access Resources

• Authorizing User Access to Objects
• Authorizing Users to Execute Code
• Configuring Permissions at the Schema Level
• Lab : Authorizing Users to Access Resources

Lesson 12: Auditing SQL Server Environments

• Options for Auditing Data Access in SQL Server
• Implementing SQL Server Audit
• Managing SQL Server Audit
• Lab : Auditing SQL Server Environments

Lesson 13: Automating SQL Server 2008 R2 Management

• Automating SQL Server Management
• Working with SQL Server Agent
• Managing SQL Server Agent Jobs
• Lab : Automating SQL Server 2008 R2 Management

Lesson 14: Configuring Security for SQL Server Agent

• Understanding SQL Server Agent Security
• Configuring Credentials
• Configuring Proxy Accounts
• Lab : Configuring Security for SQL Server Agent

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

• Configuration of Database Mail
• Monitoring SQL Server Errors
• Configuring Operators, Alerts and Notifications
• Lab : Monitoring SQL Agent Jobs with Alerts and Notifications

Lesson 16: Performing Ongoing Database Maintenance

• Ensuring Database Integrity
• Maintaining Indexes
• Automating Routine Database Maintenance
• Lab : Ongoing Database Maintenance

Lesson 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
• Lab : Tracing Access to SQL Server 2008 R2

Lesson 18: Monitoring SQL Server 2008 R2

• Monitoring Activity
• Capturing and Managing Performance Data
• Analyzing Collected Performance Data
• Lab : Monitoring SQL Server 2008 R2

Lesson 19: Managing Multiple Servers

• Working with Multiple Servers
• Virtualizing SQL Server
• Deploying and Upgrading Data-Tier Applications
• Lab : Managing Multiple Servers

Lesson 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
• Lab : Troubleshooting Common Issues

• Memphis, TN - April 23, 2012
• Appleton, WI - April 23, 2012
• Anaheim, CA - April 30, 2012
• Orlando, FL - May 7, 2012
• Greensboro, NC - May 7, 2012
• Las Vegas, NV - May 7, 2012
• Sacramento, CA - May 7, 2012
• Reno, NV - May 7, 2012
• Wauwatosa, WI - May 7, 2012
• Madison, WI - May 7, 2012
• Charleston, SC - May 14, 2012
• Atlanta, GA - May 14, 2012
• Columbia, SC - May 14, 2012
• Greenville, SC - May 14, 2012
• Charleston, WV - May 14, 2012
• Washington, DC - May 14, 2012
• East Lansing, MI - May 14, 2012
• Tampa, FL - May 21, 2012
• Westerville, OH - June 4, 2012
• Anaheim, CA - June 11, 2012
• Charleston, SC - June 18, 2012
• Columbia, SC - June 18, 2012
• Greenville, SC - June 18, 2012
• Greensboro, NC - June 18, 2012
• Las Vegas, NV - June 18, 2012
• Charleston, WV - June 18, 2012
• Sacramento, CA - June 18, 2012
• Reno, NV - June 18, 2012
• Mechanicsburg, PA - June 18, 2012
• Tucson, AZ - June 25, 2012