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