|
|
Overview
This
course provides students with the knowledge and skills required to
install, configure, administer, and troubleshoot the client-server
database management system of Microsoft SQL Server 2000. Course 2072 is
a revision of Course 832, System Administration for Microsoft SQL Server
7.0. The course content is being revised to reflect changes in the
product.
Audience
Candidates for this exam work in a medium to enterprise computing
environment that uses SQL Server 2000 Enterprise Edition. Candidates
have at least one year of experience implementing relational databases
in environments with the following characteristics:
• Heterogeneous databases.
• SQL Server security integrated with Windows Authentication.
• Client/server configurations of 50 to 5,000 or more users.
• Web configurations that use Microsoft Internet Information Services (IIS)
or COM+.
• Databases as large as 2 TB.
• Multiple installations of SQL Server 2000.
At
Course Completion
After completing this course, students will be able to:
• Describe SQL Server architecture.
• Plan for a SQL Server installation, and then install an instance of
SQL Server.
• Manage files and databases, including determining resource
requirements.
• Choose a login security method, configure login security, plan and
implement database permissions, and describe how to help protect SQL
Server in an enterprise network.
• Perform and automate administrative tasks and create custom
administrative tools.
• Back up databases and implement a backup strategy.
• Restore databases.
• Monitor and optimize SQL Server performance.
• Transfer and migrate data into databases.
• Maintain the high availability of SQL Server.
• Describe how to replicate data from one SQL Server to another.
Prerequisites
Before attending this course, students must have:
Experience using the Microsoft Windows 2000 operating system to:
• Connect clients running Windows 2000 to networks and the Internet.
• Configure the Windows 2000 environment.
• Create and manage user accounts.
• Manage access to resources by using groups.
• Configure and manage disks and partitions, including disk striping and
mirroring.
• Manage data by using NTFS.
• Implement Windows 2000 security.
• Optimize performance in Windows 2000.
Exam
Exam 70-228- Installing, Configuring, and Administering Microsoft SQL
Server 2000 Enterprise Edition
|
|
Choose below for more information |
|
Hands
on Training |
Installing, Configuring and Administering SQL Server Enterprise
Edition
32 Hours
Course: NW522
Course Outline
Register Today
Approved for
VA Benefits and G.I. Bills
Earn
College Credits Call for details
Request On-Site Training Proposal
|
