System Administration for SQL Server 2005

This course is designed to provide students with the knowledge and skills required to install, configure, administer, and troubleshoot the Microsoft SQL Server 2005 client-server database management system.
Students should be able to support a Windows Server 2003 environment.
5 Days/Lecture & Lab
This course is designed for System administrators who implement and support SQL Server 2005 in an enterprise network
  • Introduction to SQL Server Administration
  • Installing and Configuration
  • Managing Databases and Files
  • Managing User Accounts
  • Managing Login Security
  • Assigning User Permissions
  • Backing Up System and User Databases
  • Restoring System and User Databases
  • Importing, Exporting, and Distributing Data
  • Scheduling Tasks and Setting Alerts
  • Monitoring and Tuning
  • Best Practices for Performance and Recoverability

Related Scheduled Courses