MS6158A Updating Your SQL Server 2005 Skills to SQL Server 2008

Module 1: Introduction to SQL Server 2008

Lessons

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

After completing this module, students will be able to:

• Describe the evolution of SQL Server.
• Prepare for SQL Server 2008.

Module 2: SQL Server 2008 Manageability Enhancements

Lessons

• Configuration Servers
• Policy-Based Management

After completing this module, students will be able to:

• Create and use a configuration server.
• Create and use policies.

Module 3: SQL Server 2008 Performance Enhancements

Lessons

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

After completing this module, students will be able to:

• Manage workloads with Resource Governor.
• Monitor performance with the Data Collector.
• Manage performance with Plan Freezing.

Module 4: SQL Server 2008 Security Enhancements

Lessons

• Encrypting Databases
• Auditing All Actions

After completing this module, students will be able to:

• Encrypt databases.
• Audit all actions.

Module 5: SQL Server 2008 Database Development Enhancements

Lessons

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

After completing this module, students will be able to:

• Describe the developer tool enhancements in SQL Server 2008.
• Use the data type enhancements in SQL Server 2008.
• Work with spatial data.

Module 6: SQL Server 2008 Availability Enhancements

Lessons

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

After completing this module, students will be able to:

• Describe the SQL Server 2008 always on technologies.
• Implement transactional peer-to-peer replication.

Module 7: SQL Server 2008 Data Warehousing Enhancements

Lessons

• ETL Enhancements
• Using Partitioned Tables
• Optimizing Data Storage

After completing this module, students will be able to:

• Describe the ETL enhancements in SQL Server 2008.
• Use partitioned tables.
• Optimize data storage.

Module 8: SQL Server 2008 Reporting Services Enhancements

Lessons

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

After completing this module, students will be able to:

• Describe the Reporting Services architecture and management.
• Author reports.
• Understand report processing and rendering.

Module 9: SQL Server 2008 Analysis Services Enhancements

Lessons

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

After completing this module, students will be able to:

• Implement multidimensional analysis.
• Implement data mining