Oracle Database 11g Administer A Data Warehouse Cources

Oracle Database 11g:Administer a Data Warehouse Training

This course will help you understand the basic concepts of administering a data warehouse. You'll learn to use various Oracle Database features to improve performance and manageability in a data warehouse.

80% of Global Fortune 500 organizations are expected to adopt DevOps by 2021 – CA.

ADP, BBC News, ebay, GE, ING, Intuit, PayPal, Splunk, Uber & other MNCs worldwide use DevOps.

Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Oracle Database11g UpComing Batches

Nov-29 - Jan-10

Weekend
SOLD OUT

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Nov-22 - Jan-03

Weekday
SOLD OUT

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-11 - Jan-22

Weekend
FILLING FAST

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Dec-18 - Jan-29

Weekday
FILLING FAST

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now

Dec-25 - Feb-05

Weekend

Timings: 07:00 AM To 10:00 AM (IST)

350.00     Enroll Now

Jan-01 - Feb-12

Weekday

Timings: 20:30 PM To 23:30 PM (IST)

350.00     Enroll Now
Be future ready. Start learning
Structure your learning and get a certificate to prove it.
Start Learning

Course Curriculum

Oracle Database 11g: Training

SELF PACED

This course will help you understand the basic concepts of administering a data warehouse. You'll learn to use various Oracle Database features to improve performance and manageability in a data warehouse.

  • WEEK 5-6
  • 10 Modules
  • 6 Hours
Course Content


Topics:
  • Development Tools.
  • Enterprise Manager.
  • Oracle SQL Developer.
  • Sample Schemas Used.


Topics:
  • Data Warehouse Architectures.
  • Data Warehouse Objects.
  • Characteristics of a Data Warehouse.
  • Data Warehouse Schemas.
  • Data Warehouse Design.
  • Comparing OLTP and Data Warehouses.


Topics:
  • Introducing Bitmap Join Indexes.
  • Understanding Star Query Optimization and Bitmap Joined Index Optimization.
  • Optimizing Star Queries.


Topics:
  • Partitioning Methods.
  • Partition Pruning and Star Queries.
  • Partitioned Tables and Indexes.
  • Partitioning Types.


Topics:
  • Degree of Parallelism.
  • Parallel Execution Plan.
  • Operations That Can Be Parallelized.
  • Automatice Parallelism.
  • How Parallel Execution Works?


Topics:
  • Tuning Parameters for Parallel Execution.
  • Parallel DML.
  • Parallel DDL.
  • Parallel Query.
  • Balancing the Workload.


Topics:
  • Transportable Tablespaces.
  • Capturing Data With Change Data Capture.
  • Publish and Subscribe Model: The Publisher and the Subscriber.
  • Transportation in a Data Warehouse.
  • Extraction Methods.
  • Sources and Modes of Change Data Capture.
  • Synchronous and Asynchronous CDC.
  • Asynchronous AutoLog Mode and Asynchronous HotLog Mode.


Topics:
  • Loading Mechanisms.
  • Applications of External Tables.
  • Defining External Tables with SQL*Loader.
  • Populating External Tables with Data Pump.
  • Other Loading Methods.
  • Replicat.


Topics:
  • Transformation Using SQL.
  • Transformation Mechanisms.
  • DML Error Logging.
  • Data Transformation.
  • Table Functions.


Topics:
  • Using Materialized Views for Summary Management.
  • Materialized View Dictionary views.
  • Types of Materialized Views.
  • The Need for Summary Management.


Topics:
  • Partition Change Tracking (PCT) Refresh.
  • Refresh Performance Improvements.
  • Refresh Modes.
  • Refresh Options.
  • Conditions That Effect Possibility of Fast Refresh.
  • Materialized View Logs.


Topics:
  • Creating Dimensions and Hierarchies.
  • Verifying Relationships in a Dimension.
  • What Are Dimensions?
  • Dimension Invalidation.
  • Dimension Restrictions.
  • Dimensions and Privileges.


Topics:
  • Query Rewrite Methods.
  • Partition Change Tracking (PCT) and Query Rewrite.
  • Setting Initialization Parameters for Query Rewrite.
  • What Can be Rewritten?
  • Conditions Required for Oracle to Rewrite a Query.
  • Query Rewrite Guidelines.
  • Query Rewrite Enhancement to Support Queries Containing Inline Views.
  • Query Rewrite: Overview.


Topics:
  • Tuning Materialized Views for Fast Refresh and Query Rewrite.
  • Table Compression and Resumable Sessions.
  • SQL Access Advisor: Usage Model.
  • Schedule and Review.
  • Setting Initial Options.
  • Specifying the Workload Source.
  • Recommendation Options.
  • PL/SQL Procedure Flow.

Program Syllabus

Curriculum

You can also view the program syllabus by downloading this program Curriculum.

Course Description

Course Certification

OL Tech Edu’s Certificate Holders work at top 500s of companies like

certificate

Features

Explore step by step paths to get started on your journey to Jobs of Today and Tomorrow.

Instructor-led Sessions

30 Hours of Online Live Instructor-Led Classes.
Weekend Class : 10 sessions of 3 hours each.

Real Life Case Studies

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various real life solutions / services.

Assignments

Assignments

Each class will be followed by practical assignments.

24 x 7 Expert Support

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

Certification

Towards the end of the course, OL Tech Edu certifies you for the course you had enrolled for based on the project you submit.

Course FAQ's

Enroll, Learn, Grow, Repeat! Get ready to achieve your learning goals with OL Tech Edu View All Courses

© 2015 - 2021 OL Tech Edu. All Rights Reserved.
Designed, Developed & Powered by MNJ SOFTWARE

The website is best experienced on the following version (or higher) of Chrome 31, Firefox 26, Safari 6 and Internet Explorer 9 browsers