Microsoft Course 6317 - Upgrading Your SQL Server 2000 Skills to SQL Server 2008 — A 3-Day Course

Course Synopsis

This three-day instructor-led M6317 course provides students with the knowledge and skills to upgrade their SQL Server 2000 database administration (DBA) skills to SQL Server 2008 DBA skills. Please note that there is no certification exam related to this course.

Course Objectives

Delegates on this M6317 training course will learn how to:

Describe the new features of SQL Server 2008
Plan for a SQL Server 2008 installation, upgrade, and migration.
Understand SQL Server data types
Manage SQL Server 2008
Secure a SQL Server 2008 database
Prepare for and recover from potential database disasters
Maintain availability to their SQL Server data even through server downtime
Configure replication of SQL Server 2008 databases
Implement policy-based management
Monitor database activity
Monitor and manage database performance

Intended Audience

This course is intended for IT professionals who administer and maintain SQL Server databases.

Course Prerequisites

Before attending this course, students should have the following prerequisites:

experience developing or administering SQL Server 2000 databases.

Publicly scheduled dates, locations, and prices

London — £595 (+VAT)

15–17 Mar 2010
17–19 Mar 2010
29–31 Mar 2010
2–4 Jun 2010
9–11 Aug 2010
11–13 Aug 2010
6–8 Oct 2010
8–10 Dec 2010

Wokingham — £595 (+VAT)

14–16 Jun 2010
20–22 Dec 2010

Manchester — £595 (+VAT)

29–31 Mar 2010

Leeds — £595 (+VAT)

24–26 May 2010
25–27 Oct 2010

Aberdeen — £595 (+VAT)

29–31 Mar 2010

Outline Course Contents

An Introduction to SQL Server 2008

The Evolution of SQL Server
SQL Server 2008 Architectural Components

Installing and Upgrading to SQL Server 2008

Preparing for SQL Server 2008 Installation
Installing SQL Server 2008
Upgrading a SQL Server 2000 Instance
Configuring a SQL Server Installation
Using SQL Server Configuration Manager
Exercise 1: Analyzing the SQL Server 2000 Instance
Exercise 2: Upgrading to SQL Server 2008
Exercise 3: Validating the Upgrade
Exercise 4: Reviewing SQL Server Books Online

Storage Enhancements in SQL Server 2008

Data Type Enhancements
Table Partitioning
Indexing Enhancements
Tuning Indexes (Optional)
Exercise 1: Partitioning Tables
Exercise 2: Using the Database Engine Tuning Advisor (Optional)

SQL Server 2008 Administration Enhancements

Administration Tools Overview
Using SQL Server Management Studio
Using the sqlcmd Utility
Using Windows PowerShell
Exercise 1: Using SQL Server Management Studio
Exercise 2: Using SQL Server Command-Line Management
Exercise 3: Using PowerShell

Security Enhancements with SQL Server 2008

SQL Server 2008 Security Overview
Managing SQL Server 2008 Security
Managing Permissions
Managing Keys and Certificates
Data Encryption
Exercise 1: Managing Principals
Exercise 2: Managing Securables
Exercise 3: Managing Permissions
Exercise 4: Configuring Column Encryption
Exercise 5: Transparent Data Encryption

SQL Server 2008 Disaster Recovery

Database Backup
Backup Compression
Database Restoration
Database Snapshots
Exercise 1: Making a Copy-Only Backup
Exercise 2: Using Compression for Backup Files
Exercise 3: Creating the Database Snapshot
Exercise 4: Restoring From a Database Snapshot

High Availability in SQL Server 2008

Log Shipping
Database Mirroring
Determining the Best High Availability Solution
Exercise 1: Implementing Log Shipping
Exercise 2: Implementing Database Mirroring
Exercise 3: Implementing Peer-to-Peer Replication

Replication Enhancements in SQL Server 2008

New Types of Replication
Additional Replication Enhancements
Exercise 1: Implementing Peer-to-Peer Transactional Replication
Exercise 2: Implementing HTTP Replication

SQL Server 2008 Policy-Based Management

Understanding Central Management Servers
Understanding Policy-Based Management
Implementing Policy-Based Management
Exercise 1: Creating a Central Management Server and Server Group
Exercise 2: Creating and Applying a Policy

SQL Server 2008 Monitoring Enhancements

Monitoring a Database
Using DDL Triggers
Auditing in SQL Server
Event Notifications
Using Static and Dynamic Metadata
Exercise 1: Monitoring SQL Server Activity
Exercise 2: Tracing SQL Server Activity
Exercise 3: Using DLL Triggers
Exercise 4: Using Event Notification

SQL Server 2008 Performance

Managing Workloads with Resource Governor
Monitoring Performance with the Data Collector
Managing Performance with Plan Freezing
Exercise 1: Using Resource Governor
Exercise 2: Using the Data Collector
Exercise 3: Using Plan Freezing

Printer-friendly version

SQL Server training UK enquiries

UK Training enquiries and feedback form.

SQL Server training UK prices

For publicly scheduled training (individual places), see our UK training schedule.

For current special offers on courses, see our Special Offers section.

In-house training for company groups is charged at a daily rate per group — see our In-House UK Training Guidelines.

Publicly Scheduled Training Locations

We currently run public training courses across the UK including following locations:

London, UK
Leeds, West Yorkshire, UK
Aberdeen, Scotland, UK
Bradford, West Yorkshire, UK
Birmingham, West Midlands, UK
Bournemouth, Dorset, UK
Bristol, South West
Carshalton, Surrey, UK
Chester, North West, UK
Cheshire, North West, UK
Coventry, West Midlands, UK
Crawley, West Sussex, UK
Derby, East Midlands, UK
Dublin, Ireland
Edinburgh, Scotland, UK
Exeter, South West, UK
Glasgow, Scotland, UK
Harrogate, North Yorkshire, UK
Harwell, Oxfordshire, UK
Hinckley, Leicestershire, UK
Lancashire, North West, UK
Liverpool, North west, UK
Maidenhead, Berkshire, UK
Manchester, North West, UK
Milton Keynes, Buckinghamshire, UK
Nottinghamshire, East Midlands, UK
Reading, Berkshire, UK
Sheffield, South Yorkshire, UK
Slough, Berkshire, UK
Stevenage, Hertfordshire, UK
Swindon, South West, UK
Tyne and Wear, North East, UK
Wakefield, West Yorkshire, UK
Wokingham, Berkshire, UK
Wiltshire, South West, UK
Wirral, North West, UK

Most UK public training courses are available on a monthly basis.

Please see the individual course outlines or our public training schedule for details.

In-house (on-site) training locations

We deliver in-house courses at client premises and/or training facilities in any part of the world which is practically and commercially accessible.

Our In-house training guidelines outline our basic requirements and our UK pricing structure. To estimate costs for training in other countries, simply convert to your local currency and then make a rough calculation of our tutor's costs for travelling to and staying at your location.