New Horizons Computer Learning Center
410-597-9722

2781: Designing Microsoft SQL Server 2005 Server-Side Solutions

Course Length: 3 Days

Overview:
This three-day instructor-led course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL ServerT 2005. The course focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.

Prerequisites:
Writing Queries Using Microsoft SQL Server 2005 Transact-SQL
Course 2779: Implementing a Microsoft SQL Server 2005 Database
Course 2780: Maintaining a Microsoft SQL Server 2005 Database

Course Objectives:
Upon successful completion of this course, students will be able to:

• Select SQL Server services to support an organization's business needs
• Design a security strategy for a SQL Server 2005 solution
• Design a data modeling strategy
• Design a transaction strategy for a SQL Server solution
• Design a Notification Services solution
• Design a Service Broker solution
• Plan for source control, unit testing, and deployment to meet an organization's needs
• Evaluate advanced query techniques
• Evaluate advanced XML techniques

Course Content

Lesson 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
• Lab 1: Selecting SQL Server Services to Support Business Needs
• Translating Business Requirements into SQL Server Services
• Analyzing the Needs of Real Organizations

Lesson 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
• Lab 2: Designing a Security Strategy
• Evaluating the Security Tradeoffs of SQL Server Services
• Designing a Database to Enable Auditing
• Designing Objects to Manage Application Access
• Justifying Security Decisions

Lesson 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
• Lab 3: Designing a Data Modeling Strategy
• Designing a Database Solution Schema
• Designing Integration of Multiple Data Stores

Lesson 4: Designing a Transaction Strategy for a SQL Server 2005 Solution

• Defining Data Behavior Requirements
• Defining Isolation Levels
• Designing a Resilient Transaction Strategy
• Lab 4: Designing a Transaction Strategy for a SQL Server 2005 Solution
• Determining the Database Isolation Level
• Determining the Order of Object Access
• Designing Transactions
• Justifying a Transaction Strategy

Lesson 5: Designing a Notification Services Solution

• Defining Event Data
• Designing a Subscription Strategy
• Designing a Notification Strategy
• Designing a Notification Delivery Strategy
• Lab 5: Designing a Notification Services Solution
• Defining Event Data
• Designing a Subscription Strategy
• Designing a Notification Strategy
• Executing a Notification Services Solution

Lesson 6: Designing a Service Broker Solution

• Designing a Service Broker Solution Architecture
• Designing Service Broker Data Flow
• Designing Service Broker Solution Availability
• Lab 6: Designing a Service Broker Solution
• Designing a Service Broker Solution Architecture
• Designing a Subscription Strategy
• Executing a Service Broker Solution

Lesson 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
• Lab 7: Planning for Source Control, Unit Testing, and Deployment
• Designing a Source Control Strategy
• Designing a Unit Testing Plan
• Designing a Deployment Strategy
• Justifying Source Control, Unit Test, and Deployment Strategies

Lesson 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
• Lab 8: Evaluating Advanced Query Techniques
• Evaluating Common Table Expressions
• Evaluating Pivot Queries
• Evaluating Ranking Queries
• Evaluating Techniques for Converting XML into Relational Data

6940 Tudsbury Road, Baltimore, MD 21244
P: 410-597-9722
www.nhbaltimore.com