MS2779 Implementing a Microsoft SQL Server 2005 Database

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

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

After completing this course, students will be able 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.

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.

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)