MCTSBI08 - Microsoft SQL Server 2008 Business Intelligence Bootcamp (MCTSBI08)

Course MCTSBI08

Price: $3,695.00
Software Assurance Value: 9
Duration: 5 Days
Software Assurance

  • Your Home
  • Your Office
  • Your local QS Training Center
  • 100% Satisfied or your money back
  • Cancellation Free Schedule
  • Version Upgrade Discount
  • Corporate Resource Guarantee
  • 4x Microsoft Training partner of the year
  • Highest Student Satisfaction Rating
  • Won 23 prestigious Microsoft nation-wide awards
This course is currently only available on a request basis.
  • Couse Description

  • Testimonials

Course Description PDF

Description

The MCTS: SQL Server 2008 Business Intelligence (BI) Boot Camp is an instructor led fundamental course that focuses on Microsoft SQL Server Integration Services, Analysis Services, and Reporting Services. It is an intensive program designed for IT professionals with solid fundamental SQL Server experience. The Boot Camp hours are from 8:00 AM to 6:00 PM, Monday through Friday.

This course discusses how to use the BI development tools to create Analysis Services databases, OLAP cubes, Integration Services packages, Reporting solutions and how to use the SQL Server 2008 management and administrative tools to manage Microsoft SQL Server 2008 BI solutions. We will also look at the comparison/contrast between the SQL 2005 and SQL 2008 versions.

The boot camp provides students with the knowledge and the skills that are required to take Microsoft Exam 70-448 (Microsoft SQL Server 2008 Business Intelligence - Implementation and Maintenance). Students will receive Transcender self-paced test prep software. The test-prep software provides a realistic simulation of the Microsoft certification exam to help prepare the student to apply the knowledge taught in class for the exam.


Audience Profile

This intense Boot Camp is designed for IT professionals with solid fundamental SQL Server experience.

Return to Top


Prerequisites

Before beginning this course, students must have:

  • Exposure to Data Import/Export Scenarios
  • Conceptual Understanding of OLAP Solutions
  • Exposure to Report Creation (Access, Crystal, Etc,...)
  • Experience with Windows Services
  • Experience with Service Accounts and Permissions
  • Experience with Navigating the Microsoft SQL Server (SQL Queries, SQL Server Agent, SQL Systems Tables, SQL Accounts)

Return to Top


Microsoft Certified Professional Exams

Microsoft Exam 70-448 (Microsoft SQL Server 2008 Business Intelligence - Implementation and Maintenance)

Students will receive Transcender self-paced test prep software. The test-prep software provides a realistic simulation of the Microsoft certification exam to help prepare the student to apply the knowledge taught in class for the exam.

Return to Top


Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Return to Top


Course Outline

Section One: Microsoft SQL Server 2008 Integration Services

Lesson 1: Introduction to SQL Server 2008 Integration Services

  • Overview of SQL Server Integration Services
  • Using Integration Services Tools

Lesson 2: Developing Integration Services Solutions

  • Creating an Integration Services Solution
  • Using Variables
  • Building and Running a Solution

Lesson 3: Implementing Control Flow

  • Control Flow Tasks
  • Control Flow Precedent Constraints
  • Control Flow Containers

Lesson 4: Implementing Data Flow

  • Data Flow Sources and Destinations
  • Basic Data Flow Transformations
  • Advanced Data Flow Transformations
  • Data Flow Paths

Lesson 5: Implementing Logging

  • Overview of Integration Services Logging
  • Using Logging

Lesson 6: Debugging and Error Handling

  • Debugging a Package
  • Implementing Error Handling

Lesson 7: Implementing Checkpoints and Transactions

  • Implementing Checkpoints
  • Implementing Transactions

Lesson 8: Configuring and Deploying Packages

  • Package Configurations
  • Preparing and Deploying Packages

Lesson 9: Managing and Securing Packages

  • Managing Packages
  • Securing Packages

Section Two: Microsoft SQL Server 2008 Analysis Services

Lesson 1: Introduction to Microsoft SQL Server 2008 Analysis Services

  • Overview of Data Analysis Solutions
  • Overview of SQL Server Analysis Services
  • Installing SQL Server Analysis Services

Lesson 2: Creating Multidimensional Analysis Solutions

  • Developing Analysis Services Solutions
  • Creating Data Sources and Data Source Views
  • Creating a Cube

Lesson 3: Working with Cubes and Dimensions

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes

Lesson 4: Working with Measures and Measure Groups

  • Working With Measures
  • Working with Measure Groups

Lesson 5: Querying Multidimensional Analysis Solutions

  • MDX Fundamentals
  • Adding Calculations to a Cube

Lesson 6: Customizing Cube Functionality

  • Implementing Key Performance Indicators (KPI)
  • Implementing Actions
  • Working with Perspectives
  • Working with Translations

Lesson 7: Deploying and Securing an Analysis Services Database

  • Deploying an Analysis Services Database
  • Securing an Analysis Services Database

Lesson 8: Maintaining a Multidimensional Solution

  • Configuring Processing
  • Logging, Monitoring, and Optimizing an Analysis Services Solution
  • Backing Up and Restoring an Analysis Services Database

Lesson 9: Introduction to Data Mining

  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating Data Mining Models

Section Three: Microsoft SQL Server 2008 Reporting Services

Lesson 1: Introduction to Microsoft SQL Server 2008 Reporting Services

  • Overview of SQL Server Reporting Services
  • Installing Reporting Services
  • Reporting Services Tools

Lesson 2: Authoring Basic Reports

  • Creating a Basic Table Report
  • Formatting Report Pages
  • Calculating Values

Lesson 3: Enhancing Basic Reports

  • Interactive Navigation
  • Displaying Data

Lesson 4: Manipulating Data Sets

  • Defining Report Data
  • Using Parameters and Filters
  • Using Parameter Lists

Lesson 5: Using Report Models

  • Creating Report Models
  • Using Report Builder

Lesson 6: Publishing and Executing Reports

  • Publishing Reports
  • Executing Reports
  • Creating Cached Instances
  • Creating Snapshots and Report History

Lesson 7: Using Subscriptions to Distribute Reports

  • Introduction to Report Subscriptions
  • Creating Report Subscriptions
  • Managing Report Subscriptions

Lesson 8: Administering Reporting Services

  • Reporting Server Administration
  • Performance and Reliability Monitoring
  • Administering Report Server Databases
  • Security Administration
  • Upgrading to Reporting Services 2008

Lesson 9: Programming Reporting Services

  • Querying for Server Information Using a Web Service
  • Automating Report Management
  • Rendering Reports
  • Creating Custom Code

Microsoft SQL Server 2008 Business Intelligence MegaLab


Most Recent Customer Reviews

I appreciated the instructor going into real world scenarios and explaining the course content in the context of the real world
It was nice having the two monitors since the books were online.
I would have liked more time to investigate deployment, security, permissions....best practices for deployment and config (from dev to test to prod). That is where we have the most pain.
Like the additional information on other versions
It was very technical and granular at times, but good to see all of the tools of the product.
I dont see any obvious areas that I could improve.
Steve did a good job relating the material in the courseware and off roading to cover some of the functionality in the newer versions of the software that are available.
Read more reviews