Implementing a Microsoft SQL Server 2005 Database

Module 1: Creating Databases and Database Files This module explains how to create databases, filegroups, schemas, and database snapshots. Lessons

• Creating Databases
• Creating Filegroups
• Creating Schemas
• Creating Database Snapshots

Module 2: Creating Data Types and Tables Lessons

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 Lessons

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. Lessons

• 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. Lessons

• Data Integrity Overview
• Implementing Constraints

Module 6: Implementing Data Integrity by Using Triggers and XML Schemas Lessons

This module explains how to implement triggers and XML schemas.

• Implementing Triggers
• Implementing XML Schemas

Module 7: Implementing Views Lessons

This module explains how to create views.

• Introduction to Views
• Creating and Managing Views
• Optimizing Performance by Using Views

Module 8: Implementing Stored Procedures Lessons

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. Lessons

• 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. Lessons

• 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. Lessons

• 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. Lessons
  • Service Broker Overview
  • Creating Service Broker Objects
  • Sending and Receiving Messages

Module 13: Using Notification Services (Optional) Lessons

• Introduction to Notification Services
• Developing Notification Services Solutions