MOC 6232: Implementing a Microsoft SQL Server 2008 Database

Contents

Module 1: Creating Databases and Database Files

· Creating Databases

· Creating Filegroups

· Creating Schemas

· Creating Database Snapshots

Module 2: Creating Data Types and Tables

· Creating Data Types

· Creating Tables

· Creating Partitioned Tables

Module 3: Creating and Tuning Indexes

· Planning Indexes

· Creating Indexes

· Optimizing Indexes

Module 4: Implementing Data Integrity by Using Constraints and Triggers

· Data Integrity Overview

· Implementing Constraints

· Implementing Triggers

Module 5: Using XML

· Using the XML Data Type

· Retrieving XML by Using FOR XML

· Shredding XML by Using OPENXML

· Introducing XQuery

· Creating XML Indexes

· Implementing XML Schemas

Module 6: Implementing Views

· Introduction to Views

· Creating and Managing Views

· Optimizing Performance by Using Views

Module 7: Implementing Stored Procedures

· Implementing Stored Procedures

· Creating Parameterized Stored Procedures

· Working With Execution Plans

· Handling Errors

Module 8: Implementing Functions

· Creating and Using Functions

· Working with Functions

· Controlling Execution Context

Module 9: Implementing Managed Code in the Database

· Introduction to the SQL Server Common Language Runtime

· Importing and Configuring Assemblies

· Creating Managed Database Objects

Module 10: Managing Transactions and Locks

· Overview of Transactions and Locks

· Managing Transactions

· Understanding SQL Server Locking Architecture

· Managing Locks

Module 11: Using Service Broker

· Service Broker Overview

· Creating Service Broker Objects

· Sending and Receiving Messages