MS2734 Updating Your Database Development Skills to Microsoft SQL Server 2005

Experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers.

Delegates will learn how to:
-Use the Development Tools provided with SQL Server 2005
-Build Message-Based Services with the Service Broker
-Build Notification Services Applications
-Implement Database Functionality with Managed (.NET) Code
-Use Transact-SQL enhancements to perform database development tasks
-Develop XML-based Solutions using SQL Server 2005
-Implement Web Services using Native HTTP Endpoints
-Build Client Applications with the .NET Framework
-Build Administrative Applications with SQL Management Objects (SMO).

Before attending this course, students must have:

-MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.
-Development experience with Microsoft SQL Server 2000 or Microsoft SQL Server 7.0.
-Knowledge of SQL Server 2000/7.0:• Database and server architecture.
-Database Security
-Transact SQL
-Query Engine
-DDL
-DML
-Optimization
-Schema and Objects
-Programming Objects
-UDDT
-UDF
-Triggers
-Stored Procedures
-Optimization
-SQL XML
-.NET Development (Visual Basic .NET or C# .NET)
-ADO.NET

In addition, it is recommended, but not required, that students have completed:

Course MS2073, Programming a Microsoft SQL Server 2000 Database.

Module 1: SQL Server 2005 Overview

Module 2: Transact-SQL Enhancements in SQL Server 2005</b>

Module 3: Using XML in SQL Server 2005

Module 4: Using Service Broker

Module 5: Using Native HTTP Support

Module 6: Using Notification Services

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

Module 8: Developing Client Applications

Module 9: Using SQL Management Objects