5 Day Course
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
