> > 20462-ADVANCED

Administering Microsoft SQL Server 2014 Databases MOC On-Demand Advanced


This hands-on course will teach you the skills you need to best maintain a Microsoft SQL Server 2014 database. You will learn how to use SQL Server 2014 product features and tools related to maintaining a database.


Quién debería asistir

  • Database Administrators
  • Application Developers that fetch data from SQL Server databases


  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of Transact-SQL
  • Working knowledge of relational databases
  • Some experience with database design
  • Completed Querying Microsoft SQL Server 2014 (MOC 20461) or have equivalent knowledge

Objetivos del curso

  • Describe core database administration tasks and tools.
  • Install and configure SQL Server 2014.
  • Configure SQL Server databases and storage.
  • Plan and implement a backup strategy.
  • Restore databases from backups.
  • Import and export data.
  • Monitor SQL Server.
  • Trace SQL Server activity.
  • Manage SQL Server security.
  • Audit data access and encrypt data.
  • Perform ongoing database maintenance.
  • Automate SQL Server maintenance with SQL Server Agent Jobs.
  • Configure Database Mail, alerts and notifications.
E-Learning MOC on Demand
Precio (sin incluir impuestos)
  • US$ 950,-

Subscription duration: 90 días
Grace period: 3 months