Microsoft
SQL Server 2000 Administration
Course
Description
SQL Server 2000 is one of the most widely
used database engines. It is a robust, flexible and
scalable solution that integrates well with Microsoft
core technologies such as Windows 2000. It is a flagship
RDBMS that powers many Internet and e-commerce sites.
The purpose of this course is to provide students
with the knowledge and skills required to install,
configure, administer, and troubleshoot Microsoft
SQL Server™ 2000. This course provides extensive
hands-on experience in the installation, administration
and optimization of SQL Server 2000.
Intended
Audience
This course is valuable for database administrators
migrating to SQL 2000, e-commerce architects and
students preparing for Microsoft Certified Professional
Exam. Anyone planning to move from desktop database
systems like MS Access will benefit from this course.
Experience using the Microsoft Windows® 2000
and familiarity with SQL is assumed.
Objectives
Upon completion of this course, students will be
able to understand:
- SQL Server architecture.
- SQL Server installation
- Managing files and databases and determining
resource requirements.
- Login security method, configuring login security,
planning and implementing database permissions.
- Automating administrative tasks and creating
custom administrative tools.
- Backing up and restoring databases and implementing
a backup strategy.
- Monitoring and optimizing SQL Server performance.
- Transfer and migration of data into databases.
- Maintaining high availability of SQL Server.
- Replication of data from one SQL Server to
another.
|
