| Dates for this class: |
| No dates are available for this class. |
| Course Details [choose new course] [printable version] |
| Administering a Microsoft SQL Server 2000 Database (MOC2072) |
| Course Number: MOC2072 |
| Category: Database & Collaboration Tools |
| Duration: 5.00 days |
Description
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.
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.
Certification
This course will help the student prepare for the following Microsoft Certified Professional exam:
- Exam 70-228, System Administration for Microsoft SQL Server 2000
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
- 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).
- Knowledge of basic Transact-SQL syntax (SELECT, INSERT, UPDATE, and DELETE statements).
- Familiarity with the role of the database administrator.
Outline
- Module 1: SQL Server Overview
- The following topics are covered in this module:
- What Is SQL Server
- SQL Server Integration
- SQL Server Databases
- SQL Server Security
- Working with SQL Server
- The following lab is covered in this module:
- SQL Server Overview
- The following topics are covered in this module:
- Module 2: Planning to Install SQL Server
- The following topics are covered in this module:
- Hardware Installation Considerations
- SQL Server 2000 Editions
- Software Installation Considerations
- Methods of Installing SQL Server
- Verifying the Installation
- Configuring SQL Server Enterprise Manager
- Troubleshooting
- The following lab is covered in this module:
- Installing SQL Server
- The following topics are covered in this module:
- Module 3: Managing Database Files
- The following topics are covered in this module:
- 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
- The following lab is covered in this module:
- Managing Database Files
- The following topics are covered in this module:
- Module 4: Managing Security
- The following topics are covered in this module:
- 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
- The following labs are covered in this module:
- Managing Security
- Managing Permissions
- Managing Application Security
- The following topics are covered in this module:
- Module 5: Performing Administrative Tasks
- The following topics are covered in this module:
- Configuration Tasks
- Routine SQL Server Administrative Tasks
- Automating Routine Maintenance Tasks
- Creating Alerts
- Troubleshooting SQL Server Automation
- Automating Multiserver Jobs
- The following labs are covered in this module:
- Configuring SQL Server
- Creating Jobs and Operators
- Creating Alerts
- The following topics are covered in this module:
- Module 6: Backing Up Databases
- The following topics are covered in this module:
- 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
- The following lab is covered in this module:
- Backing Up Databases
- The following topics are covered in this module:
- Module 7: Restoring Databases
- The following topics are covered in this module:
- SQL Server Recovery Process
- Preparing to Restore a Database
- Restoring Backups
- Restoring Databases from Different Backup Types
- Restoring Damaged System Databases
- The following lab is covered in this module:
- Restoring Databases
- The following topics are covered in this module:
- Module 8: Monitoring SQL Server for Performance
- The following topics are covered in this module:
- Why to Monitor SQL Server
- Performance Monitoring and Tuning
- Tools for Monitoring SQL Server
- Common Monitoring and Tuning Tasks
- The following lab is covered in this module:
- Monitoring SQL Server
- The following topics are covered in this module:
- Module 9: Transferring Data
- The following topics are covered in this module:
- Introduction to Transferring Data
- Tools for Importing and Exporting Data in SQL Server
- Introduction to DTS
- Transforming Data with DTS
- The following lab is covered in this module:
- Transferring Data
- The following topics are covered in this module:
- Module 10: Maintaining High Availability
- The following topics are covered in this module:
- Introduction to Availability
- Increasing Availability Using Failover Clustering
- Standby Servers and Log Shipping
- The following lab is covered in this module:
- Automating the Maintenance of a Standby Server
- The following topics are covered in this module:
- Module 11: Introducing Replication
- The following topics are covered in this module:
- Introduction to Distributed Data
- Introduction to SQL Server Replication
- SQL Server Replication Agents
- SQL Server Replication Types
- Physical Replication Models
- The following lab is covered in this module:
- Implementing Replication
- The following topics are covered in this module: