 |  |  |  |  |  |
| Course | Implementing & Supporting Microsoft SQL Server 2000 for Windows | |
| Duration | 5 Days | |
| Content | SQL Server Overview | What
is SQL Server SQL Server Integration SQL Server Databases SQL Server Security Working with SQL Server |
| 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 |
|
| Managing Database Files | Introduction
to Data Structures Creating Databases Managing Databases Placing Database Files and Logs Optimising the Database Using Hardware-based RAID Optimising the Database Using Filegroups Optimising the Database Using Filegroups with Hardware-based RAID Capacity Planning Performance Considerations |
|
| 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 |
|
| Restoring Databases | SQL
Server Recovery Process Preparing to Restore a Database Restoring Backups Restoring Databases from Different Backup Types Restoring Damaged System Databases |
|
| Monitoring SQL Server for Performance | Why
you Monitor SQL Server Performance Monitoring and Tuning Tools for Monitoring SQL Server Common Monitoring and Tuning Tasks |
|
| Transferring Data | Introduction
to Transferring Data Tools for Importing and Exporting Data in SQL Server Introduction to DTS Transforming Data with DTS |
|
| Replication | Introduction
to Distributed Data Introduction to SQL Server Replication SQL Server Replication Agents SQL Server Replication Types Physical Replication Models |
|