Have a Question? Call Us!
1.978.223.9023
 info@eztrainings.com

SQL Server 2000 Training

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

SQL Server 2000 is a relational database management system (RDBMS) from Microsoft that’s designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handling, row processing, and declared variables.

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 File groups
  • Optimizing the Database Using File groups 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 Multi server 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


Bookmark and Share


This entry was posted on Tuesday, November 3rd, 2009 at 10:19 pm and is filed under lamp courses. The entry is tagged under , , , , . 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.

Leave a Reply