Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

MS-6158 - Updating Your SQL Server 2005 Skills to SQL Server 2008

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

Click here to print this page »


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

Detailed Class Syllabus

Module 1: Introduction to SQL Server 2008

The Evolution of SQL Server
Preparing for SQL Server 2008

Module 2: SQL Server 2008 Manageability Enhancements

Configuration Servers
Policy-Based Management

Module 3: SQL Server 2008 Performance Enhancements

Managing Workloads with Resource Governor
Monitoring Performance with the Data Collector
Managing Performance with Plan Freezing

Module 4: SQL Server 2008 Security Enhancements

Encrypting Databases
Auditing All Actions

Module 5: SQL Server 2008 Database Development Enhancements

Developer Tool Enhancements
Data Type Enhancements
Working with Spatial Data

Module 6: SQL Server 2008 Availability Enhancements

Always On Technologies
Transactional Peer-to-Peer Replication

Module 7: SQL Server 2008 Data Warehousing Enhancements

ETL Enhancements
Using Partitioned Tables
Optimizing Data Storage

Module 8: SQL Server 2008 Reporting Services Enhancements

Reporting Services Architecture and Management
Authoring Reports
Report Processing and Rendering

Module 9: SQL Server 2008 Analysis Services Enhancements

Multidimensional Analysis with SQL Server Analysis Services
Data Mining with SQL Server Analysis Services