SQL Server 2005管理员培训

企业、个人

通过本课程的培训，使学员尽快掌握SQL Server 2000及2005应用环境及各种工具。使学员能够安装或配置SQL服务器，并管理或维护数据库、多维数据库、用户账户、数据库可用性、数据库恢复以及报告等。他们还能够设计或实施安全机制、服务器自动化机制，监视SQL服务器的工作并及时排除故障。通过进一步的实践成为优秀的技术专家。在培训过程中，通过大量实验及分析题目帮助学员尽快通过MCITP数据库技术专家认证。

课程模块
课程内容 实验内容
Module 1
Installing and Configuring SQL Server
Preparing to Install SQL Server
Installing SQL Server 2005
Managing a SQL Server 2005 Installation
Performing an Installation
Managing SQL Server
Module 2:
Managing Databases and Files
Planning Databases
Creating Databases
Managing Databases
Creating a Database
Monitoring and Managing Filegroup Usage
Viewing Database Metadata
Module 3:
Disaster Recovery
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Performing Online Restore Operations
Recovering Data from Database Snapshots
System Database and Disaster Recovery
Implementing a Backup Strategy
Restoring and Recovering a Database
Performing Piecemeal Backup and Restore Operations
Restoring the master Database
Module 4:
Managing Security
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Managing Keys and Certificates in SQL Server
Creating Logins and Assigning Server-Scope Permissions
Creating and Managing Users
Using a Certificate to Protect Data
Module 5:
Monitoring SQL Server
Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Using DDL Triggers
Using Event Notifications
Monitoring SQL Server Performance
Tracing SQL Server Activity
Implementing DDL Triggers
Module 6:
Transferring Data
Overview of Data Transfer
Introduction to SQL Server Integration Services
Using SQL Server Integration Services
Features of SQL Server Integration Services
Creating an SSIS Package
Deploying an SSIS Package
Using SSIS to Extract Data, Perform Lookups, Sort, and Split Data

Module 7:
Automating Administrative Tasks
Automating Administrative Tasks
Configuring the SQL Server Agent
Creating Jobs and Operators
Creating Alerts
Managing Multiple Servers
Managing SQL Server Agent Security
Configuring SQL Server Agent
Creating Operators and Jobs
Creating Alerts
Module 8:
Implementing Replication
Overview of Replication
Implementing Replication
Configuring Replication in Some Common Scenarios
Creating a Publication
Creating a Subscription
Implementing HTTP Merge Replication
Module 9:
Maintaining High Availability
Introduction to High Availability
Implementing Server Clustering
Implementing Database Mirroring
Implementing Log Shipping
Implementing Peer-to-Peer Replication
Configuring Database Mirroring to Support Failover
Implementing Distributed High Availability

通过本课程的培训，使学员尽快掌握SQL Server 2000及2005应用环境及各种工具。使学员能够安装或配置SQL服务器，并管理或维护数据库、多维数据库、用户账户、数据库可用性、数据库恢复以及报告等。他们还能够设计或实施安全机制、服务器自动化机制，监视SQL服务器的工作并及时排除故障。通过进一步的实践成为优秀的技术专家。在培训过程中，通过大量实验及分析题目帮助学员尽快通过MCITP数据库技术专家认证。