This 40 hours instructor-led course provides students with product knowledge and skills needed to maintain a Microsoft SQL ServerT 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database. This course also a required course for the MCTS certification 70-431.
Course Objectives
After completing this course, students will be able to:
•Install and configure SQL Server 2005.
•Manage database files.
•Manage security.
•Perform administrative tasks.
•Back up databases.
•Restore databases.
•Monitor SQL Server.
•Troubleshoot SQL Server.
•Transfer data.
•Maintain high availability.
Prerequisites
Before attending this course, students must have:
•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.
Course Benefits
This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for maintaining a database
