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

Target Audience:
This course is intended for developers and database administrators who are experienced with using SQL Server 2005 and want to update their skills to SQL Server 2008

Duration:
3 days

Pre-Requisites:
Before attending this course, students must have experience with developing or administering databases in SQL Server 2005.

Objectives:

• An Introduction to SQL Server 2008
  • The Evolution of SQL Server
  • Preparing for SQL Server 2008
• SQL Server 2008 Manageability Enhancements
  • Central Management Servers
  • Policy-Based Management
• SQL Server 2008 Performance Enhancements
  • Managing Workloads by Using Resource Governor
  • Monitoring Performance by Using Data Collector
  • Managing Performance by Using Plan Freezing
• SQL Server 2008 Security Enhancements
  • Encrypting Databases
  • SQL Server Audit
• SQL Server 2008 Database Development Enhancements
  • Developer Tool Enhancements
  • Data Type Enhancements
  • Working with Spatial Data
• SQL Server 2008 Availability Enhancements
  • Always-on Technologies
  • Transactional Peer-to-Peer Replication
• SQL Server 2008 Data Warehousing Enhancements
  • ETL Enhancements
  • Using Partitioned Tables
  • Optimizing Data Storage
• SQL Server 2008 Reporting Services Enhancements Lessons
  • Reporting Services Architecture and Management
  • Authoring Reports
  • Report Processing and Rendering
• SQL Server 2008 Analysis Services Enhancements
  • Multidimensional Analysis with SQL Server 2008 Analysis Services
  • Data Mining with SQL Server 2008 Analysis Services