|
7031: Upgrading to Microsoft SQL Server 2005
Five daysInstructor-led
Introduction
The purpose of this 5-day instructor-led course is to teach database professionals working in enterprise environments how to upgrade to SQL Server 2005.
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 and SQL Server 2005 and understand the new features and capabilities of SQL Server 2005.
Prerequisites
Before attending this course, students must:
Instructor is very skilled in putting together live demos during the class. Which makes the class interesting and enables us to better
understand the subject being covered.He is an top-notch instructor who sure knows Microsoft products inside-and-out. I would be hard pressed to think of someone else
I have met who knows the answer to more SQL Server items, no matter how discrete, right off the top of his head .
1/26/2007 MTM Report
Have thorough experience with SQL Server 2000 Have experience with SQL Server 2005 and a comprehensive understanding of all the new features and technologies The relational engine Storage engine Integration Services Analysis Services Reporting Services Be familiar with SQL Server 2005 features, tools, and technologies. Course Outline
Module 1: Feature Comparison
In this module, students will learn about key feature differentiators between the SQL Server 2005 Express. Workgroup, Standard and Enterprise editions.
Lessons
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 Module 2: Upgrade Technical Resource Guide
This module examines the various upgrade scenarios and answers questions on why to upgrade.
Lessons
Why Upgrade to SQL Server 2005 Upgrade Planning and Deployment Enterprise Systems Upgrade Issues Relational Database Upgrade Scenarios Business Intelligence Upgrade Scenarios Lab
Module 3: Upgrading to SQL Server 2005 Express Edition
This module examine how to upgrade SQL Server 2005 Express Edition.
Lessons
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 Lab
Module 4: Upgrading SQL Server 7.0 to SQL Server 2005
This module describes how to upgrade from SQL Server 7.0 to SQL Server 2005.
Lessons
Server Requirements for Upgrading SQL Server 7.0 Upgrade Paths from SQL Server 7.0 to 2005 SQL 7.0 Upgrade known issues Lab
Module 5: Planning Considerations for Upgrading to SQL Server 2005
This module explains the various considerations to take into account when upgrading to SQL Server 2005.
Lessons
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 Lab
Module 6: Upgrading the Database Engine
This module shows students how to upgrade the database engine.
Lessons
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 Lab
Module 7: Native Client Upgrade Overview
This module covers how to upgrade the database client applications.
Lessons
Client connectivity options SQL Native Client or MDAC? Upgrade process Demo - MARS Upgrade issues Using ADO with SQL Native Client Backwards compatibility Design considerations Lab
Module 8: System.Data and SQL Server 2005 Upgrade Overview
This module explains how to include System.Data as part of an upgrade plan.
Lessons
What's 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 Lab
Module 9: SQL Server 2005 Database Upgrade Test Toolkit
This module covers the database upgrade test toolkit and how it can be used to simulate the performance/workloads of older versions of SQL Server in the new SQL Server environment.
Lessons
Playback Testing SQL Server 2005 Application Compatibility Labs SQL Server 2005 Database Upgrade Test Toolkit Lab
Module 10: Analysis Services 2005 Overview
This module reviews SQL Server Analysis Services 2005.
Lessons
Analysis Services Overview Data Mining Algorithms The UDM Key Features Advanced Analytics:Data Mining A complete and competitive offering Mission Critical BI Lab
Module 11: Upgrading to SQL Server 2005 Analysis Services
This module explains how to upgrade Analysis Services.
Lessons
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 Lab
Module 12: Getting the Most out of Project REAL
This module reviews Project REAL and how it can be used as resources.
Lessons
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 Lab
Module 13: SQL Server Integration Services (SSIS) Overview
This module provides an overview of SQL Server 2005 Integration Services.
Lessons
Integration Services Overview How Integration Services Works Precedence constraints in control flow (work flow) Life Cycle tools Package Configurations Overview of Integration Services Security Deploying Integration Services Packages Lab
Module 14: From SQL Server 2000 DTS to SQL Server 2005 SSIS: Upgrade and Migration
This module explains the migration story for SSIS 2005, describes tools and practices for migration and provide guidance for current engagements.
Lessons
From DTS to SSIS Upgrade Experience Support for Migration Migrating Packages Guidance for DTS Users Lab
Module 15: Introducing Microsoft SQL Server 2005 Reporting Services
This module provides and overview of SQL Server 2005 Reporting Services.
Lessons
What is SQL Server Reporting Services? Lab
Module 16: SQL Server 2005 Reporting Services Upgrade
This module explains how to setup and deploy Reporting Services and determine the appropriate upgrade and migration paths for Reporting Services.
Lessons
Overview of RS short, to the point Review setup in RS 2000 vs. setup in RS 2005 Review of deployment scenarios Goals of upgrade Process of upgrade what happens, when Migrating Report Server
