After completing this course, the student should be able to:

• identify Business Intelligence technologies
• recognize how to install Integration Services
• recognize the features of SQL Server 2008 Integration Services
• recognize the tools in the Integration Services studios
• recognize how to create a data package
• verify and manage a data package
• use the SQL Server 2008 Integration Services tools

Duration: 1.5 hrs

After completing this course, the student should be able to:

• recognize how the connection manager works
• recognize how to work with control flows
• recognize how event handlers and Integration Services variables are used in SQL Server 2008
• recognize how to use Property Expressions in SQL Server 2008
• use checkpoints and transactions in SQL Server 2008
• recognize how to implement control flow
• recognize how to implement data flow
• create an SSIS solution
• create an SSIS data package flow

Duration: 2 hrs

After completing this course, the student should be able to:

• recognize how to store information in a log file
• recognize how to create a log on a server
• configure a package to handle bad data
• recognize how to perform debugging
• recognize ways to secure SSIS packages
• implement logging
• debug SSIS packages
• secure an SSIS package

Duration: 1.5 hrs

After completing this course, the student should be able to:

• recognize how to create a package configuration
• deploy SSIS packages
• manually execute SSIS packages
• schedule the execution of your SSIS packages
• use the SQL Server Import and Export Wizard to create a simple package
• set up the Deployment Bundle
• install and run SSIS packages

Duration: 1.5 hrs

After completing this course, the student should be able to:

• recognize what SQL Reporting Services is used for
• install Reporting Services
• configure Reporting Services
• recognize how to author SQL Server reports
• format reports in SQL Server 2008
• recognize how to filter data in SQL Server 2008 reports
• add interactivity to reports
• add expressions to reports
• add custom code in reports
• use reports in SQL Server 2008

Duration: 3 hrs

After completing this course, the student should be able to: 

• recognize how to deploy a report with SQL Server 2008
• recognize how report models are used
• recognize how to integrate with Report Server Web Service
• recognize how to integrate using URL Access
• recognize how to use ReportViewer controls
• create a schedule
• recognize how to set up subscriptions
• use report caching
• recognize how to create a report snapshot
• create report models
• create schedules and set up report caching

Duration: 2 hrs

After completing this course, the student should be able to:

• recognize how to configure SSRS
• recognize how to perform administration and maintenance of SSRS
• recognize the features of SSRS Security
• recognize how to create a new role
• recognize how to automate SSRS administration
• manage reporting services in SQL Server 2008
• recognize how to monitor and maintain SSRS performance

Duration: 1.5 hrs

After completing this course, the student should be able to:

• recognize the features of SQL Server 2008 Analysis Services
• install Analysis Services
• recognize how to implement multidimensional data
• implement a data source
• recognize how to use data source views
• recognize how to create an SSAS cube
• define dimensions, hierarchies, and attributes
• recognize how to use measures
• use calculations
• create a data source and data source view
• implement a SQL Server Analysis Services cube

Duration: 2.5 hrs

After completing this course, the student should be able to:

• recognize how to query cubes using MDX
• recognize how to work with KPIs
• create actions with SSAS
• recognize how data mining works
• recognize how to create a data mining solution
• query a data mining solution
• use drillthrough on a data mining solution
• use cubes in SQL Server 2008
• use data mining in SQL Server 2008

Duration: 2 hrs

After completing this course, the student should be able to:

• recognize methods for deploying a SQL Server Analysis Services project
• recognize how to implement security in SQL Server 2008 Analysis Services
• identify disaster recovery solutions for SSAS
• recognize how to back up and restore an SSAS database
• detach and attach an SSAS database
• manage SQL Server 2008 Analysis Services
• recognize how to monitor an SSAS instance
• administer SQL Server 2008 Analysis Services

Duration: 2 hrs