MOC 6232 Implementing a Microsoft SQL Server 2008 Database

    

Summary:
This 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.

Duration:
5 Days/Lecture & Lab

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

Topics:

• Creating Databases and Database Files
• Creating Data Types and Tables
• Creating and Tuning Indexes
• Implementing Data Integrity by Using Constraints and Triggers
• Using XML
• Implementing Views
• Implementing Stored Procedures
• Implementing Functions
• Implementing Managed Code in the Database
• Managing Transactions and Locks
• Using Service Broker

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.

Last Update: July 29, 2010