电脑基础入门

Introduction

Course Materials

Prerequisites

Course Outline

Setup

Microsoft Official Curriculum

Microsoft Certified Professional Program

Facilities

Module 1 : SQL Server Overtriew

What Is SQL Server?

SQL Server Integration

SQL Server Databases

SQL Server Security

Working with SQL Server

Lab A: SQL Server Overview

Review

Module 2: Planning to Install SQL Server

Hardware Installation Considerations

SQL Server 2000 Editions

Software Installation Considerations

Methods of Installing SQL Server

Upgrading SQL Server

Verifying the Installation

Configuring SQL Server Enterprise Manager

Troubleshooting

Recommended Practices

Lab A: Installing SQL Server

Review

Module 3: Managing Database Files

Introduction to Data Structures

Creating Databases

Managing Databases

Placing Database Files and Logs

Optimizing a Database Using Hardware-based RAID

Optimizing a Database Using Filegroups

Optimizing the Database Using Filegroups with Hardware-based RAID

Capacity Planning

Performance Considerations

Recommended Practices

Lab A: Managing Database Files

Review

Module 4: Managing Security

Implementing an Authentication Mode

Lab A: Managing Security

Assigning Login Accounts to Users and Roles

Assigning Permissions to Users and Roles

Managing Security Within SQL Server

Lab B: Managing Permissions

Managing Application Security

Lab C: Managing Application Security

Managing SQL Server Security in the Enterprise

Recommended Practices

Review

Module 5: Performing Administrative Tasks

Configuration Tasks

Lab A: Configuring SQL Server

Routine SQL Server Administrative Tasks

Automating Routine Maintenance Tasks .

Lab B: Creating Jobs and Operators

Creating Alerts

Troubleshooting SQL Server Automation

Lab C: Creating Alerts

Automating Multiserver Jobs

Recommended Practices

Review

Module 6: 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

Recommended Practices

Lab A: Backing Up Databases

Review

Module 7: Restoring Databases

SQL Server Recovery Process

Preparing to Restore a Database

Restoring Backups

Restoring Databases from Different Backup Types

Restoring Damaged System Databases

Recommended Practices

Lab A: Restoring Databases

Review

Module 8: Monitoring SQL Server for Performance

Why to Monitor SQL Server

Performance Monitoring and Tuning

Tools for Monitoring SQL Server

Common Monitoring and Tuning Tasks

Recommended Practices

Lab A: Monitoring SQL Server

Review

Module 9: Transferring Data

Introduction to Transferring Data

Tools for Importing and Exporting Data in SQL Server

Introduction to DTS

Transforming Data with DTS

Recommended Practices

Lab A: Transferring Data

Review

Module 10: Maintaining High Availability

Introduction to Availability

Increasing Availability Using Failover Clustering

Standby Servers and Log Shipping

Recommended Practices

Lab A: Automating the Maintenance of a Standby Server

Review

Module 11 : Introducing Replication

Introduction to Distributed Data

Introduction to SQL Server Replication

SQL Server Replication Agents

SQL Server Replication Types

Physical Replication Models

Recommended Practices

Lab A: Implementing Replication

Review

Appendix A

Classroom Setup Guide

Classroom Requirements

Classroom Configuration

Setup Instractions

Automated Classroom Setup

Classroom Setup Checklist

Customization Information