Implementing a Microsoft SQL Server 2008 Database Course

Course Code: M6232

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.

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.

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

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

Topics covered on the 5 day Implementing a Microsoft SQL Server 2008 Database course

Creating Databases and Database Files

• Creating Databases
• Creating Filegroups
• Creating Schemas
• Creating Database Snapshots

Creating Data Types and Tables

• Creating Data Types
• Creating Tables
• Creating Partitioned Tables

Creating and Tuning Indexes

• Planning Indexes
• Creating Indexes
• Optimizing Indexes

Implementing Data Integrity by Using Constraints and Triggers

• Data Integrity Overview
• Implementing Constraints
• Implementing Triggers

Using XML

• Using the XML Data Type
• Retrieving XML by Using FOR XML
• Shredding XML by Using OPENXML
• Creating XML Indexes
• Implementing XML Schemas

Implementing Views

• Introduction to Views
• Creating and Managing Views
• Optimizing Performance by Using Views

Implementing Stored Procedures

• Implementing Stored Procedures
• Creating Parameterized Stored Procedures
• Working With Execution Plans
• Handling Errors

Implementing Functions

• Creating and Using Functions
• Working with Functions
• Controlling Execution Context

Implementing Managed Code in the Database

• Introduction to the SQL Server Common Language Runtime
• Importing and Configuring Assemblies
• Creating Managed Database Objects

Managing Transactions and Locks

• Overview of Transactions and Locks
• Managing Transactions
• Understanding SQL Server Locking Architecture
• Managing Locks

Using Service Broker

• Service Broker Overview
• Service Broker Objects
• Sending and Receiving Messages