Implementing & Supporting SQL Server 2000
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Implementing & Supporting SQL Server 2000

Course Outline:
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 
- 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
 
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 to 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
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration3 days
 
£825
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).