Designing a Microsoft SQL Server 2005 Server – Side Solutions (Moc2781)

Module 1: Selecting SQL Server Services to Support Business Needs
Overview of the Built-in SQL Server Services
Evaluating When to Use the New SQL Server Services
Evaluating the Use of Database Engine Enhancements
Module 2: Designing a Security Strategy
Overview of Authentication Modes and Authorization Strategies
Designing a Security Strategy for Components of a SQL Server 2005 Solution
Designing Objects to Manage Application Access
Creating an Auditing Strategy
Managing Multiple Development Teams Using the SQL Server 2005 Security Features
Module 3: Designing a Data Modeling Strategy
Defining Standards for Storing XML Data in a Solution
Designing a Database Solution Schema
Designing a Scale-Out Strategy
Module 4: Designing a Transaction Strategy for a SQL Server 2005 Solution
Defining Data Behavior Requirements
Defining Isolation Levels
Designing a Resilient Transaction Strategy
Module 5: Designing a Notification Services Solution
Defining Event Data
Designing a Subscription Strategy
Designing a Notification Strategy
Designing a Notification Delivery Strategy
Module 6: Designing a Service Broker Solution
Designing a Service Broker Solution Architecture
Designing Service Broker Data Flow
Designing Service Broker Solution Availability
Module 7: Planning for Source Control, Unit Testing, and Deployment
Designing a Source Control Strategy
Designing a Unit Test Plan
Creating a Performance Baseline and Benchmarking Strategy
Designing a Deployment Strategy
Module 8: Evaluating Advanced Query and XML Techniques
Evaluating Common Table Expressions
Evaluating Pivot Queries
Evaluating Ranking Queries
Overview of XQuery
Overview of Strategies for Converting Data Between XML and Relational Formats