search3
    
    Oracle Database 11g: Administer a Data Warehouse

    QUICK

    INFORMATION

    course-duration

    4 Day(s) Course

    courseware

    Official Courseware

    certified-trainer

    Certified Trainer

    exam-voucher

    Exam Voucher

    one-o-one

    1:1 Training Available on Demand

    customize-batch

    Customize Your Batch

    Course Information

    This Oracle Database 11g Administer a Data Warehouse training by Mercury Solutions provides you with extensive knowledge to make you acquainted with the fundamentals of administration of a data warehouse. In this Oracle Training, you will be acquired with the skills to make the best use of Oracle Database features for improving the performance and management of a data warehouse.

    You will be instructed by experts to learn to extract the data, transform and load it into an Oracle database warehouse. You will also learn to discover how to use the SQL Access Advisor for optimizing the entire workload, and use the materialized views for improving data warehouse performance and to learn how the query rewrites can improve the performance.

    90 days for training on demand

    COURSE OUTLINE

    Module 1: Introduction

    Module 2: Overviewing Data Mining Concepts

    Module 3: Understanding the Data Mining Process

    Module 4: Introducing Oracle Data Miner 11g Release 2

    Module 5: Using Classification Models

    Module 6: Using Regression Models

    Module 7: Performing Market Basket Analysis

    Module 8: Using Clustering Models

    Module 9: Performing Anomaly Detection

    Module 10: Deploying Data Mining Results

     

    WHO SHOULD ATTEND

    • Application Developers

    • Database Administrators

    • Business Analysts

    • Data Warehouse Analyst

    Pre-requisites

    • 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

     

    Exam

    Name Code Fee

    enquiry

    ENQUIRY FORM

    What Our Trainees Say

    Mercury Solutions Ltd. https://bit.ly/2H3ANjF is rated 4.6 stars by www.facebook.com/mercurysol based on 18 reviews.