 |
|
|
SQL Server 2000 Administration Workshop with SQL 2005 variations
4-day course.
Course Summary:
- SQL Server Overview
- SQL Server Security
- Methods of Installing SQL Server
- Configuring SQL Server Enterprise Manager
- Troubleshooting
- Managing Database Files
- Creating & Managing Databases
- Optimising the Database Using Filegroups
- Implementing ab Authentication Mode
- Assigning Logins & Permissions to Users & Roles
- Managing Security Within SQL Server
- Managing SQL Server Security in the Enterprise
- Performing Administrative Tasks
- Configuration Tasks Routinge SQL Server Administrative Tasks
- Automating Routine Maintenance Tasks
- Troubleshooting SQL Server Automation
- Backing Up Databases
- Setting and Changing a Database Recovery Model
- SQL Server Backup
- Restoring Databases
- Automating Routine Maintenance TasksMonitoring SQL Server for Performance
- Performance Monitoring & Tuning
- Tools for Monitoring SQL Server
- Transferring Data
- Transforming Data with DTS
- Maintaining High Availability
- Standby Servers & Log Shipping
- Introducing Replication
- Introduction to SQL Server Replication
|
 |
|
|
