Installing SQL Server 2012

• Introduction to the SQL Server Platform
• SQL Server Services and Configuration Options
• Considerations for Installing SQL Server
• Installing SQL Server 2012
• Lab : Installing SQL Server 2012

Working With Databases

• Overview of SQL Server Databases
• Creating Databases
• Using Database Files and Filegroups
• Moving Database Files
• Buffer Pool Extension
• Lab : Creating and Configuring Databases

SQL Server 2012 Recovery Models

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

Backup Of SQL Server 2012 Databases

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

Restoring SQL Server 2012 Databases

• Understanding the Restore Process
• Restoring Databases
• Working with Point-in-Time Recovery
• Restoring System Databases and Individual Files
• Lab : Restoring SQL Server Databases

Importing And Exporting Data

• Transferring Data To/From SQL Server
• Importing and Exporting Table Data
• Inserting Data in Bulk
• Deploying and Upgrading Data-tier Applications
• Lab : Importing and Exporting Data

Authenticating And Authorizing Users

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

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

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

Protecting Data By Using Encryption And Auditing

• Options for Auditing Data Access in SQL Server
• Implementing SQL Server Audit
• Managing SQL Server Audit
• Protecting Data by Using Encryption
• Lab : Using Auditing and Encryption

Automating SQL Server 2012 Management

• Automating SQL Server Management
• Working with SQL Server Agent
• Managing SQL Server Agent Jobs
• Multi-Server Management
• Lab : Automating SQL Server Management

Configuring Security For SQL Server Agent

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

Monitoring SQL Server 2012 By Using Alerts And Notifications

• Configuring Database Mail
• Monitoring SQL Server Errors
• Configuring Operators, Alerts, and Notifications
• Lab : Monitoring SQL Server by Using Alerts and Notifications

Performing Ongoing Database Maintenance

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

Tracing Access To SQL Server 2012

• Capturing Activity by Using SQL Server Profiler
• Improving Performance by Using the Database Engine Tuning Advisor
• Working with Tracing Options
• Distributed Replay
• Monitoring Locks
• Lab : Tracing Access to SQL Server

Monitoring SQL Server 2012

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