Updating Your SQL Server 2005 Skill to SQL Server 2008

Course Code: MS6158
Duration: 3 Days

Bookmark and Share

Overview

This three-day instructor-led course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.

This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008.

Prerequisites

Before attending this course, students must have experience developing or administering SQL Server 2005 databases.

Delegates will learn how to

  • Describe the new features of SQL Server 2008.
  • Manage SQL Server 2008.
  • Optimize SQL Server 2008.
  • Secure a SQL Server 2008 Database.
  • Develop databases with SQL Server 2008.
  • Create and maintain highly available SQL Server 2008 databases.
  • Create and use a SQL Server 2008 data warehouse.
  • Use SQL Server 2008 Reporting Services.
  • Use SQL Server 2008 Analysis Services

Course outline

  • Module 1: Introduction to SQL Server 2008
  • Module 2: SQL Server 2008 Manageability Enhancements
  • Module 3: SQL Server 2008 Performance Enhancements
  • Module 4: SQL Server 2008 Security Enhancements
  • Module 5: SQL Server 2008 Database Development Enhancements
  • Module 6: SQL Server 2008 Availability Enhancements
  • Module 7: SQL Server 2008 Data Warehousing Enhancements
  • Module 8: SQL Server 2008 Reporting Services Enhancements
  • Module 9: SQL Server 2008 Analysis Services Enhancements