DURATION
5 days
Introduction
The purpose of this non-MOC 5-day instructor-led course is to teach database professionals working in enterprise environments how to upgrade to SQL Server 2005. Please note that because this is not official Microsoft Courseware, the following course outline follows the powerpoint slide decks only and will not follow the traditional format.
Audience
This non-MOC course is intended for experienced database professionals who will be responsible for upgrading to SQL Server 2005. The target students for this non-MOC 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 non-MOC course, students must:
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.
Non-MOC Course Outline
Module 1: Feature Comparison (Day 1-3 PowerPoint Deck)
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 (Day 1-4 PowerPoint Deck)
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 (Day 1-5 PowerPoint Deck)
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 (Day 1-7 PowerPoint Deck)
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 (Day 2-2 PowerPoint Deck)
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 (Day 2-3 PowerPoint Deck)
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 (Day 2-4 PowerPoint Deck)
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 (Day 2-5 PowerPoint Deck)
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 (Day 2-6 PowerPoint Deck)
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 (Day 3-2 PowerPoint Deck)
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 (Day 3-3 PowerPoint Deck)
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 (Day 3-4 PowerPoint Deck)
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 (Day 4-2 PowerPoint Deck)
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 (Day 4-3 PowerPoint Deck)
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 (Day 4-4 PowerPoint Deck)
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 (Day 4-5 PowerPoint Deck)
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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.