Search For Courses Here
Home / Courses / Microsoft Technology / 2779 Implementing a Microsoft SQL Server
About this Course
Elements of this syllabus are subject to change.
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.
At Course Completion
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 stored procedures.
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.
Microsoft Office and Office 365 Online Offerings
CISCO Live Online Courses
Application Training Bundles
Technical Training Bundles
365 Evans Avenue, Suite 300, Toronto, ON M8Z 1K2
© Copyright 2007 – 2011 TekSource. All rights reserved