Designing Microsoft® SQL Server 2005 Server-Side Solutions

Zielgruppe
* Professionelle Datenbank-Entwickler

Vorraussetzungen
* Verwalten einer Microsoft SQL Server 2005 Datenbank
* Grundkenntnisse über relationale Datenbanken
* T-SQL Syntax
* Syntax von XML
* SQL Server 2005 Features, Tools und Technologien
* Microsoft Certified Technology Specialist
* Microsoft SQL Server 2005 Zertifizierung
* oder gleichwertige Erfahrung mitbringen.

Inhalt
* Selecting SQL Server Services to Support Business Needs
* Designing a Security Strategy for Components of a SQL Server
* Solution Designing a Data Modeling Strategy
* Designing a Transaction Strategy for a SQL Server Solution
* Designing a Notification Services Solution
* Designing a Service Broker Solution
* Planning for Source Control, Unit Testing, and Deployment
* Evaluating Advanced Query Techniques
* Evaluating Advanced XML Techniques
* Standards zur Speicherung von XML Daten
* Datenbankdesign OLAP-, -Normalisierung,-Indizes,- Performance,-Redundanz