| 1 | Creating Databases and Database Files | Creating Databases.
Creating Filegroups.
Creating Schemas.
Creating Database Snapshots.
|
| 2 | Creating Data Types and Tables | Creating Data Types.
Creating Tables.
Creating Partitioned Tables.
|
| 3 | Using XML | Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Introducing XQuery
Using the xml Data Type |
| 4 | Creating and Tuning Indexes | Planning Indexes.
Creating Indexes.
Optimizing Indexes.
Creating XML Indexes.
|
| 5 | Implementing Data Integrity by Using Constraints | Data Integrity Overview
Implementing Constraints
|
| 6 | Implementing Data Integrity by Using Triggers and XML Schemas | Implementing Triggers
Implementing XML Schemas
|
| 7 | Implementing Views | Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views
|
| 8 | Implementing Stored Procedures | Implementing Stored Procedures
Creating Parameterized Stored Procedures
Working With Execution Plans
Handling Errors
|
| 9 | Implementing Functions | Creating and Using Functions
Working with Functions
Controlling Execution Context
|
| 10 | Implementing Managed Code in the Database | Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects
|
| 11 | Managing Transactions and Locks | Overview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks
|
| 12 | Using Service Broker | Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages
|
| 13 | Using Notification Services (Optional) | Introduction to Notification Services
Developing Notification Services Solutions |