Updating Your SQL Server 2005 Skills to SQL Server 2008

Module 1: Introduction to SQL Server 2008

• The Evolution of SQL Server
• Preparing for SQL Server 2008 

Lab 1: Exploring SQL Server Books Online

• Reviewing the SQL Server Books Online Tutorials
• Reviewing SQL Server Books Online
  

Module 2: SQL Server 2008 Manageability Enhancements

• Configuration Servers
• Policy-Based Management

Lab 2: Managing SQL Server 2008

• Creating a Configuration Server
• Creating and Applying a Policy
  

Module 3: SQL Server 2008 Performance Enhancements

• Managing Workloads with Resource Governor
• Monitoring Performance with the Data Collector
• Managing Performance with Plan Freezing

Lab 3: Optimizing SQL Server 2008

• Using Resource Governor
• Using the Data Collector
  

Module 4: SQL Server 2008 Security Enhancements

• Encrypting Databases
• Auditing All Actions 

Lab 4: Securing a SQL Server 2008 Database

• Using Transparent Data Encryption
  

Module 5: SQL Server 2008 Database Development Enhancements

• Developer Tool Enhancements
• Data Type Enhancements
• Working with Spatial Data

Lab 5: Developing Databases with SQL Server 2008

• Using Date and Time Data Types
• Using Spatial Data
  

Module 6: SQL Server 2008 Availability Enhancements

• Always On Technologies
• Transactional Peer-to-Peer Replication 

Lab 6: Maintaining High Availability

• Configuring Peer-to-Peer Replication
• Adding a Replication Node
  

Module 7: SQL Server 2008 Data Warehousing Enhancements

• ETL Enhancements
• Using Partitioned Tables
• Optimizing Data Storage

Lab 7: Data Warehousing with SQL Server 2008

• Using Change Data Capture
• Using the MERGE Statement
• Working with Partitioned Data
  

Module 8: SQL Server 2008 Reporting Services Enhancements

• Reporting Services Architecture and Management
• Authoring Reports
• Report Processing and Rendering 

Lab 8: Using SQL Server 2008 Reporting Services

• Creating a Report with Report Designer
• Managing Reporting Services
  

Module 9: SQL Server 2008 Analysis Services Enhancements

• Multidimensional Analysis with SQL Server Analysis Services
• Data Mining with SQL Server Analysis Services 

Lab 9: Using SQL Server 2008 Analysis Services

• Implementing Multidimensional Analysis
• Implementing Data Mining