Module 1: Creating Databases and Database Files This module explains how to create databases, filegroups, schemas, and database snapshots. * Creating Databases * Creating Filegroups * Creating Schemas * Creating Database Snapshots Module 2: Creating Data Types and Tables This module explains how to create data types and tables. It also describes how to create partitioned tables. * Creating Data Types * Creating Tables * Creating Partitioned Tables Module 3: Using XML This module explains how to use the FOR XML clause and the OPENXML function. It also describes how to use the xml data type and its methods. * Retrieving XML by Using FOR XML * Shredding XML by Using OPENXML * Introducing XQuery * Using the xml Data Type Module 4: Creating and Tuning Indexes This module explains how to plan, create, and optimize indexes. It also describes how to create XML indexes. * Planning Indexes * Creating Indexes * Optimizing Indexes * Creating XML Indexes Module 5: Implementing Data Integrity by Using Constraints This module explains how to implement constraints and provides an overview of data integrity. * Data Integrity Overview * Implementing Constraints Module 6: Implementing Data Integrity by Using Triggers and XML Schemas This module explains how to implement triggers and XML schemas. * Implementing Triggers * Implementing XML Schemas Module 7: Implementing Views This module explains how to create views. * Introduction to Views * Creating and Managing Views * Optimizing Performance by Using Views Module 8: Implementing Stored Procedures This module explains how to create stored procedures and functions. It also describes execution plans, plan caching, and query compilation. * Implementing Stored Procedures * Creating Parameterized Stored Procedures * Working With Execution Plans * Handling Errors Module 9: Implementing Functions This module explains how to create functions. It also describes how to control the execution context. * Creating and Using Functions * Working with Functions * Controlling Execution Context Module 10: Implementing Managed Code in the Database This module explains how to implement managed database objects. * Introduction to the SQL Server Common Language Runtime * Importing and Configuring Assemblies * Creating Managed Database Objects Module 11: Managing Transactions and Locks This module explains how to use transactions and the SQL Server locking mechanisms to meet the performance and data integrity requirements of your applications. * Overview of Transactions and Locks * Managing Transactions * Understanding SQL Server Locking Architecture * Managing Locks Module 12: Using Service Broker This module explains how to build a messaging-based solution with Service Broker. * Service Broker Overview * Creating Service Broker Objects * Sending and Receiving Messages Module 13: Using Notification Services (Optional) This module explains how to develop applications that generate and send timely messages to subscribers. * Introduction to Notification Services * Developing Notification Services Solutions