This is an intermediate to advanced level course. After discussing the components of the data warehouse and data warehousing, the course elaborates on the essential physical design and phases of an Oracle data warehouse (DW). Particular emphasis is placed on the following:
Upon completion of this course, attendees should be able to translate logical DW design specifications into an Oracle physical design model; and in turn, create the necessary scripts (e.g., DDL) to install a large scale partitioned DW, using, amongst other things, bitmap indexes.
This course is intended for database administrators and system administrators.
Delegates should have a working knowledge of the Oracle database, its architecture, objects and SQL.
This course is available on site only. Please call for details.
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.