2734 Updating Your Database Development Skills To Microsoft SQL Server 2005

Lesson 1: SQL Server 2005 Overview

• SQL Server 2005 Components and Architecture

• SQL Server Developer Tools

• SQL Server 2005 Security Implementation

Lesson 2: Transact-SQL Enhancements in SQL Server 2005

• Data Definition Language Enhancements

• Data Manipulation Language Enhancements

• Structured Exception Handling

Lesson 3: Using XML in SQL Server 2005

• XML Enhancements in SQL Server 2005

• The xml Data Type

• Using XQuery

Lesson 4: Using Service Broker

• Service Broker Architecture

• Using the Service Broker

Lesson 5: Using Native HTTP Support

• Native HTTP Support in SQL Server 2005

• Configuring Native HTTP Support

Lesson 6: Using Notification Services

• Notification Services Architecture

• Building Notification Services Solutions

Lesson 7: Using the .NET CLR in SQL Server 2005

• SQL Server and the .NET CLR

• Implementing Managed Code in SQL Server 2005

Lesson 8: Developing Client Applications

• Developing Client Applications with ADO.NET

• Data Binding in the .NET Framework 2.0

Lesson 9: Using SQL Management Objects

• Introduction to SQL Management Objects

• Replication Management Objects