您的位置: 首页 > 公开课首页 > 职业素养 > 课程详情

details

SQL Server 2005管理员培训

暂无评价   
您实际购买的价格
付款时最多可用0淘币抵扣0元现金
购买成功后,系统会给用户帐号返回的现金券
淘课价
3000
可用淘币
0
返现金券
待定

你还可以: 收藏

培训受众:

企业、个人

课程收益:

通过本课程的培训,使学员尽快掌握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数据库技术专家认证。

本课程名称: SQL Server 2005管理员培训

查看更多:职业素养公开课

SQL 相关的最新课程
讲师动态评分 与同行相比

授课内容与课纲相符00%

讲师授课水平00%

服务态度00%