Find Courses Find Providers Providers - Promote Your Courses About Us

Oracle Data Warehouse Design

Training Courses

Would you like to see more Data warehousing courses?

Training course summary

Sponsored links

SUMMARY: After presenting entity relationship (ER) and dimensional modelling (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 (summary tables)

Regions:
  • All Areas
Delivery:
  • In House
Category:
Difficulty:
  • Not applicable

Further Details

CURRENCY: 9i & 10g DURATION: 5 days AUDIENCE: DW architects and DBAs PREREQUISITES: Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge. OBJECTIVES: Upon completion of this course, the participant should be able to monitor and tune large data warehouses in a BI (Business Intelligence) or DS (Decision Support) environment.

Guide price

see website www.wiselimited.com

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net