Administering SQL Server Database

Course 20-462 C: Administering Microsoft SQL Server Database

Jump to Course:
  • Course Name: Administering SQL Server Database
  • Course ID: 20-462
  • Related Exams: 70-462
  • Duration: 40 Hours
  • Course Fees: 2000
Download Course Outline Reserve My Seat Now Pay online

Course Overview

This course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Course Outline

  • Module 1: Introduction to SQL Server 2014 Database Administration
  • Module 2: Installing and Configuring SQL Server 2014
  • Module 3: Working with Databases and Storage
  • Module 4: Planning and Implementing a Backup Strategy
  • Module 5: Restoring SQL Server 2014 Databases
  • Module 6: Importing and Exporting Data
  • Module 7: Monitoring SQL Server 2014
  • Module 8: Tracing SQL Server Activity
  • Module 9: Managing SQL Server Security
  • Module 10: Auditing Data Access and Encrypting Data
  • Module 11: Performing Ongoing Database Maintenance
  • Module 12: Automating SQL Server 2014 Management
  • Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications