Designing High Performance Data Warehouses with SQL Server Integration Services: Seminar

Description

Just knowing how to use SSIS is often not enough when faced with challenging processing requirements or complicated environments. This course takes IT professionals, DBAs and developers to a deeper level of SSIS skills maturity. By the end of the seminar, students will have the knowledge on how to architect SSIS solutions and deal with advanced requirements for data cleansing and data warehousing.

Audience

This course is intended for solution architects, DBAs, and developers who work with SSIS and are responsible for ETL for high performance data warehousing or data architecture planning.

While based on SQL Server 2008 R2, the course is equally applicable to those working with SQL Server 2005, SQL Server 2008 & 2012 Differences in the versions will be highlighted.

Course Outline

1. Introduction to dimensional modelling
2. SSIS Control Flow & Data Flow
3. High Performance Dimension and Fact table load with type 2 changes
4. Advance SSIS loads
5. SSIS deployment and management

Location Details

Sydney	Mentor Paco Gonzalez

Related Links

• SSW's Rules to Better Scrum with TFS
• Accentient Scrum Developer Training
• Microsoft - Professional Scrum Developer Program
• Scrum.org
• Book a SSW Scrum Master for your project
• SSW 8 Steps to Scrum PDF