M2779: Implementing a Microsoft SQL Server 2005 Database

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

Course Description:

This five-day instructor-led course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

This course is intended for IT Professionals wanting to become skilled on SQL Server 2005 product features and technologies for implementing a database.

This course includes the following modules:

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

Using XML

• Retrieving XML with FOR XML
• Shredding XML with OPENXML
• Using the xml Data Type

Creating and Tuning Indexes

• Planning Indexes
• Creating Indexes
• Optimizing Indexes
• Creating XML Indexes

Implementing Data Integrity

• Data Integrity Overview
• Implementing Constraints
• Implementing Triggers
• Implementing XML Schemas

Creating Views

• Introduction to Views
• Creating and Managing Views
• Optimizing Performance with Views

Creating Stored Procedures and Functions

• Implementing Stored Procedures
• Creating Parameterized Stored Procedures
• Creating Functions
• Handling Errors
• 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

Using Service Broker

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