SQL SERVER / MSBI:SSIS,SSAS,SSRS ONLINE TRAINING,CORPORATE TRAINING,INTERVIEW SUPPORT & JOB SUPPORT BY SOFTWARE WORKING FACULTY

FOR FREE DEMO contact :
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in

SQL Server/MSBI:SSAS,SSIS,SSRS Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments,Resume Preparation Will be provided

SQL SERVER 2008/R2 MSBI (SSRS, SSIS, SSAS) ONLINE TRAINING COURSE OUTLINE

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



FOR More Details contact us at:
Email : raj@apex-online-it-training.com
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : raavi.sriraja@gmail.com
Blog: http://apex-it-online-trainings..in