NewEra Technology Facebook
6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008 - Virtual Led Training - Course Information
PRINT
SEND TO A FRIEND
Name: 6158 Updating Your SQL Server® 2005 Skills to SQL Server 2008 - Virtual Led Training
Category: Microsoft Official Curriculum Courses
Length (Days): 3
Course Price (CAD): 1650
Description:
This course provides students with the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008
Prerequisites:
N/A
Outline:
Lesson 1 - Introduction to SQL Server 2008
◦The Evolution of SQL Server
◦Preparing for SQL Server 2008

Lesson 2 - SQL Server 2008 Manageability Enhancements
◦Configuration Servers
◦Policy-Based Management

Lesson 3 - SQL Server 2008 Performance Enhancements
◦Managing Workloads with Resource Governor
◦Monitoring Performance with the Data Collector
◦Managing Performance with Plan Freezing

Lesson 4 - SQL Server 2008 Security Enhancements
◦Encrypting Databases
◦Auditing All Actions

Lesson 5 - SQL Server 2008 Database Development Enhancements
◦Developer Tool Enhancements
◦Data Type Enhancements
◦Working with Spatial Data

Lesson 6 - SQL Server 2008 Availability Enhancements
◦Always On Technologies
◦Transactional Peer-to-Peer Replication

Lesson 7 - SQL Server 2008 Data Warehousing Enhancements
◦ETL Enhancements
◦Using Partitioned Tables
◦Optimizing Data Storage

Lesson 8 - SQL Server 2008 Reporting Services Enhancements
◦Reporting Services Architecture and Management
◦Authoring Reports
◦Report Processing and Rendering

Lesson 9 - SQL Server 2008 Analysis Services Enhancements
◦Multidimensional Analysis with SQL Server Analysis Services
◦Data Mining with SQL Server Analysis Services
Guaranteed to run courses