SUMMARY:   The course is designed for administrators, database designers and system engineers. It concentrates mainly on the administrative features of SQL Server 2000 with some input on the T-SQL language. PREREQUISITES:   No previous knowledge of the program is assumed although a working knowledge of Windows 2000 Server and Professional will be useful. DURATION:   5 Days COURSE CONTENT:   SQL Server 2000 Overview SQL Server and Windows 2000 Client/Server and SQL Server Multiprocessing Versus Multithreaded Database Building Fundamentals The Relational Database Tables, Columns, and Rows Installing SQL Server 2000 Operating System Requirements Hardware Requirements Required User Accounts Installing Troubleshooting Setup Client Connections SQL Server Structure Database Creation Database Objects SQL Server Components Processes Files Databases Log Files Startup and Shutdown SQL Server Services Troubleshooting Startup SQL Server Error Log Named Pipes Planning and Managing Security Security Windows NT Authentication SQL Server Authentication Roles Permissions System Data Consistency and Concurrency Statements and Transactions Locks for Consistency Transaction Isolation Level Managing Database Space Planning a Database Expanding Shrinking Deleting Data Integrity Entity Integrity Domain Integrity Domain Rules Datatypes Referential Integrity User-defined Integrity Data Consistency and Concurrency Statements and Transactions Locks for Consistency Transaction Isolation Level Transferring Data Planning Data Transfer Where Is the Data Now? What Kind of Data? Transforming Versus Inserting Data Methods for Transferring Data SELECT INTO Statements IMPORTING DATA WITH DTS Exporting Data with DTS Scrubbing and Validating Data Creating a Data Warehouse Backing Up the Database Using Backups OFFLINE, OR STATIC, BACKUPS Creating Your Backup Strategy Creating a Backup Device SQL Server Failover Support Restoring Databases Restoring a Damaged Database Restoring Transaction Logs & Differential Backups Recovering the Master Database SQL Server Performance Optimising Queries Gathering Statistics Indexes Automating Tasks SQL Server Agent Multiserver Administration Schedules Job Definition Alerts Publishing on the Web Web Assistant JWAssociates