System Administration for SQL Server 2005

PT6012
Summary
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.
Prerequisites
Students should be able to support a Windows Server 2003 environment.
Duration
5 Days/Lecture & Lab
Audience
This course is designed for System administrators who implement and support SQL Server 2005 in an enterprise network
Topics
  • 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