Training : TRN 501 : Oracle 11g Data Warehouse Design
This seminar-style course teaches delegates the fundamentals of designing an Oracle data warehouse. The first part of the course focuses on logical design and data modelling. Next, physical design for an Oracle data warehouse is considered before wrapping up the course with sections on managing the data warehouse and its data.
Topics covered in this 2-day course include:
Day 1
- Oracle 11g Data Warehouse Design ETL and Data Loading
- Indexing – Bitmap Indexes, Bitmap Join
- Indexes, Indexing for Star Transformations
- Index Tuning using the SQL Access Advisor
Day 2
- Partitioning, Compression & Parallel Execution
- SQL for Analysis, Data Mining
- Summarization & Oracle OLAP
- Data Warehouse Optimization & Tuning
This course includes slides and delegate notes, and can be delivered on-site or through partner organizations. Quotations can be provided for custom versions of this course using your own data, or to include additional areas not covered in the regular agenda.
To book this course for your organization, or for more information, contact training@rittmanmead.com
