QuickStart Intelligence - Computer Training for IT Professionals and Developers
Search Courses
QuickStart Intelligence is a Microsoft Gold Certified Partner. Winner! Microsoft Worldwide Training Partner of the Year in 1996, 2000, 2005
Redeem your Microsoft Software Assurance Training Vouchers with QuickStart Intelligence
IT Training & Certifications Courses Business Intelligence Training Course MCTSBI08

MCTSBI08 - Microsoft SQL Server 2008 Business Intelligence Bootcamp

Course MCTSBI08
Cost: $3,595.00
Software Assurance Value: 9       This course can be paid for using your organization's Microsoft Software Assurance Training Vouchers
Duration: 5 Days
Click here to request a Business Intelligence class in your area
MCTSBI08 - Microsoft SQL Server 2008 Business Intelligence Bootcamp training
Introduction
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.

Prerequisites:
  • 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)


    • 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™
    Click "ENROLL" to register for this course
    Course Date Time Location Availability
    9/20/2010 8:00AM - 6:00PM Brea
    ENROLL
    9/20/2010 8:00AM - 6:00PM Irvine
    ENROLL
    9/20/2010 8:00AM - 6:00PM Los Angeles PCD
    ENROLL
    9/20/2010 8:00AM - 6:00PM QSLive@Home
    ENROLL
    9/20/2010 8:00AM - 6:00PM San Diego
    ENROLL
    9/20/2010 8:00AM - 6:00PM San Francisco
    ENROLL
    9/20/2010 8:00AM - 6:00PM San Jose
    ENROLL
    10/18/2010 8:00AM - 6:00PM Brea
    ENROLL
    10/18/2010 8:00AM - 6:00PM Irvine
    ENROLL
    10/18/2010 8:00AM - 6:00PM Los Angeles PCD
    ENROLL
    10/18/2010 8:00AM - 6:00PM QSLive@Home
    ENROLL
    10/18/2010 8:00AM - 6:00PM San Diego
    ENROLL
    10/18/2010 8:00AM - 6:00PM San Francisco
    ENROLL
    10/18/2010 8:00AM - 6:00PM San Jose
    ENROLL
    12/6/2010 8:00AM - 6:00PM Brea
    ENROLL
    12/6/2010 8:00AM - 6:00PM Irvine
    ENROLL
    12/6/2010 8:00AM - 6:00PM Los Angeles PCD
    ENROLL
    12/6/2010 8:00AM - 6:00PM QSLive@Home
    ENROLL
    12/6/2010 8:00AM - 6:00PM San Diego
    ENROLL
    12/6/2010 8:00AM - 6:00PM San Francisco
    ENROLL
    12/6/2010 8:00AM - 6:00PM San Jose
    ENROLL
    2/7/2011 8:00AM - 6:00PM Brea
    ENROLL
    2/7/2011 8:00AM - 6:00PM Irvine
    ENROLL
    2/7/2011 8:00AM - 6:00PM Los Angeles PCD
    ENROLL
    2/7/2011 8:00AM - 6:00PM QSLive@Home
    ENROLL
    2/7/2011 8:00AM - 6:00PM San Diego
    ENROLL
    2/7/2011 8:00AM - 6:00PM San Francisco
    ENROLL
    2/7/2011 8:00AM - 6:00PM San Jose
    ENROLL

    Can't find a class in your area?

    Home | Services | Training | Classroom Rentals | Schedules | Locations | About QuickStart | Contact Us
    Microsoft | Business Skills | Cisco | Citrix | CompTIA | Crystal Reports | Development | Java/J2EE | Oracle | Security | VMware
    Learning Centers located in: Brea | Irvine | Los Angeles | San Diego | San Francisco | San Jose | QSLive™ - Distance Learning
    © 2010 QuickStart Intelligence, Inc. All Rights Reserved. Site Map | Terms of Use | Privacy Statement