课程详情

SQLSERVER2005课程介绍

SQLSERVER2005课程介绍

  • 厦门思明 人气 27
普通课程
全日制

课程详情

完整图文>>

【课程详情】

课程名称
主要内容
课程时间
对应考试
Implementing a Microsoft SQL Server 2005 Database
1、 Creating Databases and Database Files;
2、Creating Data Types and Tables;
3、Using XML;
4、Creating and Tuning Indexes;
5、Implementing Data Integrity by Using Constraints ;
6.、Implementing Data Integrity by Using Triggers and XML Schemas;
7、Implementing Views;
8、Implementing Stored Procedures;
9、Implementing Functions;
10、Implementing Managed Code in the Database;
11、Managing Transactions and Locks;
12、Using Service Broker;
13、Using Notification Services (Optional);
2天
70-431
Maintaining a Microsoft SQL Server 2005 Database
1.      Installing and Configuring SQL Server 2005;
2.      Managing Databases and Files;
3.      Disaster Recovery;
4.      Managing Security;
5.      Monitoring SQL Server;
6.      Transferring Data;
7.      Automating Administrative Tasks;
8.      Implementing Replication;
9.      Maintaining High Availability;
2天
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
1.      Building a Monitoring Solution for SQL Server Performance Issues
2.      Troubleshooting Database and Database Server Performance Issues
3.      Optimizing the Query Performance Environment
4.      Troubleshooting SQL Server Connectivity Issues
5.      Troubleshooting SQL Server Data Issues
6.      Troubleshooting SQL Server Data Concurrency Issues
2 天
70-447

查看完整图文详情
2020猎学网广告栏

猜您喜欢

更多>>
猎学网 >学校机构 >微思网络 >课程详情