|
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); |