SQL DBA Training

Posted by admin - 03/11/09 at 10:11 pm

Microsoft SQL Server 2000 Feature Overview and History

• What is Microsoft SQL Server?
• Client/Server Architecture
• Microsoft SQL Server – A Brief History
• SQL Server 2000 a Review of New Features

Installation and Upgrading of Microsoft SQL Server 2000

• Pre-Installation Check List
• Installing Microsoft SQL Server 2000
• SQL Server Components
• Upgrading and Compatibility Issues
• Service Packs

Data Storage and Management

• Creating Databases and Logs
• Using File groups
• Managing Database Availability
• Managing Database Size

Importing and Exporting Data with DTS

• Data Transformation Services (DTS)
• Modifying DTS Packages
• DTS Transformations
• BCP the Lowest Common Denominator
• Using Backup and Restore to Move Data

Securing Access to SQL Server Databases

• SQL Server 2000 Security Overview and Terminology
• Windows Authentication Mode
• Fixed Server and Database Roles
• User-Defined Roles
• Database Permissions
• Application Roles

Backing up and Restoring SQL Server Databases

• Planning Fault Tolerance for SQL Server 2000
• Backup Overview
• SQL Server 200’s Backup Mechanism
• Backup Types
• Backup Destinations
• Performing the Backup
• Restoring Databases from Backup
• Standby Servers and the Log Shipping Feature
• Restoring System Databases

Managing User Rights

• Defining roles within a database
• Assigning Rights to users and roles

Scheduling Jobs in SQL Server 2000

• Automation Overview
• Setting up SQL Mail
• Setting up Operators in Microsoft SQL Server
• Jobs, Events and Alerts
• Types of Job
• Creating User-Defined Error Messages
• Setting Up Alerts
• Multi-Server Jobs

Data Replication in Microsoft SQL Server 2000

• Replication Overview
• Replication Topologies
• Microsoft SQL Server 2000 Replication: How it Works
• Setting Up Replication

Troubleshooting, Monitoring and Optimizing

• Troubleshooting SQL Server
• Monitoring SQL Server
• Optimizing Microsoft SQL Server 2000
• Hardware Optimization – Memory, CPUs and Disks
• SQL Server Configuration options
• Optimal Database Design
• Client-Side Optimizations

This entry was posted on Tuesday, November 3rd, 2009 at 10:09 pm and is filed under lamp courses. The entry is tagged under DBA Microsoft SQL Server, Microsoft SQL Training, MS SQL DBA, SQl DBA, SQL Server DBA, SQL Training Online. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.