SQL Server 2000 Administration

Topic-Level Outline

Days: 3

Prerequisites: Windows 2000 Server Administration Principles or equivalent experience

Unit 1 : Getting started with SQL Server 2000

Topic A: 0 SQL Server introduction

A-1: Understanding database systems

Topic B: 0 SQL Server features

B-1: Understanding SQL Server fundamentals

Topic C: 0 SQL Server installation

C-1: Installing SQL Server 2000

Topic D: 0 Special installation concerns

D-1: Installing a named instance

Topic E: 0 Database administration

E-1: Using Query Analyzer

Unit 2 : Databases and capacity planning

Topic A: 0 SQL Server organization and data storage

A-1: Understanding object and storage fundamentals

Topic B: 0 Database management

B-1: Creating a database

Topic C: 0 Capacity planning and management

C-1: Managing databases

Unit 3 : Database and object management

Topic A: 0 Managing databases

A-1: Managing a database

Topic B: 0 Database object fundamentals

B-1: Understanding database objects

Unit 4 : Data management

Topic A: 0 Data conversions

A-1: Preparing for exercises

Topic B: 0 Bulk copy program (bcp) and BULK INSERT

B-1: Using bcp and BULK INSERT

Topic C: 0 INSERT, UPDATE, DELETE, and SELECT INTO

C-1: Manipulating data

Topic D: 0 Data Transformation Services (DTS)

D-1: Using DTS

Topic E: 0 Data migration planning

E-1: Choosing a transfer method

Unit 5 : Backup, restore, and fault tolerance

Topic A: 0 Data security

A-1: Running Windows backup and restore

Topic B: 0 Database backup

B-1: Backing up data

Topic C: 0 Database restore

C-1: Restoring a database

Topic D: 0 Managing data security

D-1: Understanding backups and fault tolerance

Unit 6 : Client configuration and management

Topic A: 0 Network communications

A-1: Understanding network communications

Topic B: 0 XML support

B-1: Preparing for XML support

Unit 7 : Security management

Topic A: 0 Server login and database user management

A-1: Managing logins and users

Topic B: 0 Security management

B-1: Managing access security

Topic C: 0 Security planning

C-1: Understanding security management

Unit 8 : Distributed data environment

Topic A: 0 Nonlinked servers

A-1: Accessing remote data

Topic B: 0 Linked servers

B-1: Managing linked servers

Unit 9 : Replication management

Topic A: 0 Replication concepts

A-1: Understanding replication fundamentals

Topic B: 0 Publishing and distribution

B-1: Creating publications

Topic C: 0 Managing subscriptions

C-1: Creating a subscription

Topic D: 0 Replication planning and management

D-1: Managing replication

Unit 10 : Ongoing management

Topic A: 0 SQL Mail

A-1: Understanding mail support

Topic B: 0 Automating management

B-1: Understanding management automation

Topic C: 0 SQL Server management

C-1: Checking data integrity

Unit 11 : Monitoring and optimization

Topic A: 0 Monitoring overview

A-1: Managing server properties

Topic B: 0 Windows monitoring tools

B-1: Understanding Windows monitoring

Topic C: 0 SQL Server monitoring tools

C-1: Using traces

Topic D: 0 Database optimization

D-1: Managing locks

Appendix A : Case study

Topic A: 0 Sample setup.iss

Topic B: 0 Project goals

Appendix B : Additional object references

Topic A: 0 System Tables

Topic B: 0 System functions

Topic C: 0 Data types and precision storage

Topic D: 0 DBCC command statements