HOME | REGISTER | LOGIN | LABS | SUPPORT | ABOUT US

SQL Server 2008 R2 Labs

Try out one, two, or all seven of the virtual labs available in our hosted trial environment:

SQL Server 2008 R2 – Multi Server Management
In this hands-on-lab you will work with SQL Server 2008 R2 Multi Server Management features. At the end of this lab you will be able to configure a Utility Control Point, as well as manage and monitor multiple instances of SQL Server.
Level: 300

SQL Server 2008 R2 – PowerPivot
In this hands-on-lab you will explore PowerPivot with SharePoint 2010 Integration By the end of this lab you will be able to: use PowerPivot Data Load Data into PowerPivot from a Web source integrate PowerPivot in a SharePoint PowerPivot Gallery and use Data Access Expressions.
Level: 300

SQL Server 2008 R2 – Reporting Services
In this hands-on-lab you will use: Sparklines Databars and Indicators by creating reports using SQL Server 2008 R2 Report Builder.
Level: 300

SQL Server 2008 R2 – Master Data Services
In this hands-on-lab, you will perform several exercises to achieve a better understanding of the core capabilities and functionality of SQL Server Master Data Services (MDS) in SQL Server 2008 R2.
Level: 300

SQL Server 2008 R2 – StreamInsight
This Lab illustrates various aspects of Microsoft StreamInsight, the new Complex Event Processing (CEP) Platform developed by SQL Server. StreamInsight is a platform closely integrated with .NET and exposes several APIs to develop a custom CEP application.
Level: 300

SQL Server Integration Services - Introduction
In this hands-on-lab you will perform several exercises to achieve a better understanding of the core capabilities and functionality of SQL Server Integration Services (SSIS) in SQL Server 2008. You will start with the Import/Export Wizard to import data into the database. Import/Export wizard is great when you just need to move some data now. After using the import/export wizard you will learn to handcraft an SSIS package , you will start with basic exercises that create ETL (Extract Transfer Load) packages to perform basic data transformations using heterogeneous data sources.
Level: 300

SQL Server Integration Services – Intermediate to Advanced
In this hands-on-lab you will perform several exercises to achieve a better understanding of the advanced capabilities and functionality of SQL Server Integration Services (SSIS) in SQL Server 2008. You will learn how to perform lookups as well as implementing data caching and data profiling.
Level: 300