5. SQL Server 2005 Reporting Services
This lab steps you through using the Report Wizard to create a list-style report. You also learn how to use the Report Manager to manage and secure reports.
4. SQL Service 2005 Report Builder
Building on the foundation of the Reporting Services lab, the Report Builder lab shows you how to use the Model Designer to generate a report model. You also work with the report model item properties, learning how they influence end-user reporting capabilities.
3. SQL Server 2005 T-SQL Enhancements
As you'd expect, in this virtual lab you can find a collection of new T-SQL functions and capabilities.You can learn how to use the new PIVOT and UNPIVOT statement and how to use common table expressions (CTEs) to create recursive queries. In addition, you can see how the new Data Definition-Language (DDL) trigger and the new T-SQL Try-Catch exception handling work.
2. SQL Server 2005 Analysis Services
In this virtual lab, you see how to use the Business Intelligence Development Studio (BIDS) to create an Analysis Services cube along with its dimensions and hierarchies. You also step through how to create calculated members and use Key Performance Indicators (KPIs).
1. SQL Server 2005 Integration Services
SQL Server 2005 Integration Services (SSIS) is one of the biggest areas of change in SQL Server 2005 and learning how to use it can be one of the bigger hurdles in migrating. This virtual lab shows you how to use BIDS to create a new SSIS package.You also learn how to log the execution of your SSIS package's progress to a text file in the Windows Event Log, as well as how to monitor the progress of a SSIS package.