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

details

SQL Server 2005管理员培训

暂无评价   
你实?#20351;?#20080;的价格
付款时最多可用0?#21592;业?#25187;0元现金
购买成功后,系统会给用户帐号返回的现金券
淘课价格
3000
可用?#21592;?/div>
0
返现金券
待定

你还可以: 收藏

培训受众:

企业、个人

课程收益:

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

课程大纲:

课程模块
课程内容 实验内容
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服务器,并管理或维护数据库、多维数据库、用户账户、数据库可用性、数据库恢复以及报告?#21462;?#20182;们还能够设计或实施安全机制、服务器自动化机制,监视SQL服务器的工作并及时排除?#25910;稀?#36890;过进一步的实践成为优秀的技术专家。在培训过程中,通过大量实验及分析题目帮助学员尽快通过MCITP数据库技术专家?#29616;ぁ?/div>

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

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

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

授课内容与课纲相符00%

讲师授课水平00%

服务态度00%

今天nba新闻最新消息
云南11选五玩法奖金 浙江飞鱼彩票不输玩法 6万赢一亿大陆女赌客 教师羽毛球比赛新闻稿 四川快乐12有技巧吗 体育彩票七位数 北京快三一定牛走势图 澳门平台网上投注 手机开奖秒速快3 河南481走势图30期 江苏快三遗漏号吗 直通车 单机赢三张炸金花 广西福利彩票快乐十分 排列3开奖结果今天