Course code: GOC617« Back

Micosoft SQL Server 2008/2008 R2 – Upgrading Business Intelligence Skills

GOPAS Official Curriculum This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department ( or business department (

AffiliateDurationCatalogue priceHandbook priceITB
Praha2 10 400 CZK included in course price 20
Brno2 10 400 CZK included in course price 20
Bratislava2 420,00 EUR included in course price 20

Required skills

Basic knowledge of T-SQL and relational databases

Teaching methods

Expert instruction with practical examples, computer practice

Course Outline

Improving Integration with SSIS

  • Learn how to integrate any data, including ADO.NET
  • Increase productivity by using VSTA for script components
  • Improve integration performance with Lookups
  • Use data profiling to improve data quality
  • Review new options for managing Slowly Changing Dimensions

Creating More Flexible and Richer Reports in SSRS

  • Learn how to accelerate authoring with an improved designer
  • Create more flexible reports with Tablix
  • Learn about rendering improvements
  • Add rich data visualization to reports
  • Using SSRS Management Tools for Supportability and Manageability
  • Understand architectural changes
  • Review scale-out options
  • Understand changes to management tools
  • Learn about memory management improvements
  • Leveraging SSRS Programmability in Your Applications

Accelerating SSAS Design and Performance

  • Learn how to accelerate database design with improved cube and dimension designers
  • Work with best practices alerts to improve database design
  • Add aggregations with the new aggregation designer
  • Monitoring and Managing an SSAS Server with New Tools
  • Learn how to use resource monitoring components
  • Review improvements to SSAS database backups
  • Understand scale-out options
  • Understand MDX improvements
  • Learn how subspace computations improve query performance
  • Review writeback improvements
  • Data Mining improvements in SQL Server 2008

Previous courses

no preceding courses

Next courses

no following course
publikace GOC617

included in course price
The prices are without VAT.