Below the the course details:

Planning and Installing SQL Server

Configuring, Managing and Best Practices SQL Server Instances

SQL Server Agent, Backup, and Restore

Handling Database Corruption

Migrating, Upgrading, Importing, and Exporting

SQL Server Security

Troubleshooting SQL Server Security

High-Availability and Disaster Recovery

- Log-Shipping

- Replication

- Mirroring

- AlwaysOn

- Cluster

Troubleshooting SQL Server 2012

- Working with Performance Monitor

- Working with SQL Server Profiler

- Working with Activity Monitor

Performance Tuning

- Identifying Bottlenecks

- Disk Usage

- Memory Usage

- CPU Utilization

- TempDB

- Indexes and Concurrency

Implementing and Maintaining Indexes

Identifying and Resolving Concurrency Problems

Query Optimization

- Best Practices

- Optimization

Advance Features

- In-Memory OLTP

- Cardinality Estimator

- Buffer Pool Extension

- Query Store

- Database Cloning