Description:
This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

Target Audience:
This course is intended for IT Professionals who want to become skilled on SQL Server 2005 product features and technologies for implementing a database.

Duration:
5 days

Pre-Requisites:
Before attending this course, students must have:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

In addition, it is recommended, but not required, that students have completed:

• Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
• Course 2780: Maintaining a Microsoft SQL Server 2005 Database

Objectives:

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