Designing Microsoft SQL Server 2005 Server-Side Solutions (Course 2781)
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
Designing the Data Tier for a Microsoft SQL Server 2005 (Course 2783)
Module-1 Choosing Data Access Technologies and an Object Model
Introduction to Data Access Technologies
Choosing Technologies for Accessing Data
Building a Data Access Layer
Designing Data Access from SQL Common Language Runtime (CLR) Objects
Available Data Object Models for Administering SQL Server
Module-2 Designing an Exception Handling Strategy
Exception Types and Their Purposes
Detecting Exceptions
Managing Exceptions
Module 3: Choosing a Cursor Strategy
Common Scenarios for Row-Based vs. Set-Based Operations
Selecting Appropriate Server-Side Cursors
Selecting Appropriate Client-Side Cursors
Module 4: Designing Query Strategies Using Multiple Active Result Sets
Introduction to MARS
Designing Query Strategies for Multiple Reads
Designing Query Strategies for Mixing Reads and Writes in the Same Connection
Concurrency Considerations When Using MARS
Module 5: Designing Caching Strategies for Database Applications
Why Caching Is Important
Data and Query Caching in SQL Server 2005
Using Caching Technologies Outside of SQL Server
Custom Caching Techniques
Module 6: Designing a Scalable Data Tier for Database Applications
Identifying the Need to Scale
Scaling Database Applications to Avoid Concurrency Contention
Scaling SQL Server Database Systems
Scaling Database Applications Using a Service-Oriented Architecture
Improving Availability and Scalability by Scaling Out Front-End Systems
|
are included.
then
its included. 
