CERTIFICATIONS

PROGRAMS

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

Upcoming classes

	Number	Class Date	Location	Length	Cost	Sign up
	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