Sql Server SSRS/ SSIS

For clarifications, contact ANIL AILANI SIR-9819704277 OFFICE-022-66730730/9892841512

Click here to download the .pdf file of the contents

Advanced Microsoft Business Intelligence (MSBI) -SSRS SSIS

SSRS

Duration-12 Hours

Pre-requisites:
Basics of RDBMS, SQL server 2005/2008 Query writing, SQL Tables and Stored Procedures

  • Overview / what is SSRS?
  • Other Reporting tools in market, Diff between SSRS 2005 and SSRS 2008
  • SSRS Architecture
  • SSRS Configuration
  • SSRS Development:
    • Reporting Service
    • Reporting Server
    • Reporting Server databases
    • Reporting Designer
    • Report Builder
    • Reporting Manager
    • Report Viewer
  • Report Development using WIZARD / without wizard
  • Report Deployment
  • QnA/Interview questions discussion

SSIS

Duration-12 Hours

Pre-requisites:
Basics of RDBMS, SQL server 2005/2008 Query writing, SQL Tables and Stored Procedures

  • Overview of ETL/ What is SSIS?
  • Other Integration tools in market
  • SSIS Architecture
  • SSIS Components
  • SSIS Packages Development:
    • Simple SSIS Demo
    • Types of Transformations
    • Logging
    • Package Configurations
    • Error Handling
  • SSIS Packages Deployment
  • QnA/Interview questions discussion