Educative Articles
© 2009 IT courses Certification. All Rights Reserved.
 
 
Data Warehousing Training Courses
Zoya Technologies, Leader in SAP Training and consulting is based in Central London. We provide Cost-effective, Specialized training to corporate and beginners through our highly expertise, industry Certified personnel in all modules of SAP.
 
Custom Search
After presenting entity relationship (ER) and dimensional modeling (DM) as competing alternatives, the presentation will focus on the use of DM techniques when developing and implementing a very large data warehouse. Using real-world business scenarios, SALES, for example, the instructor will coach the participants from logical through physical design of a data warehouse involving at least five dimensions and one-or-more star schemas. Thus hands-on exercises include: - Design and creation of dimensions - Design and creation of star schemas - Design and creation of hierarchies - Design and creation of indexes - Design and creation of integrity constraints - Extract, Transform and Load (ETL) options - Parallelism - Design and create materialized views.
This course is valuable for all those involved in major roles on a data warehouse project, from project managers to DBAs to data modelers and application developers. It is also ideal for IT professionals from various backgrounds including Information technology, who plan to cross train into Data warehousing and Dimensional modeling to enhance their careers.