Participants learn about Oracle’s Database partitioning architecture and how to identify the benefits of partitioning in addition to using parallel operations to reduce response time for data-intensive operations. Participants extract, transform, and load data into an Oracle database warehouse. Participants also use materialized views to improve the data warehouse performance and learn how query rewrites can improve performance.
The usage of SQL Access Advisor to optimize the entire workload, tuning materialized views for fast refresh and query rewrite and also how to use the compression and resumable sessions features are discussed.
Koenig offers Oracle Database 11g: Administer a Data Warehouse New Training Boot Camp in 4 different locations in India - Delhi, Dehradun, Shimla(Himalayas) and Goa Beach.
Schedule for Oracle Database 11g: Administer a Data Warehouse New Training Boot Camp
Regular Track (days)
Oracle Database 11g: Administer a Data Warehouse New
Balance Days for day of arrival, exam and practice
Ability to read and understand execution plans
Good working knowledge of SQL and in data warehouse design and implementation
Data Warehouse design, implementation, and maintenance experience
Related Boot Camps:
Oracle Database 10g: Backup and Recovery |
Pre-course technical evaluation and baseline training
» Hands-on classroom training
» Official Curriculum
» Single occupancy room and all meals
(breakfast, lunch & dinner)*
» Free Wi-Fi Internet
in the training centre
» Three months after-course usability reinforcement
» Airport pick and drop*
» Daily transport to training centre*
» Hospitality Desk Support - Renting / buying mobile phone, laptop, tours, etc.
» Travel from Delhi to Shimla / Dehradun & back by Train / Volvo and 2 transit nights stay in Delhi (if your training is in Shimla / Dehradun)
Koenig Prices include all costs from the time you arrive in India till you fly back.
Applicable if you opt for accommodation provided