New Horizons Lexington KY Computer Training
New Horizons Computer Learning Center presents
 

2781 Designing Microsoft SQL Server 2005 Server-Side Solutions On-Site Training

This on-site training class is also available as Public Schedule Seminar.

This course provides students with the knowledge and skills to design server-side solutions for Microsoft® SQL Server 2005T

Course Description/Agenda


This course provides students with the knowledge and skills to design server-side solutions for Microsoft® SQL Server 2005T. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.

Who Should Attend:
This course is intended for current professional database developers who have three or more years of on-the-job experience developing SQL Server database solutions in an enterprise environment.

At Course Completion:
After attending 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.


Prerequisite(s) or equivalent knowledge:
2780 Maintaining a Microsoft SQL Server 2005 Database
2779 Implementing a Microsoft SQL Server 2005 Database
2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
 
Outline:
Lesson 1: Selecting SQL Server Services to Support Business Needs
Evaluating When to Use the New SQL Server Services
Evaluating the Use of Database Engine Enhancements
Lesson 2: Designing a Security Strategy for Components of a SQL Server 2005 Solution
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
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
Lesson 4: Designing a Transaction Strategy for a SQL Server 2005 Solution
Defining Data Behavior Requirements
Defining Isolation Levels
Designing a Resilient 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
Lesson 6: Designing a Service Broker Solution
Designing a Service Broker Solution Architecture
Designing Service Broker Data Flow
Designing Service Broker Solution Availability
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
Lesson 8: Evaluating Advanced Query Techniques
Evaluating Common Table Expressions
Evaluating Pivot Queries
Evaluating Ranking Queries
Lesson 9: Evaluating Advanced XML Techniques
Evaluating the Use of XQuery
Creating a Strategy for Converting Data between XML and Relational Formats

 

More Seminar Information

New Horizons Computer Learning Center
New Horizons Lexington KY Computer Training

Delivery Method

On-Site Training On-Site Training

Also Available As

Seminar Seminar

 
Add to favorites Add to favorites
Email Email this page
 

On-Site Training
Information Request Form

Please complete the form for more information and/or a quote for this on-site class.

Name:

Email

Phone:

City and State

Company:

Number of students:
(at least 10 for consideration)

When do you want to hold the
seminar?

How long would you like for the
seminar?

Additional comments to trainer:

We value your privacy!