Support

SQL Server 2005 Course | Upgrade

2 sessions available starting from $3,400.00

Subject: Microsoft Sql Server

Ages: All ages

Skill level: All difficulty levels

Course Code: 50007
Course Duration: 5 days

This five-day comprehensive instructor-led (Level 300) course teaches database professionals working in enterprise environments how to upgrade to SQL Server 2005.

Skills Gained

After completing this course, students will be able to:

• Provide an in-place upgrade of a SQL Server 200 relational database
• Prove a side-by-side upgrade of a SQL Server relational database environment
• Use the detach and attach method to upgrade a clustered SQL Server 2000 environment
• Upgrade Reporting Services 2000 to Reporting Services 2005
• Perform migrations of SQL Server 2000 Data Transformation Services (DTS) packages and functionality to SQL Server
• 2005 Integration Services (SSIS)
• Perform upgrades of Analysis Services 2000 to Analysis...

see more

Course Code: 50007
Course Duration: 5 days

This five-day comprehensive instructor-led (Level 300) course teaches database professionals working in enterprise environments how to upgrade to SQL Server 2005.

Skills Gained

After completing this course, students will be able to:

• Provide an in-place upgrade of a SQL Server 200 relational database
• Prove a side-by-side upgrade of a SQL Server relational database environment
• Use the detach and attach method to upgrade a clustered SQL Server 2000 environment
• Upgrade Reporting Services 2000 to Reporting Services 2005
• Perform migrations of SQL Server 2000 Data Transformation Services (DTS) packages and functionality to SQL Server
• 2005 Integration Services (SSIS)
• Perform upgrades of Analysis Services 2000 to Analysis Services 2005 using two different upgrade methods
• Execute Microsoft SQL Server 2005 Upgrade Advisor against a SQL Server 7.0 server

Course Modules

Module 1: Performing an In-Place Upgrade of a SQL Server 2000 Relational Database Environment
This module explains how to upgrade a SQL Server 2000 relational database by performing an in-place version upgrade of the relational database engine and all of its databases.

Lessons
• Overview
• Executing Upgrade Advisor
• Fixing Upgrade Issues
• Performing Pre-Upgrade Tasks
• Performing the Version Upgrade

Module 2: Performing a Side-by-Side Upgrade of a SQL Server 2000 Relational Database Environment
This module explains how to upgrade a SQL Server 2000 database to SQL Server 2005 by using two different side-by-side upgrade methods.

Lessons
• Overview

Lab : Upgrading a Relational Database by Using the Copy Database Wizard
• Backing Up the Source Database and Reviewing Instance-Level Objects

Lab : Upgrading a Relational Database by Using the Copy Database Wizard
• Using the Copy Database Wizard
• Reviewing the Copy Database Wizard Package

Module 3: Upgrading a Clustered SQL Server 2000 Environment by Using the Detach and Attach Method
This module explains how to upgrade a clustered SQL Server 2000 database to a new SQL Server 2005 instance by using the detach and attach method.

Lessons
• Overview
• Scenario
• Reviewing the Server Environment
• Upgrading a Clustered SQL Server 2000 Database by Using the Detach and Attach Method
• Performing Post-Installation Tasks

Module 4: Upgrading Reporting Services
This module explains how to perform upgrades of Reporting Services 2000 to Reporting Services 2005 by using two different upgrade methods.

Lessons
• Overview
• Performing an In-Place Upgrade to Reporting Services 2005
• Performing a Side-by-Side Upgrade to Reporting Services 2005
• Upgrading Reports to Reporting Services 2005
• Preparing for Report Builder Use

Module 5: Migrating DTS to Integration Services
This module explains how to perform migrations of SQL Server 2000 Data Transformation Services (DTS) packages and functionality to SQL Server 2005 Integration Services (SSIS).

Lessons
• Overview
• Performing an In-Place Upgrade of DTS
• Working with DTS Packages by Using SQL Server 2005
• Migrating DTS Packages to SSIS

Module 6: Upgrading Analysis Services
This module explains how to perform upgrades of Analysis Services 2000 to Analysis Services 2005 using two different upgrade methods: an in-place upgrade and a side-by-side upgrade.

Lessons
• Overview
• Performing an In-Place Upgrade to Analysis Services 2005
• Performing a Side-by-Side Upgrade to Analysis Services 2005
• Modifying a Migrated Analysis Services Database

Module 7: Upgrading SQL Server 7.0 to SQL Server 2005
This module explains how to execute Microsoft SQL Server 2005 Upgrade Advisor against a SQL Server 7.0 server to obtain information about possible upgrade issues, review the generated report, and then fix upgrade issues.

Lessons
• Executing Upgrade Advisor
• Fixing Upgrade Issues

Who Should Attend

This course is intended for IT professionals who want to learn how to upgrade to SQL Server 2005.

Prerequisites

Before attending this course, students must have:

• Basic knowledge of SQL Server 2005

see less

Choose from 2 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $3,400.00

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 5/159-175 Church St
    Parramatta, NSW 2150

Price: $3,400.00

Type

  • Class / Group Sessions



Reviews

John Weber
Good experience!
  • 5/5 stars

I took CCNA class in MIS. It was pretty good, the course was hands-on and teacher was instructional. I was also...
John Weber

see all reviews »


My Other Listings

Excel 2010 1 Day Training Course Level 2 - DT202
Excel 2010 1 Day Training Course Level 2 - DT202
5 sessions available starting from $495.00
Design, Optimise and Maintain Database Server Infrastructure using SQL 2008
Design, Optimise and Maintain Database Server Infrastructure using SQL 2008
6 sessions available starting from $3,400.00
Deploying and Administering Microsoft Forefront Client Security 3 Day Course
Deploying and Administering Microsoft Forefront Client Security 3 Day Course
2 sessions available starting from $1,800.00

see all listings »


Found In