Back to Search Results

Training Course Summary:

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 ServerTM2000. 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.

Pre-Requisites:

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.
For students who do not meet these prerequisites, the following courses provide students with the necessary knowledge and skills:
• Course 2151, Microsoft Windows 2000 Network and Operating System Essentials
• Course 2152, Implementing Microsoft Windows 2000 Professional and Server
• An understanding of basic relational database concepts, including:
• Logical and physical database design.
• Data integrity concepts.
• Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
• How data is stored in tables (rows and columns).
For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:
• Course 1609, Designing Data Services and Data Models
• Knowledge of basic Transact-SQL syntax (SELECT, INSERT, UPDATE, and DELETE statements).
For students who do not meet these prerequisites, the following course provides students with the necessary knowledge and skills:
• Course 2071, Querying Microsoft SQL Server 2000
• Familiarity with the role of the database administrator.

Training Course Overview/Content:

At the end of the 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 secure 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.

Qualifications:

This course will help the student prepare for the following Microsoft Certified Professional exam:
• Exam 70-228, System Administration for Microsoft SQL Server 2000