7031 Upgrading to Microsoft SQL Server 2005

Displaying courses for United States [Change]


The purpose of this course is to teach database professionals working in enterprise environments how to upgrade to SQL Server 2005. Please note that because this is not official Microsoft Courseware.


This non-MOC course is intended for experienced database professionals who will be responsible for upgrading to SQL Server 2005. The target students for this non-MOC 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.


Feature Comparison

  • Introducing SQL Server 2005 Packaging & Pricing
  • Scale
  • HA/Engine
  • HA/Engine (2)
  • Management Tools
  • Replication
  • Analysis Services
  • Data Mining
  • Reporting Services
  • Integration Services
  • Notification Services

Upgrade Technical Resource Guide

  • Why Upgrade to SQL Server 2005
  • Upgrade Planning and Deployment
  • Enterprise Systems Upgrade Issues
  • Relational Database Upgrade Scenarios
  • Business Intelligence Upgrade Scenarios

Upgrading to SQL Server 2005 Express Edition

  • SQL Server 2005 Express Edition
  • Product Release Plan
  • Usage Scenarios
  • Top 10 Reasons for Upgrading
  • Licensing
  • Features Comparison
  • Upgrading from MSDE 2000
  • Demo
  • Deploying Express
  • Common Issues
  • Upgrading to other SQL Server 2005 Editions

Upgrading SQL Server 7.0 to SQL Server 2005

  • Server Requirements for Upgrading SQL Server 7.0
  • Upgrade Paths from SQL Server 7.0 to 2005
  • SQL 7.0 Upgrade known issues

Planning Considerations for Upgrading to SQL Server 2005

  • Definitions
  • What can be upgraded
  • How to upgrade
  • Upgrade Planning
  • Pre-upgrade
  • Upgrade Execution
  • Post-upgrade
  • In-place Upgrade vs. Migration
  • Upgrading Log Shipping
  • Upgrade Tips and Tricks

Upgrading the Database Engine

  • Upgrading the Database Engine
  • Instances and Directory Structures
  • Resource Database
  • System Tables / Metadata
  • Backwards Compatibility
  • New Features in the Database Engine
  • Transparent Benefits of Upgrading to SQL Server 2005

Native Client Upgrade Overview

  • Client connectivity options
  • SQL Native Client or MDAC?
  • Upgrade process
  • Demo - MARS
  • Upgrade issues
  • Using ADO with SQL Native Client
  • Backwards compatibility
  • Design considerations

System.Data and SQL Server 2005 Upgrade Overview

  • What is new in System.Data
  • Upgrade Matrix and Issues
  • Client – 1.1 / Server – Upgraded to SQL Server 2005
  • Client – Upgraded to 2.0 / Server – SQL 2000
  • Client – Upgraded to 2.0 / Server – Upgraded to SQL Server 2005
  • Overall Backwards Compatibility

SQL Server 2005 Database Upgrade Test Toolkit

  • Playback Testing
  • SQL Server 2005 Application Compatibility Labs
  • SQL Server 2005 Database Upgrade Test Toolkit

Analysis Services 2005 Overview

  • Analysis Services Overview
  • Data Mining Algorithms
  • The UDM – Key Features
  • Advanced Analytics:Data Mining – A complete and competitive offering
  • Mission Critical BI

Upgrading to SQL Server 2005 Analysis Services

  • Three options for moving to AS2005
  • Upgrade (in place)
  • Migration (side by side)
  • Redesign
  • For each option we will cover:
  • Techniques
  • Pros
  • Cons
  • Upgrade Advisor
  • Upgrade Verification Tool
  • Known Backward Compatibility Issues
  • Upgrading Client Applications

Getting the Most out of Project REAL

  • Overview of Project REAL
  • Contents of the Reference Implementation
  • Installing the Reference Implementation
  • A tour of the Reference Implementation
  • Relational Data Warehouse
  • ETL using Integration Services
  • Analysis Services cubes
  • Reports in Reporting Services

SQL Server Integration Services (SSIS) Overview

  • Integration Services Overview
  • How Integration Services Works
  • Precedence constraints in control flow (work flow)
  • Life Cycle tools
  • Package Configurations
  • Overview of

Training provider

Teaching mode:
Online - Self paced
Classroom - Instructor Led
Online - Instructor Led
Duration: 5 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Microsoft SQL Server
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.
Data warehouse
United States
This skill has an average salary of
and is mentioned in
of job ads in this area.