AUDIENCE:   System administrators and database administrators who implement and manage a Microsoft SQL Server 2000 RDBMS. Database developers who need to know more about the administration of SQL Server 2000. This course gives an essential grounding for the Microsoft examination 70-028 Administering Microsoft SQL Server 2000. PREREQUISITES:   Delegates should have a good working knowledge of relational databases and be competent in SQL. Delegates should have a good working knowledge of Windows 2000/2003 Server. Attendance on our Windows 2000/2003 Server Administration class would achieve this. DURATION:   3 days. Hands on. OBJECTIVES:   The course will allow delegates to identify and configure all major aspects of a Microsoft SQL Server 2000 RDBMS. It shows how to install and configure an SQL Server, create and manage databases and database devices, backup and restore SQL databases, import and export data, implement automated tasks and optimise the SQL server. COURSE CONTENT:   SQL Server Overview What is Microsoft SQL Server? Client/Server Architecture Microsoft SQL Server - A Brief History SQL Server 2000 Review of 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 Datastorage & Management Creating Databases and Logs Using Filegroups Managing Database Size and Availability Importing and Exporting data using DTS Data Transformation Services 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 Automation Overview Setting up SQLMail 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 MS SQL Server 2000 Replication Overview Replication Topologies Microsoft SQL Server 2000 Replication: How it Works Setting Up Replication Troubleshooting, Monitoring & Optimising Troubleshooting SQL Server Monitoring SQL Server Optimising Microsoft SQL Server 2000 Hardware Optimisation - Memory, CPUs and Disks SQL Server Configuration options Optimal Database Design Client-Side Optimisations