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.
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 TasksRoutine SQL Server Administrative TasksAutomating Routine Maintenance TasksCreating AlertsTroubleshooting SQL Server AutomationAutomating 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