M.O.C. Maintaining a Microsoft SQL Server 2008 R2 Database

M.O.C. Maintaining a Microsoft SQL Server 2008 R2 Database

M.O.C. Maintaining a Microsoft SQL Server 2008 R2 Database

After completing this course, students will be able to:

* Explain SQL Server 2008 R2 architecture, resources requirements and perform pre-checks of I/O subsystems
* Plan, install and configure SQL Server 2008 R2
* Backup and restore databases
* Import and export wizards and explain how they relate to SSIS
* Use BCP and BULK INSERT to import data
* Manage security
* Assign, configure fixed database roles and create and assign user defined database roles
* Configure and assign permissions
* Implement SQL Server 2008 R2 Audits
* Manage SQL Server 2008 R2 Agent and Jobs
* Configure database mails, alerts and notifications
* Maintain databases
* Configure SQL Profiler Traces and Use the Database Tuning Advisor
* Monitor data by using Dynamic Management Views
* Execute multi-server queries and configure a central management server
* Deploy a data-tier-application
* Troubleshoot common issues

M.O.C. Maintaining a Microsoft SQL Server 2008 R2 Database