Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.


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

Deploying and Managing a Public Key Infrastructure Course
Deploying and Managing a Public Key Infrastructure Course
3 sessions available starting from $2,400.00
Advanced Java Course
Advanced Java Course
6 sessions available starting from $4,000.00
Microsoft Visio 2007 Training Course Level 1
Microsoft Visio 2007 Training Course Level 1
2 sessions available starting from $425.00

see all listings »


Found In