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

Apr-12 - May-24

Weekend
SOLD OUT

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

350.00     Enroll Now

Apr-05 - May-17

Weekday
SOLD OUT

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

350.00     Enroll Now

Apr-20 - Jun-01

Weekend
FILLING FAST

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

350.00     Enroll Now

Apr-27 - Jun-08

Weekday
FILLING FAST

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

350.00     Enroll Now

May-04 - Jun-15

Weekend

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

350.00     Enroll Now

May-11 - Jun-22

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

DOWNLOAD BROCHURE

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.

Curriculum

Course Description

About The Course
What is 11g: Administer a Data Warehouse Certification Training about? 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. Expert instructors will also teach you how to extract, transform and load data into an Oracle database warehouse. Discover how to use SQL Access Advisor to optimize the entire workload. Use materialized views to improve data warehouse performance and learn how query rewrites can improve performance.
Objectives Of Our Online PySpark Training Course
What are the objectives of 11g: Administer a Data Warehouse Certification Training ?
  • Use parallel operations to reduce response time for data-intensive operations,Extract, Transform, and Load data in the data warehouse,Create, use, and refresh materialized views to improve the data warehouse performance.
  • Use Query rewrite to quickly answer business queries using materialized views.
  • Use SQL Access Advisor and PL/SQL procedures to tune materialized views for fast refresh and query rewrite.
  • Use the features of compression and resumable sessions.
  • Review the basic Oracle data warehousing concepts.
Go For Online Spark Training
Who is 11g: Administer a Data Warehouse Certification Training for?
  • Data Warehouse Developer.
  • Data Warehouse Administrator.
  • Application Developers.
  • Database Administrators.
  • Support Engineer.
  • Technical Consultant.
Learning With Our PySpark Certification Training
What are the prerequisites for 11g: Administer a Data Warehouse Certification Training? Suggested Prerequisite:
  • 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.

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
Top Courses
Stands by you all the way to ensure that you achieve your learning goals.

Top Courses

Partner Courses

Certifications

HELP & SUPPORT

Connect With Us

Get In Touch     Address: 5th Floor(Tower B), A-40, Ithum Tower Sector - 62, Noida Uttar Pradesh   Phone: +91-9654136060   Email: info@oltechedu.com  

© 2015 - 2024 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