Computer Technology

   >

Computer Technology 

   >

Administering Microsoft SQL Server Database

Administering Microsoft SQL Server Database

Duration (Days)

5

Overview

This course is designed to equipped participants with the skills to maintain Microsoft SQL Server 2014 database. They will learn the features and tools related to maintaining a database. They will learn about the new features in SQL server 2014 and the capabilities across the SQL server data platform.

Objectives
  • Install SQL Server 2014

  • Manage core database administration tasks and tools

  • Implement a backup strategyRestore databases from backups

  • Monitor and trace SQL Server

  • Import and export data management

  • Database maintenance

  • SQL Server maintenance with SQL Server Agent Jobs

  • Configure mail, alerts and notifications

Course Outline
  • SQL Server 2014 database administration

  • SQL Server installation

  • SQL Server configuration

  • Databases and storage

  • Backup strategy

  • SQL Server 2014 databases

  • Import and export data

  • SQL Server monitoring

  • SQL Server tracing

  • SQL Server security

  • Data access and encrypting data

  • Database maintenance

  • SQL Server 2014 automation

  • SQL Server 2014 alerts and notifications