SQLSP4 - Microsoft SQL Server 2012: Database Administration (Exam 70-462) (Self Paced)

Identifying the SQL Server Platform and Tools, Overview of SQL Server Features, Create Filegroups and Partitions, Deploying SQL Server, Install SQL Server, Migrate SQL Server From a Previous Version, Configuring SQL Server, Configure Server Properties, Configure Memory and CPU, Configure Database Mail, Managing Databases in SQL Server 2012, Create a Contained Database, Configure Database Options, Managing SQL Server Security, Configure Server Security, Create Server Roles, Configure Database Security, Implementing Advanced Security Settings, Create Certificate-Based Logins, Apply Auditing and Policy-Based Management Strategies, Applying Encryption and Compression, Apply Encryption on Databases, Compress a Database Table, Working with Indexes and Log Files, Work with Full Text Indexes, Configure Advanced Storage and Indexing Settings, Configure Log Files, Working with Backup and Restore, Perform a Backup, Restore a Database, Import and Export Data, Configure the SQL Server Agent, Implementing High Availability, Work with Clustering, Work with Replication, Work with Mirroring and AlwaysOn, Work with Central Management Servers, Optimizing Server Performance, Manage Server Performance, Optimize Indexes, Troubleshooting Issues and Recovering Databases, Troubleshoot Database Issues, Perform a Database Recovery, Performing Advanced Database Management Tasks, Manage Database Infrastructure, Configure SSIS. Course length: 5 days.