Module 1: Creating Databases and Database Files

-  Creating Databases.

-  Creating Filegroups.

-  Creating Schemas.

-  Creating Database Snapshots.

Module 2: Creating Data Types and Tables

-  Creating Data Types.

-  Creating Tables.

-  Creating Partitioned Tables.

Module 3: Using XML

-  Retrieving XML by Using FOR XML.

-  Shredding XML by Using OPENXML.

-  Using the xml Data Type.

Module 4: Creating and Tuning Indexes

-  Planning Indexes.

-  Creating Indexes.

-  Optimizing Indexes.

-  Creating XML Indexes.

Module 5: Implementing Data Integrity

-  Data Integrity Overview.

-  Implementing Constraints.

-  Implementing Triggers.

-  Implementing XML Schemas.

Module 6: Implementing Views

-  Introduction to Views.

-  Creating and Managing Views.

-  Optimizing Performance by Using Views.

Module 7: Implementing Stored Procedures and Functions

-  Implementing Stored Procedures.

-  Creating Parameterized Stored Procedures.

-  Creating Functions.

-  Handling Errors.

-  Controlling Execution Context.

Module 8: Implementing Managed Code in the Database

-  Introduction to the SQL Server Common Language Runtime.

-  Importing and Configuring Assemblies.

-  Creating Managed Database Objects.

Module 9: Using Service Broker

-  Service Broker Overview.

-  Creating Service Broker Objects.

-  Sending and Receiving Messages.