MS6158 Updating Your SQL 2005 Skills to SQL Server 2008

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

This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008.

Before attending this course, students must have experience developing or administering SQL Server 2005 databases.

Delegates will learn how to:
- Describe the new features of SQL Server 2008.
- Manage SQL Server 2008.
- Optimize SQL Server 2008.
- Secure a SQL Server 2008 Database.
- Develop databases with SQL Server 2008.
- Create and maintain highly available SQL Server 2008 databases.
- Create and use a SQL Server 2008 data warehouse.
- Use SQL Server 2008 Reporting Services.
- Use SQL Server 2008 Analysis Services

Module 1: Introduction to SQL Server 2008
Module 2: SQL Server 2008 Manageability Enhancements
Module 3: SQL Server 2008 Performance Enhancements
Module 4: SQL Server 2008 Security Enhancements
Module 5: SQL Server 2008 Database Development Enhancements
Module 6: SQL Server 2008 Availability Enhancements
Module 7: SQL Server 2008 Data Warehousing Enhancements
Module 8: SQL Server 2008 Reporting Services Enhancements
Module 9: SQL Server 2008 Analysis Services Enhancements