´╗┐

(retired) Implementing a Microsoft SQL Server 2005 Database


Introduction

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.

Outcomes

At the completion of this course, participants will be able to:

  • Create databases, database files, data types and tables.
  • Use XML-related features in Microsoft SQL Server 2005.
  • Deploy and administer Microsoft Office SharePoint Server 2007.
  • Implement data integrity in Microsoft SQL Server 2005 databases by using constraints and triggers.
  • Implement views, stored procedures, functions, and 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.

 

 




User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info


Next Step

Enquire Now
Tell a Friend
Email Course Outline