Detailed information
| Duration: | 3 Days |
|---|---|
| Price: | £1,250 (GBP plus VAT) |
| Type: | Training |
| Method: | In a classroom |
| Prepares for: | Upon completion of this course, the delegate should be able to use a variety of SSIS control and data flow facilities to design, develop and maintain simple-to-complex ETL solutions. |
| Geared towards: | SQL Server 2005/2008 developers in particular and DBAs in general. |
| Requirements: | Completion of our course SQL Server 2005/2008 Integration Services Fundamentals or equivalent knowledge. |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
As SSIS is mainly an Extract, Transform and Load (ETL) tool and since ETL has been accepted as being between 70-80% of the data warehouse maintenance challenge, this course is accordingly dedicated. After discussing advanced features of the SSIS control and data flow engines, delegates will be taught how to design, develop and implement an SSIS-based ETL system, accounting for some of the more common and complex requirements, including:
Source-to-destination mapping
Change Data Capture (CDC)
Extraction (e.g., incremental)
Staging tables
Slowly Changing Dimensions
Late arriving (inferred) dimensions
Late arriving facts
Fact aggregation
Data profiling
Audit
Pipeline (data flow) performance & tuning
Source-to-destination mapping
Change Data Capture (CDC)
Extraction (e.g., incremental)
Staging tables
Slowly Changing Dimensions
Late arriving (inferred) dimensions
Late arriving facts
Fact aggregation
Data profiling
Audit
Pipeline (data flow) performance & tuning
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- Regus Centre, First Point, Buckingham Gate, London Gatwick Airport, Gatwick RH6 0NT - RH6 0NTGreater London (England)
Wise Ltd.
IT training company specialising in database and data warehousing training on SQL Server, Oracle and DB2 platforms. Public courses take place at London Gatwick. Onsite training available throughout the UK and Europe.
