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

|
 |
|
 |
Course
Objectives
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 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.

|
 |
|
 |
Microsoft Certified Professional Exams
This course will help the student prepare for the following Microsoft Certified Professional exam:

|
 |
|
 |
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.
For students who do not meet these prerequisites, the following courses provide students with the necessary knowledge and skills:
- 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:
- 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:
- Familiarity with the role of the database administrator.

|
 |
|
 |
Course Outline
Module 1: SQL Server Overview
- What Is SQL Server
- SQL Server Integration
- SQL Server Databases
- SQL Server Security
- Working with SQL Server
Module 2: Planning to Install SQL Server
- Hardware Installation Considerations
- SQL Server 2000 Editions
- Software Installation Considerations
- Methods of Installing SQL Server
- Verifying the Installation
- Configuring SQL Server Enterprise Manager
- Troubleshooting
Module 3: Managing Database Files
- Introduction to Data Structures
- Creating Databases
- Managing Databases
- Placing Database Files and Logs
- Optimizing the Database Using Hardware-based RAID
- Optimizing the Database Using Filegroups
- Optimizing the Database Using Filegroups with Hardware-based RAID
- Capacity Planning
- Performance Considerations
Module 4: Managing Security
- Implementing an Authentication Mode
- Assigning Logins to Users and Roles
- Assigning Permissions to Users and Roles
- Managing Security Within SQL Server
- Managing Application Security
- Managing SQL Server Security in the Enterprise
Module 5: Performing Administrative Tasks
- Configuration Tasks Routine SQL Server Administrative Tasks Automating Routine Maintenance Tasks Creating Alerts Troubleshooting SQL Server Automation Automating Multiserver Jobs
Module 6: Backing Up Databases
- Preventing Data Loss
- Setting and Changing a Database Recovery Model
- SQL Server Backup
- When to Back Up Databases
- Performing Backups
- Types of Backup Methods
- Planning a Backup Strategy
- Performance Considerations
Module 7: Restoring Databases
- SQL Server Recovery Process
- Preparing to Restore a Database
- Restoring Backups
- Restoring Databases from Different Backup Types
- Restoring Damaged System Databases
Module 8: Monitoring SQL Server for Performance
- Why to Monitor SQL Server
- Performance Monitoring and Tuning
- Tools for Monitoring SQL Server
- Common Monitoring and Tuning Tasks
Module 9: Transferring Data
- Introduction to Transferring Data
- Tools for Importing and Exporting Data in SQL Server
- Introduction to DTS
- Transforming Data with DTS
Module 10: Maintaining High Availability
- Introduction to Availability
- Increasing Availability Using Failover Clustering
- Standby Servers and Log Shipping
Module 11: Introducing Replication
- Introduction to Distributed Data
- Introduction to SQL Server Replication
- SQL Server Replication Agents
- SQL Server Replication Types
- Physical Replication Models
|