A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(2210) Updating Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(8036) Designing IT Platform Collaborative Applications with Microsoft SharePoint 2003 Workshop - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(2092) Populating a Data Warehouse with Microsoft SQL Server 2000 Data Transformation Services - Microsoft Training Courses in London and South West
Course:(2786) Designing a Microsoft SQL Server 2005 Infrastructure - Microsoft Training Courses in London and South West
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(2278) Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure - Microsoft Training Courses in London and South West
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2954) First Look: Microsoft BizTalk Server 2006 for Developers - Microsoft Training Courses in London and South West
Course:(2554) Designing, Planning, and Managing a Windows SharePoint Services and SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Course:(5927) Managing Projects Using Microsoft Office Project 2007 - Microsoft Training Courses in London and South West
Course:(2794) Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(1313) Microsoft Exchange Server 5.5 Series - Accelerated Training for Admin and Implementation - Microsoft Training Courses in London and South West
Course:(2789) Administering and Automating Microsoft SQL Server 2005 Databases and Servers - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(6232) Implementing a Microsoft SQL Server 2008 R2 Database - Microsoft Training Courses in London and South West
Course:(2019) Building Solutions in Microsoft Exchange 2000 with the Web Storage System - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(2553) Designing, Planning, and Managing a SharePoint Portal Server 2003 Infrastructure - Microsoft Training Courses in London and South West
Course:(5119) Supporting Windows Vista Computers with Desktop Images and Application Packages - Microsoft Training Courses in London and South West
Course:(2014) Customizing Microsoft Office SharePoint Portal Server 2003 - Microsoft Training Courses in London and South West
Course:(1140) Microsoft SQL Server 7.0 Overview - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Course:(2074) Designing and Implementing OLAP Solutions with Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(1634) Accelerated Training for Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2400) Implementing and Managing Microsoft Exchange Server 2003 - Microsoft Training Courses in London and South West
Course:(5116) Configuring Windows Vista Mobile Computing and Applications - Microsoft Training Courses in London and South West
Course:(10175) Microsoft SharePoint 2010, Application Development - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50429) Microsoft SharePoint 2010 Business Intelligence - Microsoft Training Courses in London and South West
Course:(2788) Designing High Availability Database Solutions Using Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(2933) Developing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(5058) Deploying Microsoft Office 2007 Professional Plus - Microsoft Training Courses in London and South West
Course:(1582) Building Web Applications Using Microsoft Visual InterDev 6 - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(1609) Designing Data Services and Data Models - Microsoft Training Courses in London and South West
Course:(2934) Deploying and Managing Business Process and Integration Solutions Using Microsoft BizTalk Server 2006 - Microsoft Training Courses in London and South West
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1017) Visual FoxPro 8.0 Intensive - Microsoft Training Courses in London and South West
Course:(2289) Deploying Business Desktops with Microsoft Windows XP and Microsoft Office 2003 - Microsoft Training Courses in London and South West
Course:(2276) Implementing a Microsoft Windows Server 2003 Network Infrastructure: Network Hosts - Microsoft Training Courses in London and South West
Course:(2299) Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSA on Windows 2000 - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(50050) Architecting Documents and Records Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5105) Deploying Microsoft Windows Vista Business Desktops - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Course:(10174) Configuring and Managing Microsoft SharePoint 2010 - Microsoft Training Courses in London and South West
Course:(3374) First Look: First Look: Getting Started with Microsoft Office 2007 SharePoint Server Hands-On Lab - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(2008) Designing a Microsoft Exchange Server 2003 Organization - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2781) Designing Microsoft SQL Server 2005 Server-Side Solutions - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Course:(5929) Managing Projects and Programs Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(2778) Writing Queries Using Microsoft SQL Server 2008 Transact-SQL - Microsoft Training Courses in London and South West
NET Framework Development Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Course:(F1016) Upgrading to Visual FoxPro 8.0 from Visual FoxPro 7.0 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(1573) Designing Microsoft Exchange 2000 for the Enterprise - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(2013) Optimizing Microsoft SQL Server 7.0 - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Systems Management Server Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(50354) Microsoft SharePoint 2010 SharePoint Designer - Microsoft Training Courses in London and South West
Course:(1026) Microsoft Exchange Server 5.5 Series - Concepts and Administration - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50219) Introduction to Microsoft Windows 7 for Developers - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(50049) Architecting Web Content Management Solutions with Microsoft Office SharePoint 2007 - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(2277) Implementing Managing and Maintaining a Microsoft Windows Server 2003 Network Infrastructure: Network Services - Microsoft Training Courses in London and South West
Course:(2733) Updating Your Database Administration Skills to SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(2827) Deploying Microsoft Windows Rights Management Services - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2795) Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services - Microsoft Training Courses in London and South West
Course:(2796) Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services - Microsoft Training Courses in London and South West
Course:(2275) Maintaining a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2723) Microsoft SQL Server 2000 for Experienced Database Professionals - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(5115) Installing and Configuring the Windows Vista Operating System - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(50352) Microsoft SharePoint 2010 Overview for End Users - Microsoft Training Courses in London and South West
Course:(2823) Implementing and Administering Security in a Microsoft Windows Server 2003 Network - Microsoft Training Courses in London and South West
Course:(F1012) Visual FoxPro 7.0 Programming - Microsoft Training Courses in London and South West
Course:(3370) First Look: Getting Started with Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2274) Managing a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Course:(1017) Developing Web Applications with Visual Interdev - Microsoft Training Courses in London and South West
Course:(5928) Managing Projects Using Microsoft Office Project Server 2007 - Microsoft Training Courses in London and South West
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(2030) Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services - Microsoft Training Courses in London and South West
Course:(2783) Designing the Data Tier for Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(4001) Team Collaboration Using Microsoft Windows SharePoint Services - Microsoft Training Courses in London and South West
Course:(F1013) Visual FoxPro 7.0 Intensive - Microsoft Training Courses in London and South West
Course:(6438) Implementing and Administering Windows SharePoint Services 3.0 in Windows Server 2008 - Microsoft Training Courses in London and South West
Course:(2591) Implementing Replication Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(2780) Maintaining a Microsoft SQL Server 2005 Database - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(50046) Introduction to Development Using Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(2279) Planning Implementing and Maintaining a Microsoft Windows Server 2003 Active Directory Infrastructure - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(6158) Updating Your SQL Server 2005 Skills to SQL Server 2008 - Microsoft Training Courses in London and South West
Course:(2791) Implementing and Maintaining Microsoft SQL Server 2005 Analysis Services - Microsoft Training Courses in London and South West
Course:(2208) Updating Support Skills from Windows NT 4.0 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2073) Programming a Microsoft SQL Server 2000 Database - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2071) Querying Microsoft SQL Server 2000 with Transact-SQL. - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2273) Managing and Maintaining a Microsoft Windows Server 2003 Environment - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(2787) Designing Security for Microsoft SQL Server 2005 - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(2297) Planning Implementing Managing and Maintaining a Microsoft Windows Server 2003 Environment for an MCSE on Windows 2000 - Microsoft Training Courses in London and South West
Course:(2209) Updating Systems Administrator Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(F1014) Visual FoxPro 7.0 Enterprise - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(50051) Architecting Microsoft Office SharePoint Server 2007 Portals and Collaboration Solutions - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(5179) Implementing and Maintaining Telephony Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(2091) Building XML-Enabled Applications Using Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Course:(6235) Implementing and Maintaining Microsoft SQL Server 2008 Integration Services - Microsoft Training Courses in London and South West
Course:(5117) Installing, Configuring, Troubleshooting, and Maintaining Windows Vista - Microsoft Training Courses in London and South West
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Course:(2355) Upgrading from Microsoft Exchange Server 5.5 to Microsoft Exchange 2000 - Microsoft Training Courses in London and South West
Course:(2779) Implementing a Microsoft SQL Server 2005 Database - Microsoft Training Courses in London and South West
Course:(5177) Implementing and Maintaining Instant Messaging Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(6236) Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services - Microsoft Training Courses in London and South West
Course:(2264) Exam Preparation for the MCDST Certification - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2552) Designing, Planning, and Managing a Windows SharePoint Services Infrastructure - Microsoft Training Courses in London and South West
Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2955) First Look: Microsoft BizTalk Server 2006 for IT Professionals - Microsoft Training Courses in London and South West
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(50218) Microsoft Windows 7 Training for Developers - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(5178) Implementing and Maintaining Audio/Visual Conferencing and Web Conferencing Using Microsoft Office Communications Server 2007 - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2207) Updating Systems Administrator and Systems Engineer Skills from Microsoft Windows 2000 to Windows Server 2003 - Microsoft Training Courses in London and South West
Course:(F1015) Visual FoxPro 7.0 Upgrade - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West

Compare Recently Viewed Course Dates


Exclusive
SQL Server 2005

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

 FebMarAprMayJunJulAugSepOctNovDecJan
London13
Ask a Question ?Print 2 Page PDF


> 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.
> Course outline
  1. Selecting SQL Server Services to Support Business Needs
  2. Designing a Security Strategy for Components of a SQL Server 2005 Solution
  3. Designing a Data Modelling Strategy
  4. Designing a Transaction Strategy for a SQL Server 2005 Solution
  5. Designing a Notification Services Solution
  6. Designing a Service Broker Solution
  7. Planning for Source Control, Unit Testing, and Deployment
  8. Evaluating Advanced Query Techniques
  9. Evaluating Advanced XML Techniques
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
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.
top
> 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.
> EXAMS
There are no exams directly associated with this course