SQL Server Training

SQL Server Training

Implementing a Microsoft SQL Server 2005 Database

Microsoft 2779

Microsoft Certification

Length: 5 Days
Published: May 02, 2007
Language(s): English
Audience(s): IT Professionals
Level: 200
Technology: Microsoft SQL Server 2005
Type: Course
Delivery Method: Instructor-led (classroom)
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.
Audience Profile
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 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.
Microsoft Training Discount Price Match Guarantee Microsoft Training Locations Redeem your Microsoft Training Vouchers here!