Administering SQL Server 2014 Databases (Basic)

This course is preparation for the 70-462 Administering SQL Server 2012 exam. This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2012 database, and focuses on teaching students how to use SQL Server 2012 product features and tools related to maintaining a database.

• Lesson 1: Identifying the SQL Server Platform
• Lesson 2: Deploying SQL Server
• Lesson 3: Configuring SQL Server
• Lesson 4: Managing Databases in SQL Server 2012
• Lesson 5: Managing SQL Server Security
• Lesson 6: Implementing Advanced Security Settings
• Lesson 7: Applying Encryption and Compression
• Lesson 8: Working with Indexes and Log Files
• Lesson 9: Working with Backup and Restore
• Lesson 10: Implementing High Availability
• Lesson 11: Optimizing Server Performance
• Lesson 12: Troubleshooting Issues and Recovering Databases
• Lesson 13: Performing Advanced Database Management Tasks