Support

Microsoft SQL Server 2005 Course | Upgrading

2 sessions available starting from $3,400.00

Subject: Microsoft Sql Server

Ages: All ages

Skill level: All difficulty levels

Course Code: 7031
Course Duration: 5 days

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 course is not delivered using Microsoft Courseware, the following course outline follows the powerpoint slide decks only and will not follow the traditional format.

Course Modules

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

see more

Course Code: 7031
Course Duration: 5 days

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 course is not delivered using Microsoft Courseware, the following course outline follows the powerpoint slide decks only and will not follow the traditional format.

Course Modules

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 dot Data and SQL Server 2005 Upgrade Overview (Day 2-5 PowerPoint Deck)
This module explains how to include System dot Data as part of an upgrade plan

Lessons
• What's new in System dot 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

Who Should Attend

This 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 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

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

Fundamentals of Network Security Course
Fundamentals of Network Security Course
6 sessions available starting from $2,400.00
Microsoft Office SharePoint Designer 2007 Course -  Step by Step, Level 3
Microsoft Office SharePoint Designer 2007 Course - Step by Step, Level 3
1 session available for $680.00
Microsoft SQL Server 2005 Training Course | Designing Security
Microsoft SQL Server 2005 Training Course | Designing Security
5 sessions available starting from $1,360.00

see all listings »


Found In