Upgrading Skills to Microsoft SQL Server 2005

PT4915
Summary
The purpose of this course is to teach database professionals working in enterprise environments how to upgrade to SQL Server 2005.
Prerequisites
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.
Duration
5 Days/Lecture & Lab
Audience
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.
Topics
  • SQL Server 2005 Introduced
  • Why Upgrade?
  • Upgrading to SQL 2005 Express
  • Upgrading SQL 7.0 to SQL 2005
  • Planning for Upgrades
  • Upgrading the Database Engine
  • Native Client Upgrade
  • System.Data and SQL 2005
  • SQL 2005 Upgrade Best Practices
  • Analysis Services 2005 Overview
  • Upgrading to SQL 2005 Analysis Services
  • Getting the Most out of Project REAL
  • SQL Server Integration Services
  • Upgrade from DTS to SQL SSIS
  • Introducing SQL 2005 Reporting Services
  • SQL 2005 Reporting Services Upgrade

Related Scheduled Courses