AmeriTeach - Computer Training Microsoft Gold Partner For Learning

 

SQL BI Boot Camp

Course 16299: 6 days; Instructor-Led

 

Attend 6 days to get certified as:  

 

MCTS: SQL Server 2008, Business Intelligence Development and Maintenance

Exams include:

Boot Camp format

Boot Camp runs 8am 7pm each day Monday Saturday

All classes are hands on with our expert Microsoft Certified SQL Server instructor.

What you will receive:

  • SQL Server Library of Books including:
    • Microsoft SQL Server 2008 Reporting Services  ISBN 0071548084
    • Microsoft SQL Server 2008 Integration Services ISBN - 0470496924
    • Delivering Business Intelligence with Microsoft SQL Server 2008  ISBN 0071549447
  • Microsoft Official SQL Server Courseware for:
    • Course 6234 Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services
    • Course 6235 - Implementing and Maintaining Microsoft SQL Server 2008 Integration Services
    • Course 6236 - Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services
  • Test prep materials
  • Exam voucher
  • All meals:

    • Continental Breakfast
    • Lunch
    • Dinner

Prerequisites

Participants should be have the following before beginning the course:

  • 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 Microsoft SQL Server (SQL Queries, SQL Server Agent, SQL Systems Tables, SQL Accounts)

 

Boot Camp Outline

Day One: Course 6235 - 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

 

Day Two: Course 6235 (cont'd)

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

Day Three: Course 6234 - Microsoft SQL Server 2008 Analysis Services

Lesson 1: Creating Multidimensional Analysis Solutions

  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

Day Four: Course 6234 (cont'd)

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

Day Five: Course 6236 - 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

Day Six: Course 6236 (cont'd)

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


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



 

 

 

 

 

 

 
 

For more information call 720.346.1710 or visit: www.ameriteach.com

7800 E. Dorado Place, Greenwood Village, CO 80111