Course Content

1. Data warehousing & Business Intelligence

2. Introduction to Data warehousing & Business Intelligence SQL Server Business Intelligence 

• Course Agenda
• SQL Server Integration Services
• Introduction to SQL Server Integration Services
• Guided tour of Business Intelligence Development Studio
• Introduction to Data Flow
• Data Sources 2.7 Data Flow Transformations
• Advanced-Data Flow
• Data Flow Destinations
• Advanced Control Flow
• Variables and Configurations
• Debugging, Error Handling and Logging
• Extending SSIS through Custom Code – Scripting
• SSIS Package Deployment
• SSIS Package Management
• SSIS Lookup Transformation
• SSIS Scripting Knowledge using .net Technology