SQL Server 2000
Training
This SQL course is also an
elective for the MCSE as well as MCDBA
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
Performing
Administrative Tasks
• Configuration Tasks Routine SQL Server Administrative Tasks
Automating Routine Maintenance Tasks Creating Alerts
Troubleshooting SQL Server Automation Automating Multiserver
Jobs
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
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
Maintaining High
Availability
• Introduction to Availability
• Increasing Availability Using Failover Clustering
• Standby Servers and Log Shipping
Introducing
Replication
• Introduction to Distributed Data
• Introduction to SQL Server Replication
• SQL Server Replication Agents
• SQL Server Replication Types
• Physical Replication Models
This course may also available as an
online course.
Click here
to see our online courses.