Oracle Database 11g Data Warehousing Fundamentals Cources

Oracle Database 11g: Data Warehousing Training

This Database 11G Data Warehousing training teaches data warehousing concepts and technologies, while examining Oracle’s approach to data warehouse implementation. Review partitioning, parallel operations, materialized views and more.

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 Data Warehousing UpComing Batches

Nov-17 - Dec-29

Weekend
SOLD OUT

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

350.00     Enroll Now

Nov-10 - Dec-22

Weekday
SOLD OUT

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

350.00     Enroll Now

Nov-23 - Jan-04

Weekend
FILLING FAST

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

350.00     Enroll Now

Nov-30 - Jan-11

Weekday
FILLING FAST

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

350.00     Enroll Now

Dec-07 - Jan-18

Weekend

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

350.00     Enroll Now

Dec-14 - Jan-25

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: Data Warehousing

SELF PACED

This Database 11G Data Warehousing training teaches data warehousing concepts and technologies, while examining Oracle’s approach to data warehouse implementation. Review partitioning, parallel operations, materialized views and more.

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

Topics:
  • The sh and dm Sample Schemas and Appendices Used in the Course.
  • Class Account Information.
  • Course Schedule.
  • Course Objectives.
  • SQL Environments and Data Warehousing Tools Used in this Course.
  • Oracle 11g Data Warehousing and SQL Documentation and Oracle By Examples.
  • Course Pre-requisites and Suggested Pre-requisites.
  • Continuing Your Education: Recommended Follow-Up Classes.

Topics:
  • Data Warehouse Definition and Properties.
  • Extraction, Transformation and Loading (ETL).
  • Warehouse Development Approaches.
  • The Dimensional Model and Oracle OLAP.
  • Data Warehouses, Business Intelligence, Data Marts and OLTP.
  • Oracle Data Mining.
  • Typical Data Warehouse Components.

Topics:
  • Data Warehouse Definition and Properties.
  • Data Warehouses Versus Data Marts.
  • Strategy Phase Deliverables.
  • Typical Data Warehouse Components.
  • Warehouse Development Approaches.
  • Introducing the Case Study: Roy Independent School District (RISD).
  • Data Warehousing Process Components.
  • Data Warehouse Versus OLTP.

Topics:
  • Defining the Business Model.
  • Fact and Dimension Tables Characteristics.
  • Translating Business Dimensions into Dimension Tables.
  • Translating Dimensional Model to Physical Model.
  • Defining the Physical Model: Star, Snowflake and Third Normal Form.
  • Defining the Logical Model.
  • Defining the Dimensional Model.
  • Data Warehouse Modeling Issues.
Topics:
  • Indexing.
  • Oracle’s Strategy for Data Warehouse Security.
  • Security in Data Warehouses.
  • Optimizing Star Queries: Tuning Star Queries.
  • Database Sizing and Estimating and Validating the Database Size.
  • Oracle Database Architectural Advantages.
  • Parallelism.
  • Data Partitioning.

Topics:
  • Extraction Techniques and Maintaining Extraction Metadata.
  • Possible ETL Failures and Maintaining ETL Quality.
  • Extraction, Transformation and Loading (ETL) Process.
  • Extracting Data and Examining Data Sources.
  • Mapping Data.
  • Logical and Physical Extraction Methods.
  • Oracle’s ETL Tools: Oracle Warehouse Builder, SQL*Loader and Data Pump.
  • ETL: Tasks, Importance and Cost.

Topics:
  • Remote and Onsite Staging Models.
  • Transformation.
  • Maintaining Transformation Metadata.
  • Quality Data: Importance and Benefits.
  • Data Anomalies.
  • Transformation Routines.
  • Transformation Techniques and Tools.
  • Transforming Data: Problems and Solutions.

Topics:
  • Data Granularity.
  • Loading Data into the Warehouse.
  • Transportation Using Flat Files, Distributed Systems and Transportable Tablespaces.
  • Loading Techniques Provided by Oracle.
  • Indexing and Sorting Data and Verifying Data Integrity.
  • Data Refresh Models: Extract Processing Environment.
  • Building the Loading Process.
  • Post Processing of Loaded Data.

Topics:
  • Time- and Date-Stamping, Database Triggers and Database Logs.
  • Developing a Refresh Strategy for Capturing Changed Data.
  • Planning and Scheduling the Load Window.
  • Final Tasks.
  • Capturing Changed Data for Refresh.
  • User Requirements and Assistance.
  • Load Window Requirements
  • Applying the Changes to Data.

Topics:
  • Using Summaries to Improve Performance.
  • Working With Dimensions and Hierarchies.
  • Types of Materialized Views.
  • Build Modes and Refresh Modes.
  • Using Materialized Views for Summary Management.
  • Query Rewrite: Overview.
  • Cost-Based Query Rewrite Process.

Topics:
  • Integrating Multiple Sets of Metadata.
  • Managing Changes to Metadata.
  • Defining Warehouse Metadata.
  • Defining Warehouse Metadata.
  • Identifying Target Metadata Users and Choosing Metadata Tools and Techniques.
  • Metadata Users and Types.
  • Extraction, Transformation and Loading Metadata.
  • Examining Metadata: ETL Metadata.
  • Defining Metadata Goals and Intended Usage.

Topics:
  • Project Management.
  • Data Warehouse Architecture.
  • Some Useful Resources and White Papers.
  • ETL, Reporting and Security Considerations.
  • Logical, Dimensional and Physical Data Models.
  • Testing the Implementation and Post Implementation Change Management.
  • Metadata Management.
  • Requirements Specification or Definition.

Program Syllabus

Curriculum

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

Curriculum

Course Description

About The Course
What is 11g: Data Warehousing Fundamentals Certification Training about? This Oracle Database 11g: Data Warehousing Fundamentals training will teach you about the basic concepts of a data warehouse. Explore the issues involved in planning, designing, building, populating and maintaining a successful data warehouse. You'll also explore the basics of Oracle’s Database partitioning architecture, identifying the benefits of partitioning. Review the benefits of parallel operations to reduce response time for data-intensive operations. Learn how to extract, transform and load data (ETL) into an Oracle database warehouse. Learn the benefits of using Oracle’s materialized views to improve the data warehouse performance.

Instructors will give a high-level overview of how query rewrites can improve a query’s performance. Explore OLAP and Data Mining and identify some data warehouse implementations considerations. During this training, you'll briefly use some of the available data warehousing tools. These tools include Oracle Warehouse Builder, Analytic Workspace Manager and Oracle Application Express.
Objectives Of Our Online PySpark Training Course
What are the objectives of 11g: Data Warehousing Fundamentals Certification Training ?
  • Describe methods and tools for extracting, transforming and loading data
  • Identify some of the tools for accessing and analyzing warehouse data.
  • Identify the technology and some of the tools from Oracle to implement a successful data warehouse.
  • Define the decision support purpose and end goal of a data warehouse.
  • Describe the benefits of partitioning, parallel operations, materialized views, and query rewrite in a data warehouse.
  • Explain the implementation and organizational issues surrounding a data warehouse project.
  • Use materialized views and query rewrite to improve the data warehouse performance.
  • Define the terminology and explain the basic concepts of data warehousing.
  • Develop familiarity with some of the technologies required to implement a data warehouse.
  • This Red Hat OpenShift Certification Training is specifically designed to help trainees prepare for the Red Hat Certified Specialist in OpenShift Administration (EX280) exam.
Go For Online Spark Training
Who is 11g: Data Warehousing Fundamentals Certification Training for?
  • Application Developers.
  • Project Manager.
  • Developer.
  • Support Engineer.
  • Data Warehouse Analyst.
  • Functional Implementer.
  • Data Warehouse Developer.
Learning With Our PySpark Certification Training
What are the prerequisites for 11g: Data Warehousing Fundamentals Certification Training? Suggested Prerequisite:
  • Knowledge of client-server technology.
  • Knowledge of relational server technology.
  • Knowledge of general data warehousing concepts.

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