Introduction to SQL Server 2008 R2 and its Toolset
o Introduction to SQL Server Platform
o Working with SQL Server Tools
o Configuring SQL Server Services
Preparing Systems for SQL Server 2008 R2
o Overview of SQL Server 2008 R2 Architecture
o Planning Server Resource Requirements
o Pre-installation Testing for SQL Server 2008 R2
Installing & Configuring SQL Server 2008 R2
o Preparing to Install SQL Server 2008 R2
o Installing SQL Server 2008 R2
o Upgrading and Automating Installation
Working with Databases
o Overview of SQL Server Databases
o Working with Files and Filegroups
o Moving Database Files
Understanding SQL Server 2008 R2 Recovery Models
o Backup Strategies
o Understanding SQL Server Transaction Logging
o Planning a SQL Server Backup Strategy
Backup of SQL Server 2008 R2 Databases
o Backing up Databases and Transaction Logs
o Managing Database Backups
o Working with Backup Options
Restoring SQL Server 2008 R2 Databases
o Understanding the Restore Process
o Restoring Databases
o Working with Point-in-time Recovery
o Restoring System Databases and Individual Files
Importing and Exporting Data
o Transferring Data To/From SQL Server 2008 R2
o Importing & Exporting Table Data
o Inserting Data in Bulk
Authenticating and Authorizing Users
o Authenticating Connections to SQL Server
o Authorizing Logins to Access Databases
o Authorization Across Servers
Assigning Server and Database Roles
o Working with Server Roles
o Working with Fixed Database Roles
o Creating User-defined Database Roles
Authorizing Users to Access Resources
o Authorizing User Access to Objects
o Authorizing Users to Execute Code
o Configuring Permissions at the Schema Level
Auditing SQL Server Environments
o Options for Auditing Data Access in SQL Server
o Implementing SQL Server Audit
o Managing SQL Server Audit
Automating SQL Server 2008 R2 Management
o Automating SQL Server Management
o Working with SQL Server Agent
o Managing SQL Server Agent Jobs
Configuring Security for SQL Server Agent
o Understanding SQL Server Agent Security
o Configuring Credentials
o Configuring Proxy Accounts
Monitoring SQL Server 2008 R2 with Alerts and Notifications
o Configuration of Database Mail
o Monitoring SQL Server Errors
o Configuring Operators, Alerts and Notifications
Performing Ongoing Database Maintenance
o Ensuring Database Integrity
o Maintaining Indexes
o Automating Routine Database Maintenance
Tracing Access to SQL Server 2008 R2
o Capturing Activity using SQL Server Profiler
o Improving Performance with the Database Engine Tuning Advisor
o Working with Tracing Options
Monitoring SQL Server 2008 R2
o Monitoring Activity
o Capturing and Managing Performance Data
o Analyzing Collected Performance Data
Managing Multiple Servers
o Working with Multiple Servers
o Virtualizing SQL Server
o Deploying and Upgrading Data-Tier Applications
Troubleshooting Common SQL Server 2008 R2 Administrative Issues
o SQL Server Troubleshooting Methodology
o Resolving Service-related Issues
o Resolving Concurrency Issues
o Resolving Login and Connectivity Issues
