This five-day
instructor-led course provides students with product knowledge and
skills needed to maintain a Microsoft SQL Server 2005 database. The
course focuses on teaching individuals how to use SQL Server 2005
product features and tools related to maintaining a database.
Prerequisites
Before attending this course, students
must have met at least one of the following
·
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.
In addition, it is recommended, but not
required, that students have completed:
·
Course 2278, Writing
Queries Using Microsoft SQL Server 2005 Transact-SQL.
·
Course 2279, Implementing a
Microsoft SQL Server Database
Skills Gained
At the end of the course, students will be
able to:
-
Install and configure
SQL Server 2005
-
Manage database files
-
Manage security
-
Perform administrative
task
-
Backup databases
-
Restore databases
-
Monitor SQL Server
-
Troubleshoot SQL Server
-
Transfer data
-
Maintain high
availability
