Home » Training Courses » Microsoft Certified Training » 2072 - Administering a Microsoft SQL Server 2000 Database Training

2072 - Administering a Microsoft SQL Server 2000 Database Training

• Book this course
• Email to a friend
• Download PDF

Course number - 2072

The Administering a Microsoft SQL Server 2000 Database training 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.

This Administering a Microsoft SQL Server 2000 Database training course is a module that can be used towards your MCSE and/or MCSA certification.

Course Objectives:

At the end of this Microsoft Administering a Microsoft SQL Server 2000 Database course participants 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.

Course Content

• Module 1: SQL Server Overview
• Module 2: Planning to Install SQL Server
• Module 3: Managing Database Files
• Module 4: Managing Security
• Module 5: Performing Administrative Tasks
• Module 6: Backing Up Databases
• Module 7: Restoring Databases
• Module 8: Monitoring SQL Server for Performance
• Module 9: Transferring Data
• Module 10: Maintaining High Availability
• Module 11: Introducing Replication

Course Prerequisites:

1. 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:

• 2151 - Microsoft Windows 2000 Network and Operating System Essentials
• 2152 - Implementing Microsoft Windows 2000 Professional and Server

2. 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:

• 1609 - Designing Data Services and Data Models

3. 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:

• 2071 - Querying Microsoft SQL Server 2000

4. Familiarity with the role of the database administrator.

SQL Server 2000 Training Course Recommended  Reading

SQL Server 2000 Administrator's Pocket Consultant by William Stanek - buy from amazon

For full course content and pre-requisites download the 2072 - Administering a Microsoft SQL Server 2000 Database Training Course PDF

Share This