0845 757 3888 · info@xpertise.co.uk

On-line training course catalogue

Upgrade to SQL Server 2005 Bootcamp

Type of course: Classroom

Course details
Fee£1595
Days5
Course code MS50007


We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

Formerly ‘non-MOC’ course 7031, the purpose of this 5-day instructor-led course is to teach database professionals working in enterprise environments how to upgrade to SQL Server 2005.

This course is intended for experienced database professionals who will be responsible for upgrading to SQL Server 2005. The target students for this course already have an understanding of how to use the SQL Server 2000 and SQL Server 2005 and understand the new features and capabilities of SQL Server 2005.

Prerequisites

Before attending this course, students must:

  • Have thorough experience with SQL Server 2000
  • Have experience with SQL Server 2005 and a comprehensive understanding of all the new features and technologies
  • The relational engine
  • Storage engine
  • Integration Services
  • Analysis Services
  • Reporting Services
  • Be familiar with SQL Server 2005 features, tools, and technologies.

Course Outline

Module 1: Feature Comparison
Module 2: Upgrade Technical Resource Guide
Module 3: Upgrading to SQL Server 2005 Express Edition
Module 4: Upgrading SQL Server 7.0 to SQL Server 2005
Module 5: Planning Considerations for Upgrading to SQL Server 2005
Module 6: Upgrading the Database Engine
Module 7: Native Client Upgrade Overview
Module 8: System.Data and SQL Server 2005 Upgrade Overview
Module 9: SQL Server 2005 Database Upgrade Test Toolkit
Module 10: Analysis Services 2005 Overview
Module 11: Upgrading to SQL Server 2005 Analysis Services
Module 12: Getting the Most out of Project REAL
Module 13: SQL Server Integration Services (SSIS) Overview
Module 14: From SQL Server 2000 DTS to SQL Server 2005 SSIS: Upgrade and Migration
Module 15: Introducing Microsoft SQL Server 2005 Reporting Services
Module 16: SQL Server 2005 Reporting Services Upgrade

Xpertise – Upgrade to SQL Server 2005 Bootcamp training courses

Xpertise provides Upgrade to SQL Server 2005 Bootcamp training courses from 22 UK locations: in Aberdeen Scotland, Altrincham Manchester, Birmingham West Midlands, Bristol South West, Edinburgh Scotland, Glasgow Scotland, Hinckley East Midlands, Leeds Yorkshire, Leeds Yorkshire (Ring Road), London King William Street, London Middlesex Street, London Rosebery Avenue, London Tabernacle Street, Maidenhead Berkshire, Malmesbury Wiltshire, Manchester (Exchange Quay), Milton Keynes Buckinghamshire, Newcastle Tyne and Wear, Reading Berkshire, Stockport Manchester, Swindon Wiltshire and Washington Tyne and Wear – and at 44 partner locations nationwide.


Xpertise Training reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.