MOC7031 Upgrading to Microsoft SQL Server 2005 Training Course

About Us

Press Releases

Dates for this class:

No dates are available for this class.

Course Details [choose new course] [printable version]

Upgrading to Microsoft SQL Server 2005 (MOC7031)

Course Number: MOC7031

Category: Database & Collaboration Tools

Duration: 5.00 days

Description

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 Outline follows the powerpoint slide decks only and will not follow the traditional format.

Target 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.

Outline

Module 1: Feature Comparison (Day 1-3 PowerPoint Deck)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- 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)
- What is SQL Server Reporting Services?
- Lab
Module 16: SQL Server 2005 Reporting Services Upgrade (Day 4-5 PowerPoint Deck)
- 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
- Lab



Search Courses