Kursbeschreibung: MOC 2734B

Updating Your Database Development Skills to SQL Server 2005 (5 Tage)

Lernziele:

• Use the development tools provided with SQL Server 2005
• Use Transact-SQL enhancements in SQL Server 2005 to perform database development tasks
• Develop XML-based solutions by using SQL Server 2005
• Build message-based services with Service Broker
• Implement Web services by using native HTTP endpoints
• Build Notification Services applications
• Implement database functionality with managed (.NET) code
• Build client applications with the .NET Framework
• Build administrative applications with SQL Management Objects (SMO)

Dauer:

5 Tage

Zielgruppe:

Database developers who are responsible for developing SQL Server 2005 solutions.

Voraus-setzungen:

• Architecture
• Database security
• Transact-SQL
• Schema and objects
• Programming objects
• SQL XML
• ADO.NET
• Experience developing with Visual Basic .NET or Visual C# .NET is useful, but not essential

Inhalte:

Module 1: SQL Server 2005 Overview

• SQL Server 2005 Components and Architecture
• SQL Server Developer Tools
• SQL Server 2005 Security Implementation

Module 2: Transact-SQL Enhancements in SQL Server 2005

• Data Definition Language Enhancements
• Data Manipulation Language Enhancements
• Structured Exception Handling

Module 3: Using XML in SQL Server 2005

• XML Enhancements in SQL Server 2005
• The xml Data Type
• Using XQuery

Module 4: Using Service Broker

• Service Broker Architecture
• Using Service Broker

Module 5: Using Native HTTP Support

• Native HTTP Support in SQL Server 2005
• Configuring Native HTTP Support
• Creating a Web Service

Module 6: Using Notification Services

• Notification Services Architecture
• Building Notification Services Solutions

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

• SQL Server and the .NET CLR
• Implementing Managed Code in SQL Server 2005

Module 8: Developing Client Applications

• Developing Clients with ADO.NET
• Data Binding in .NET Framework 2.0

Module 9: Using SQL Management Objects

• Introduction to SQL Management Objects
• Replication Management Objects

Dieses Seminar bezog sich im Original auf eine Beta-Version von SQL Server 2005 und wird von Microsoft nicht mehr abgeboten. Es wurde von uns speziell angepasst, so daß im Seminar die aktuelle Version verwendet werden kann.
Die Schulungsunterlagen sind nur als Kopien verfügbar.