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