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