 |
 |
 |
 |
SQL Server 2005 Bootcamp
Course 50007A: Five days; Instructor-Led
On This Page
| Introduction | |
| Audience | |
| At Course Completion | |
| Prerequisites | |
| Course Outline | |
| Take This Training |
Introduction
Elements of this syllabus are subject to change.
This five-day instructor-led course teaches database professionals working in enterprise environments how to upgrade to SQL Server 2005.
Audience
This course is intended for IT professionals
At Course Completion
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. |
Prerequisites
Before attending this course, students must have:
| • | Basic knowledge of SQL Server 2005 |
Course Outline
Relational Engine Lab 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 |
Relational Engine Lab 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 2A: Upgrading a Relational Database by Using the Copy Database Wizard
| • | Backing Up the Source Database and Reviewing Instance-Level Objects |
Lab 2B: Upgrading a Relational Database by Using the Copy Database Wizard
| • | Using the Copy Database Wizard |
| • | Reviewing the Copy Database Wizard Package |
Relational Engine Lab 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 |
Business Intelligence Lab 1: 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 |
Business Intelligence Lab 2: 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 |
Business Intelligence Lab 3: 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 |
Demo: 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 |
We are glad to anwer questions regarding our business and course offerings.
Call us at (800) 453-5961 or Send an Email.
DynamicsEdge, Inc. All Rights Reserved. © 2010
Now Hiring!
We are currently looking for Microsoft Certified Trainers (MCT) for training assignments. You must be a MCT in good standing with Microsoft and have a current high-level Microsoft Certification (MCITP, MTS, MCSD) with two years of training experience.
To apply please send an email to MCT@ DynamicsEdge.com
We support Dynamics CRM
Microsoft Dynamics CRM 4.0 is a CRM system your employees will use! Dynamics Edge can provide customization to make Dynamics CRM adapt to your business processes.
Support for Dynamics AX, NAV, SL, and RMS
Dynamics Edge provides support and training for the Dynamics products and the underlying technologies: SQL Server 2005 - 2008, Exchange Server 2003 - 2007 and Sharepoint 2007. .
Classes at Your Site
We offer private on-site classes for up to 8 people for most courses:
5 day private class: $10,995
4 day private class: $8,795
3 day private class: $6,595
1 & 2 day Private classes:
Call (800) 453-5961 or email!
Course Listings
Microsoft Dynamics
- Microsoft Dynamics CRM
- Microsoft Dynamics AX
- Microsoft Dynamics NAV
- Microsoft Dynamics GP
- Microsoft Dynamics SL
Other Products
- Windows Server 2008
- Windows Server 2003
- Windows 7 & Vista
- Exchange
- Share Point
- SQL Server
- SCCM / SMS Server
- Visual Studio & .Net
- Other Server Products