Data Warehouse Administration
Seminar / Training Data Warehouse Administration
- plan a data warehouse system with Oracle
- Parallel processing
- ETL
- Materialized Views under Oracle
- Star Schema Optimization
Detailed seminar content
- Parallel processing under Oracle
- Degree of Parallelism (DOP)
- Parallel Query
- Parallel DDL and DML
- Space Management in Parallel Processing
- Parallel DML and locking
- Tuning and automatic tuning
- Partition-Wise Join
- ETL
- External Tables
- Pipelined Table Functions
- Create Materialized Views
- Integrity for Materialized Views
- Refresh Methods
- Partition Change Tracking (PCT) Refresh
- Refresh Types in Oracle
- Dimensions and Hierarchies in Oracle Data Warehouses
- the Query Rewrite
- the Summary Advisor
- Optimization of a Star schema
- Star Transformation
- Creating Bitmap Join Indexes
Requirements
This seminar has the level "Administration / Basic andstructure".
If you are not sure whether this course is the right level for you, you can check this with the trainer in advance.
We conduct this seminar online for you. You can book the training as a public seminar or as a company seminar. The practical exercises are carried out in our Remotelab and make up 40-50 percent of the seminar.
Your contacts
-
Promise Akachukwu Kelechi
E-Mail: promise@computer-training.ng
Phone: +234 1 227 9218 -
Peter Chidiebere Ugochukuw
E-Mail: peter@computer-training.ng
Phone: +234 1 227 9218 -
Raphael Chukuwgozie Ndubuisi
E-Mail: raphael@computer-training.ng
Phone: +234 1 227 9218
We offer seminars with a high practical relevance. The contents and exercises are geared to your daily tasks in the company and completely dispense with advertising references to other products of the software manufacturer.
All our training courses are manufacturer-independent. This enables us to offer critical considerations of the products themselves and comparisons with competitors of the manufacturer in the seminar. The course contents are our own and derived from the practical experience of our trainers in projects.
Of course, the contents of company seminars can be individually adapted to your needs. Please do not hesitate to contact us.
- Implementation guarantee - Implementation guarantee for two or more participants
- Mobile classrooms - the ideal complement for company seminars
- Free support - for questions after the seminar
- Delivery on account - no prepayment required
- Interview with the trainer / quality assurance - get to know and assess the trainer in advance
- Clarify seminar requirements - review your knowledge with the trainer
- Assistance with travel costs - we cover part of the costs of hotel accommodation
- Meals - all day cold / hot drinks and a full lunch in the restaurant
- Location of training centres - always centrally located and easily accessible
- Discount - we have attractive prices, take advantage of our additional discounts
- Remotelabs - rent our Remotelabs for your own seminars or as a complement to your company seminars
Oops, an error occurred! Code: 2024112115093907977c58