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 consists of 13 Modules:

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)

By the end of the course delegates 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.