Implementing a Microsoft SQL Server 2008 Database

6232

Request another date

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 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Audience Profile

This course is intended for IT Professionals who administer and maintain SQL Server databases.

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

• Plan, create, and optimize indexes.

• Implement data integrity in Microsoft SQL Server 2008 databases by using constraints.

• Implement data integrity in Microsoft SQL Server 2008 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.

Prerequisites

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.