Designing Microsoft SQL Server 2005 Server-Side Solutions(Microsoft Training Course: 2781) - Microsoft Training Courses London South West UK

Exchange Server

Office (inc Access)

SQL Server

Visual Studio .NET

Windows

Web Development

Visual FoxPro

Programming

Business

Knowledge Management

Certification

Learning Options

Reserve a Place
06 May London
19 May Bath
02 Jun London
16 Jun Bath
07 Jul London
21 Jul Bath
04 Aug London
18 Aug Bath
01 Sep London
15 Sep Bath
06 Oct London
20 Oct Bath
03 Nov London
17 Nov Bath
01 Dec London
15 Dec Bath
05 Jan London
12 Jan Bath
02 Feb London
02 Feb London
02 Feb London
09 Feb Bath
09 Feb Bath
09 Feb Bath

View Other Courses in Same Category

Designing Microsoft SQL Server 2005 Server-Side Solutions - (Microsoft Training Course: 2781) - 3 days

Target Audience		Pre-requisites
Purpose		Print 2 Page Flyer
Exams		Price Options

COURSE OUTLINE

Selecting SQL Server Services to Support Business Needs		Designing a Security Strategy for Components of a SQL Server 2005 Solution
Designing a Data Modelling Strategy		Designing a Transaction Strategy for a SQL Server 2005 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

Target Audience: This course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005. It 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. Pre-requisites: Before attending this course, students must have the following pre-requisites: Be familiar with SQL Server 2005 features, tools, and technologies. Have basic knowledge of the operating system and platform. Understand XML. Have a Microsoft Certified Technology Specialist: Microsoft SQL Server 2005 credential - or equivalent experience. In addition, it is recommended, but not required, that students have completed: Course 2778, 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. Purpose: After completing 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 modelling 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.NB. This is a Preliminary Course Syllabus. Some parts of the course are currently in development, so some elements of this syllabus are subject to change.

Module 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
Lab: Selecting SQL Server Services to Support Business Needs

Skills

Evaluate the use of the new SQL Server services.
Evaluate the use of database engine enhancements.

Module 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
Lab: Designing a Security Strategy

Skills

Design a security strategy for components of a SQL Server 2005 solution.
Design objects to manage application access.
Create an auditing strategy.
Manage multiple development teams by using the SQL Server 2005 security features.

Module 3: Designing a Data Modelling Strategy

Defining Standards for Storing XML Data in a Solution
Designing a Database Solution Schema
Designing a Scale-Out Strategy
Lab: Designing a Data Modelling Strategy

Skills

Define standards for storing XML data in a solution.
Design a database solution schema.
Design a scale-out strategy for a solution.

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

Defining Data Behaviour Requirements
Defining Isolation Levels
Designing a Resilient Transaction Strategy
Lab: Designing a Transaction Strategy for a SQL Server 2005 Solution

Skills

Define data behaviour requirements.
Define isolation levels for the data store.
Design 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
Lab: Designing a Notification Services Solution

Skills

Define event data and how this data will be stored.
Design a subscription strategy for a Notification Services solution.
Design a notification strategy.
Design 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
Lab: Designing a Service Broker Solution

Skills

Design a Service Broker solution architecture.
Design the Service Broker data flow.
Design the 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
Lab: Planning for Source Control, Unit Testing, and Deployment

Skills

Design a source control strategy.
Design a unit test plan.
Create a performance baseline and benchmarking strategy.
Design a deployment strategy.

Module 8: Evaluating Advanced Query Techniques

Evaluating Common Table Expressions
Evaluating Pivot Queries
Evaluating Ranking Queries
Lab: Evaluating Advanced Query Techniques

Skills

Evaluate the use of Common Table Expressions.
Evaluate the use of pivot queries.
Evaluate the use of ranking queries.

Module 9: Evaluating Advanced XML Techniques

Evaluating the Use of XQuery
Creating a Strategy for Converting Data between XML and Relational Formats
Lab: Evaluating Advanced XML Techniques

Skills

Evaluate the use of XQuery.
Create a strategy for converting data between XML and relational formats.

.

Microsoft recommends this course in preparation for the following exams:

PRO: Designing Database Solutions by Using Microsoft SQL Server 2005

PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005

Price Options ex VAT:

Classroom Training ?	Distance Learning ?	eLearning Options ?	Book Learning ?
£ 1050 (€1491)	£ 674.00 (€957)	-	No Books Supported for Course at present
	Call Free on 0800 169 1890 Print 2 Page Flyer Last Modified 01 May 2008