Description

SQL Server Integration Services (SSIS)

Course Contents

• Introductory topics:
  • Overview of ETL Concepts
  • Introduction to SSIS as a tool
• SSIS Environment Overview
  • Control Flow
  • Data Flow
  • Event Handlers
• Basic data exchange methods
  • Using Import and Export Wizard
  • Running an Integration Services Packages
• Data Flow Components
  • Data Flow Source
  • Data Flow Transformation
  • Data Flow Destination
• Data Flow Transformation Components
  • Aggregates
  • Conditional Split
  • Derived Column
  • Merge
  • Merge Join
  • Multicast
  • Sort
  • Union All
• Control Flow Components
  • For Loop Container
  • For-Each Loop Container
  • Bulk Insert Task
  • Execute SQL task
  • Precedence Constraints
  • Using Variables
  • OLE DB Source & Destination Properties
  • Error Handling/Trouble Shooting Packages
  • Break Points and Check Points
  • Dynamic Connections
  • Deploying a package
  • Schedule the package
  • Command line utilities

SQL Server Analysis Services (SSAS)

Course Contents

• Basic concepts of Facts, Measures, Dimensions, OLAP, OLTP
• Understanding the development environment
• Intro to Data Warehouse
• Intro to Dimension Modeling
• Schemas – Star and Snow Flake Schema
• Hierarchies, Dimension and Facts
• Types of Hierarchies
• FactLess Fact Table
• Creating Data Sources
• Creating Data Source Views
• Creating Cubes
• Refining Dimensions and Measures in BIDS
• Intro to MDX
• KPIs
• Perspectives
• Aggregations
• Partitions
• Build and Deploy the cube
• Process Options
• Storage Modes – MOLPA, ROLAP, HOLAP
• Types and Facts and Dimensions
• Security
• Deploying Cube and Schedule the process
• Performance Tips

SQL Server Reporting Services (SSRS)

Course Contents

• Introduction to Reporting Concepts
• New Environment of SSRS
• Creating Report By Wizard
• Page-wise Reports
• Group Report
• Creating a Report without wizard
• Concept of Tablix
• Sub-Totals
• Matrix Report
• Parameter Report
• Filtering data
• Chart/Gauge/Indicator etc
• Format Property
• Aggregate Functions in Reports
• Running Totals
• Document Map/Sub Reports
• Drill Down and Drill Thru Reports
• Cascade Parameter Reports
• Build and Deploy Reports to Report Server
• Configure Report Server
• Linked Reports
• Subscriptions – Standard and Data Driven Subscriptions
• Cache/Snapshot
• SSRS Logging