Course: MS2779 Implementing a Microsoft SQL Server 2005 Database

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.

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

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:

MS2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.
MS2780: Maintaining a Microsoft SQL Server 2005 Database.

Delegates will learn how to:

Create databases and database files.
Create data types and tables.
Use XML-related features in Microsoft SQL Server 2005.
Plan, create, and optimize indexes.
Implement data integrity in Microsoft SQL Server 2005 databases by using constraints.
Implement data integrity in Microsoft SQL Server 2005 by using triggers.
Implement views.
Implement stored procedures.
Implement functions.
Implement managed code in the database.
Manage transactions and locks.
Use Service Broker to build a messaging-based solution.
Use Notification Services to generate and send notifications.

Module 1: Creating Databases and Database Files

Module 2: Creating Data Types and Tables

Module 3: Using XML

Module 4: Creating and Tuning Indexes

Module 5: Implementing Data Integrity by Using Constraints

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

Module 7: Implementing Views

Module 8: Implementing Stored Procedures

Module 9: Implementing Functions

Module 10: Implementing Managed Code in the Database

Module 11: Managing Transactions and Locks

Module 12: Using Service Broker

Module 13: Using Notification Services (Optional)