SQL Server 2008/R2 MSBI (SSRS, SSIS, SSAS) ONLINE TRAINING
SQL Server 2008/R2
MSBI (SSRS, SSIS, SSAS) ONLINE TRAINING
Course
Duration: 35 Hours
FOR FREE DEMO contact us at:
EMail: info@apex-online-it-training.com
ABOUT THE TRAINER
- 12 YEARS OF INDUSTRY EXPERIENCE
- 7 YEARS OF EXPERIENCE IN ONLINE AND CLASSROOM TRAINING
SQL SERVER 2008/R2 MSBI (SSRS, SSIS, SSAS) ONLINE TRAINING COURSE CONTENT
SQL Server 2008/2008 R2 Integration Services
Module 1: Introduction
to SQL Server 2008 Integration Services
·
Overview of SQL Server Integration Services
·
Using Integration Services Tools
·
Using the Import and Export Wizard
·
Running an Integration Services Package
Module 2: Developing
Integration Services Solutions
·
Creating an Integration Services Solution
·
Using Variables
·
Building and Running a Solution
Module 3: Implementing
Control Flow
·
Control Flow Tasks
·
Control Flow Precedent Constraints
·
Control Flow Containers
Module 4: Implementing
Data Flow
·
Data Flow Sources and Destinations
·
Basic Data Flow Transformations
·
Advanced Data Flow Transformations
·
Data Flow Paths
Module 5: Implementing
Logging
·
Overview of Integration Services Logging
·
Enabling and Configuring Logging
Module 6: Debugging
and Error Handling
·
Debugging a Package
·
Implementing Error Handling
Module 7: Implementing
Checkpoints and Transactions
·
Implementing Checkpoints
·
Implementing Transactions
Module 8: Configuring
and Deploying Packages
·
Package Configurations
·
Deploying Packages
Module 9: Managing and
Securing Packages
·
Managing Packages
·
Securing Packages
SQL Server 2008/2008 R2 Analysis Services
Module 1: Introduction
to Microsoft SQL Server Analysis Services
·
Overview of Data Analysis Solutions
·
Overview of SQL Server Analysis Services
·
Installing SQL Server Analysis Services
Module 2: Creating
Multidimensional Analysis Solutions
·
Developing Analysis Services Solutions
·
Creating Data Sources and Data Source Views
·
Creating a Cube
Module 3: Working with
Cubes and Dimensions
·
Configuring Dimensions
·
Defining Attribute Hierarchies
·
Sorting and Grouping Attributes
Module 4: Working with
Measures and Measure Groups
·
Working With Measures
·
Working with Measure Groups
Module 5: Querying
Multidimensional Analysis Solutions
·
MDX Fundamentals
·
Adding Calculations to a Cube
Module 6: Customizing
Cube Functionality
·
Implementing Key Performance Indicators
·
Implementing Actions
·
Implementing Perspectives
·
Implementing Translations
Module 7: Deploying
and Securing an Analysis Services Database
·
Deploying an Analysis Services Database
·
Securing an Analysis Services Database
Module 8: Maintaining
a Multidimensional Solution
·
Configuring Processing
·
Logging, Monitoring, and Optimizing an Analysis
Services Solution
·
Backing Up and Restoring an Analysis Services Database
Module 9: Introduction
to Data Mining
·
Overview of Data Mining
·
Creating a Data Mining Solution
·
Validating Data Mining Models
Microsoft SQL Server 2008/2008 R2 Reporting Service
Module 1: Introduction
to Microsoft SQL Server Reporting Services
·
Overview of SQL Server Reporting Services
·
Installing Reporting Services
·
Reporting Services Tools
Module 2: Authoring
Basic Reports
·
Creating a Basic Table Report
·
Formatting Report Pages
·
Calculating Values
Module 3: Enhancing
Basic Reports
·
Interactive Navigation
·
Displaying Data
Module 4: Manipulating
Data Sets
·
Defining Report Data
·
Using Parameters and Filters
·
Using Parameter Lists
Module 5: Using Report
Models
·
Creating Report Models
·
Using Report Builder
Module 6: Publishing
and Executing Reports
·
Publishing Reports
·
Executing Reports
·
Creating Cached Instances
·
Creating Snapshots and Report History
Module 7: Using
Subscriptions to Distribute Reports
·
Introduction to Report Subscriptions
·
Creating Report Subscriptions
·
Managing Report Subscriptions
Module 8:
Administering Reporting Services
·
Reporting Server Administration
·
Performance and Reliability Monitoring
·
Administering Report Server Databases
·
Security Administration
·
Upgrading to Reporting Services 2008
Module 9: Programming
Reporting Services
·
Querying for Server Information Using a Web Service
·
Automating Report Management
·
Rendering Reports
·
Creating Custom Code