Instructor Led Etl Training in United Kingdom

Data Warehousing Fundamentals training course This dimensional modelling techniques course is designed to answer questions, such as the following: - What is data warehousing? - What is a data mart? - What are the data modelling options? - What is Extract, Transform and Load (ETL)? - What are the terms and concepts specific to data warehousing and OLAP design? - How to plan and implement a data warehouse with high availability,  more...

Advanced SQL Server 2005 Integration Services SSIS for Developers ...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: -  more...

SQL Server 2005 Integration Services SSIS Fundamentals This presentation provides detailed treatment of the following SQL Server 2005 Integration Services (SSIS) topics: - Creating and managing SSIS packages - Connecting to, querying and transforming disparate data sources - Scripting - Business Intelligence and data warehousing considerations - Event handling - SSIS problem determination - And the like. Prerequisites: At least six (6)  more...