MS-6232: Implementing a Microsoft SQL Server 2008 Database

Dates/Locations:

Duration: 5 Days

Course Overview:

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.

Course Objectives:

• Creating Databases an Databases 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:

• Basic knowledge of the Microsoft Windows operating system and its core functionally.
• Working knowledge of Transact-SQL
• Working knowledge of relational databases.
• Some experience with database design

Related posts:

1. MS-6231A: Maintaining a Microsoft SQL Server 2008 Database
2. MS-5027: Querying and Processing SQL Server Data Using Microsoft SQL Server
3. MS-5047: Introduction to Installing and Managing Microsoft Exchange Server 2007
4. MS-2279: Planning, Implementing, and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure
5. MS-2277: Implementing, Managing and Maintaining a Microsoft Windows Server 2003: Network Infrastructure: Network Services