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 »

Prerequisites


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