Font size:

Description:

This is a bundled training package. It contains training for each of the bundled items below:

Course Price
Deploying and Delivering SQL Server 2008 Reporting Services Reports $74.95
Maintaining SQL Server 2008 Reporting Services $74.95
Implementing SQL Server 2008 Analysis Services Solutions $74.95
Querying Cubes and Working with Data Mining in SSAS $74.95
Managing SQL Server 2008 Analysis Services Solutions $74.95

Bundle Price: $199.00
Total Savings: $175.75


Deploying and Delivering SQL Server 2008 Reporting Services Reports

This course discusses features and tasks performed by administrators when working with SQL Server 2008 Reporting Services (SSRS) reports and content. After reports have been created and formatted, it is time to make them available to the users that need them. This involves the process of deploying reports and the associated data. This course describes the various methods and processes involved in the deployment and execution of reports. It covers the publishing of reports using the Report Manager web interface and BIDS Report Designer tool. Also discussed is the use and creation of report models; report models are needed to create reports using the user-friendly Report Builder tool. Another key benefit of Reporting Services is interoperability with a range of external applications. This course provides an overview of rendering report data to applications using the Report Server Web Service, Report Viewer controls, and URL access. Also discussed are options that can be configured for the delivery of reports, including the use of report subscriptions, schedules, cached reports, and the use of snapshots. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • 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

Maintaining SQL Server 2008 Reporting Services

Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course outlines the tools used and tasks involved in managing and maintaining access to Reporting Services and corresponding data. It covers the authentication subsystem and role-based authorization model used by Reporting Services, as well as the configuration of system-level and item-level role-based security. SQL Server 2008 also provides the ability to deploy and manage the report server and content using the Report Server Web Service and command-line tools. This course describes how to use these tools to automate administrative tasks and manage reports remotely through the web interface. It also outlines the options for monitoring server performance, report activities, and statistics using performance counters and the use of log files in evaluating server status and performance. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • 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

Implementing SQL Server 2008 Analysis Services Solutions

SQL Server 2008 Analysis Services gives you the opportunity to take the vast amount of information in your databases and analyze it so that you can use the information to improve your overall business. This course will introduce you to SQL Server 2008 Analysis Services and look at the benefits your business can gain from it. It will also introduce the different types of analysis services solutions that can be implemented and how analysis services is installed on SQL Server 2008. This course will also cover the logical and physical architecture of Multi-dimensional Analysis Services and introduce the tools that can be used to manage and deploy analysis services. In addition, the course will discuss data sources and data source views, including how to create, modify, and delete them. This course will also show how to create a SQL Server 2008 Analysis Services cube. This includes how you would use the Cube Designer, how you would define dimensions, define hierarchies, and define attributes. In addition, it includes a discussion on how to define measures, measure groups, and calculations. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • 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

Querying Cubes and Working with Data Mining in SSAS

SQL Server 2008 Analysis Services takes relational data and provides a robust way to analyze it in a meaningful way through MDX queries and data mining. This course will introduce the fundamentals of querying multi-dimensional data. It will introduce the MDX language which used to query multi-dimensional data. This includes a discussion on how to create a basic MDX query, how to establish a cube context, how to build subcubes and named sets, and how data can be modified with MDX. The course also provides a review of Key Performance Indicators (KPI), Actions, Perspectives, Translations, and Stored Procedures. In addition, this course introduces data mining. It looks at the logical and physical architecture of data mining including data mining structures, models, and algorithms. Tools related to data mining such as the Data Mining Wizard, Data Mining Designer, and SQL Server Management Studio will also be discussed in this course. This course will also look at how you can create, view, validate, and query a data mining solution. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • 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

Managing SQL Server 2008 Analysis Services Solutions

SQL Server 2008 Analysis Services provides a powerful solution for analyzing extremely large amounts of data in a relational database. This course looks at Analysis Services from a management perspective. It outlines the considerations involved with deploying SSAS projects. This includes project deployments using various methods and synchronization. The course also covers analysis services security solutions related to securing an instance and securing user access. A discussion about disaster recovery, including high-availability solutions and backup solutions is also included in this course. In addition, the course looks at administration, including the tools that can be used to maintain analysis services, how you can process SSAS objects, and how you can use SQL Server Profiler to monitor analysis services.This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.
  • 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
Register Now
Microsoft SQL Server 2008: Business Intelligence Development and Maintenance Part 2 e-learning bundle
  • Course ID:
    252795
  • Duration:
    10 hours
  • Price:
    $199