Microsoft SQL Server 2012: Database Administration

Course details

Lesson 1:

• Identifying the SQL Server Platform and Tools
• Overview of SQL Server Features Create Filegroups and Partitions

Lesson 2:

• Deploying SQL Server Install SQL
• Server Migrate SQL Server From a Previous Version

Lesson 3:

• Configuring SQL Server Configure
• Server Properties Configure Memory and CPU Configure Database Mail

Lesson 4:

• Managing Databases in SQL Server 2012
• Create a Contained Database
• Configure Database Options

Lesson 5:

• Managing SQL Server Security
• Configure Server Security
• Create Server Roles Configure Database Security

Lesson 6:

• Implementing Advanced Security Settings Create Certificate-Based Logins
• Apply Auditing and Policy-Based Management Strategies

Lesson 7:

• Applying Encryption and Compression
• Apply Encryption on Databases
• Compress a Database Table

Lesson 8:

• Working with Indexes and Log Files
• Work with Full Text Indexes
• Configure Advanced Storage and Indexing ]
• Settings Configure Log Files

Lesson 9: 

• Working with Backup and Restore
• Perform a Backup
• Restore a Database
• Import and Export Data
• Configure the SQL Server Agent 

Lesson 10:

• Implementing High Availability
• Work with Clustering
• Work with Replication
• Work with Mirroring and AlwaysOn
• Work with Central Management Servers

Lesson 11:

• Optimizing Server Performance
• Manage Server Performance
• Optimize Indexes

Lesson 12:

• Troubleshooting Issues and Recovering Databases
• Troubleshoot Database Issues
• Perform a Database Recovery

Lesson 13:

• Performing Advanced Database Management Tasks
• Manage Database Infrastructure
• Configure SSI