Corporate HomeCorporate ProfileWorldwide OfficesSolutions At WorkEmployment  
LRS Education Services
LEARN  >  Find a Class  >  Class Summary

MS6158 - Updating Your SQL Server 2005 Skills to SQL Server 2008

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com
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 for a printer-friendly version of this page
 
Upcoming classes
Number Class Date Location Length Cost Sign up
Available Virtual MS6158 Feb 14, 2012 - Feb 16, 2012 Springfield 3 days $1395.00 Register


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
  •  
    Microsoft Partner Gold LearningPrometricEC-Council
    Microsoft Certified ProgramsAdditional Certification Courses