SQL Server 2000 Training:

Upgrade your SQL Server 2000 or SQL Server 7 skills to SQL Server 2005.
 

The SQL 2005 Upgrade Course
Duration: 3 days full time from 8am to 4pm
Venue: Cape Town

The price for this course excludes accommodation, flights, transport, transfers etc. The order of modules below may not be followed exactly, and the content is indicative of what is done.

Outline of the SQL 2005 Upgrade course

Module 1: Overview of SQL Server 2005 Architecture
 

This module introduces students to the various components and services that comprise SQL Server. Database administrators are often required to manage multiple aspects of the database server – not just the relational database engine, so an awareness of the components and functionality available in SQL Server 2005 is essential in order to prepare database administrators for SQL Server 2005 deployments and management.
 

Lessons

Module 2: Installing SQL Server 2005

This module explains how to plan for a SQL Server 2005 installation, install SQL Server 2005 and maintain a SQL Server 2005 installation.

Lessons

Lab 2: Installing SQL Server 2005

Module 3: SQL Server 2005 Administrative Tools

This module explains what built-in administration tools and utilities are available in Microsoft SQL Server™ 2005 and how they can be used to help database administrators be successful in managing a SQL Server 2005 solution.

Lessons

Lab 3: Administering SQL Server 2005

Module 4: Monitoring SQL Server 2005

This module discusses the various tools and techniques you can use to monitor Microsoft SQL Server™ 2005.

Lessons

Lab 4: Monitoring SQL Server 2005

Module 5: Maintaining Databases and Indexes

This module explains the tools and utilities in Microsoft SQL Server™ 2005 that can help you implement database maintenance plans, manage database indexes, and tune databases.

Lessons

Lab 5: Maintaining a Database

Module 6: Securing SQL Server 2005

This module explains the changes and enhancements to the Microsoft SQL Server™ security model in SQL Server 2005.

Lessons

Lab 6: Securing a SQL Server 2005 Database

Module 7: Disaster Recovery

This module you will learn about the enhanced backup and restore functionality in Microsoft SQL Server™ 2005.

Lessons

Lab 7: Managing Disaster Recovery

Module 8: Data Availability in SQL Server 2005

This module teaches you how to take advantage of the high availability features found in SQL Server 2005

Lessons

Lab 8: Maintaining Availability

Module 9: SQL Server 2005 Replication

This module explains the new and enhanced replication features in SQL Server 2005

Lessons