Administering Microsoft SQL Server 2012 Databases

• Lab : Monitoring SQL Server by Using Alerts and Notifications º Configuring Database Mail. º Implementing Operators and Notifications º

 Managing Database Integrity  Managing Index Fragmentation  Implementing a Maintenance Plan After completing this module, you will be able to:.  Ensure database

 Managing Database Integrity  Managing Index Fragmentation  Implementing a Maintenance Plan After completing this module, you will be able to:.  Ensure database

• May include but not limited to: configure server security; secure the SQL Server using Windows Account / SQL Server accounts, server roles; create log in accounts; manage access

Module 12: Automating SQL Server 2014 Management This module describes how to use SQL Server Agent to automate jobs, how to configure security contexts for jobs, and how to

After completing this module, students will be able to:  Explain SQL Server Agent security. Module 15: Monitoring SQL Server 2012 with Alerts and Notifications This module covers

Module 13: Monitoring SQL Server 2014 by Using Alerts and Notifications This module covers the configuration of database mail, alerts, and

 Work with fixed server roles, user-defined server roles, fixed database roles and user-defined database roles..  Work with permissions and the assignment