SQL Server 2005管理员培训（招生中） 课程编号：16442 
上课时间： 从 2008-07-24 09:00 到 2008-08-25 18:00
课程时长： 33 小时
市 场 价： 3000 元
淘 课 价： 2500 元 （在淘课网用现金采购此课程，即获 7,500 淘币） 淘币细则 | 淘币换好礼
淘币兑换： 250,000 淘币 （若您有足够淘币，您也可以用淘币兑换此课程） 如何获取淘币
开课地点： 厦门市 厦禾路844号中厦国际大厦16楼
人　　气： 53 查看评价 发表评价
课程类别： 个人技能 IT技术
电话咨询开课机构
您尚未登录，请先 登录或 注册后查看联系方式。
在线咨询和报名
报名热线：021-61505199立刻报名
在淘课网用现金采购此课程，即获 7,500 淘币 淘币细则 | 淘币换好礼
培训受众
企业、个人
 
课程收益
通过本课程的培训，使学员尽快掌握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
 
在线咨询或报名课程编号： 16442  咨询热线：021-61505199
带“*”必须填写
* 真实姓名：    * 报名人数：
* 联系电话： - （区号-电话号码）
移动电话：
* 电子邮件：
所在单位：
咨询事项：
上海跃勤信息技术有限公司版权所有 (C) All rights reserved. 2006-2008
ICP号 沪ICP备05034964号