This
five-day
instructor-led course provides students with product knowledge and
skills needed to implement a Microsoft SQL Server 2005 database. The
course focuses on teaching individuals how to use SQL Server 2005
product features and tools related to implementing a database.
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
