Data Warehousing Certification Training

Live Online & Classroom Certification Training

Participants of data warehousing certification courses get to know how data warehouse is constructed by integrating data from multiple heterogeneous sources. It supports analytical reporting, structured and/or ad hoc queries and decision making.

Instructed by SPRINGPEOPLE

No Public/Open-house class on the topic scheduled at the moment!

Course Description


Data warehouse training courses adopts a step-by-step approach to explain all the necessary concepts of data warehousing. This enables participants with concepts of Data warehousing like Facts, Schema, Metadata, Normalization, Data transformation, Dimensional Modeling and ETL Concepts.


After the completion of data warehousing certification courses, you will be able to: 

  • Understand the concept and need of Data warehouse 
  • Implement concepts of dimension and fact table 
  • Implement data modelling, normalization and schema concepts
  • Model a Data warehouse 
  • Implement ETL jobs



The pre-requisites for data warehouse course includes basic understanding of Databases.

Course Curriculum

Expand All
  • Understanding a Data Warehouse
  • Why a Data Warehouse is Separated from Operational Databases
  • Data Warehouse Features
  • Data Warehouse Applications
  • Types of Data Warehouse
  • Metadata
  • Metadata Repository
  • Data Cube
  • Data Mart
  • Virtual Warehouse
  • Delivery Method
  • IT Strategy
  • Business Requirements
  • Technical Blueprint
  • Building the version
  • History Load
  • Ad hoc Query
  • Automatio
  • Process Flow in Data Warehouse
  • Extract and Load Process
  • Business Analysis Framework
  • Three-Tier Data Warehouse Architecture
  • Data Warehouse Models
  • Load Manager
  • Warehouse Manager
  • Query Manage
  • Relational OLAP (ROLAP)
  • Multidimensional OLAP (MOLAP)
  • Hybrid OLAP (HOLAP)
  • Specialized SQL Servers
  • Star Schema
  • Snowflake Schema
  • Fact Constellation Schema
  • Horizontal Partitioning
  • Vertical Partitio
  • What is Metadata?
  • Categories of Metadata
  • Role of Metadata
  • Metadata Repository
  • Challenges for Metadata Management
  • Dimensions and facts - What are dimensions and facts?
  • Types of dimensions - emphasis on SCD 1,2,3 implementations
  • Types of facts
  • What are hierarchies - Types of Hierarchies
  • Normalizatio
  • Requirement gathering
  • Principles of dimensional modelling
  • Modeling - ER diagrams
  • ETL Concept - Architectural components - like Source, Staging, Atomic, Dimension
  • Transformation - Data Validation, Data Accuracy, Data Type Conversion, Business Rule Application
  • Data Loading techniques.
  • Why Do We Need a Data Mart?
  • Cost-effective Data Marting
  • Designing Data Marts
  • System Managers and Process Managers
  • Security Requirements
  • Documentation
  • Impact of Security on Design
  • Backup Terminologies
  • Hardware Backup
  • Software Backups
  • Unit testing
  • Integration testing
  • System testing


SpringPeople works with top industry experts to identify the leading certification bodies on different technologies - which are well respected in the industry and globally accepted as clear evidence of a professional’s “proven” expertise in the technology. As such, these certification are a high value-add to the CVs and can give a massive boost to professionals in their career/professional growth.

Our certification courses are fully aligned to these high-profile certification exams; at the end of the course, participants will have detailed knowledge, be eligible and be fully ready take up these certification exams and pass with flying colours.


Oracle Database 11g Data Warehousing Essentials 1Z0-515


The Oracle Database 11g Data Warehousing Implementation Specialist Certification identifies professionals that are skilled in implementing solutions based using the Oracle Database as a data warehouse. The certification covers skills such as: data warehouse fundamentals, parallelism, partitioning, the Result Set Cache, Advanced Compression, using Oracle Data Mining, data integration with ODI and OWB, the Exadata Storage Server and the Oracle Exadata Database Machine and best practices for implementing data warehouses. The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.

This certification is available to all candidates but is geared toward members of the Oracle Partner Network who are focused on selling and implementing Oracle Database 11g technology to implement data warehouses. OPN Members earning this certification will be recognized as OPN Certified Specialists, which helps their companies qualify for the Oracle Data Warehouse Specialization.


Exam Number:1Z0-515
Associated Certifications:Oracle Data Warehousing 11g Certified Implementation Specialist
Exam Product Version: Oracle Database 11g
Exam Price: US$ 245 More on exam pricing
Duration: 120 minutes
Number of Questions:61
Passing Score: 78% View passing score policy
Validated Against: This exam has been validated against 11g
Exam Format:Multiple Choice


Exam Registration



About the Instructor

Founded in 2009, SpringPeople is a global premier eLearning marketplace for Online Live, Instructor-led classes in the region. It is a certified training delivery partner of leading technology creators, namely Pivotal, Elastic, Lightbend, EMC, VMware, MuleSoft, RSA, and... Read More

Course Rating and Reviews


Average Rating
5 Stars
4 Stars
3 Stars
2 Stars
1 Star

SPRINGPEOPLE SpringPeople Trainer

Nishit Sinha

Senior Applications Developer
ServiceNow Inc.
Course Material:
Class Experience:
Nothing as such

SPRINGPEOPLE SpringPeople Trainer


Course Material:
Class Experience:
session like reading the slides

SPRINGPEOPLE SpringPeople Trainer


Course Material:
Class Experience:
The trainer was pretty new to the training and the class was not helpful. Not at all recommended. Failed to satisfy my requirements

This class is intended for participants with some prior exposure to the technology and are now looking to build up their expertise on the topic.

On successful completion of the course, participants will be eligible to sit of the related certification exam (see course overview). All participants receive a course completion certificate, demonstrating their expertise on the subject.

Total duration of the online, live instructor led sessions. Sessions are typically delivered as short lectures (2-hrs weekdays/3-hrs weekends) and detailed hands-on guidance.

Expected offline lab work hours that participants will need to complete and submit to the trainer, during and after the instructor-led online sessions.

  1. We are happy to refund full fee paid - no questions asked - should you feel that the training is not up to your expectations.
  2. Our dedicated team of expert training enablement advisors are available on email, phone and chat to assist you with your queries.
  3. All courseware, including session recordings, will always be available to access to you for future reference and rework.

Contact Us

+91-80-6567-9700 (BLR)

Schedule a Call

Related Courses

Recently Viewed