Learn Data Warehousing Complete Guide (OFFLINE)

A data warehouse is constructed by integrating data from multiple heterogeneous sources. It supports analytical reporting, structured and/or ad hoc queries and decision making. This tutorial adopts a step-by-step approach to explain all the necessary concepts of data warehousing.

Audience

This tutorial will help computer science graduates to understand the basic-to-advanced concepts related to data warehousing.

Prerequisites

Before proceeding with this tutorial, you should have an understanding of basic database concepts such as schema, ER model, structured query language, etc.

Chapters

Overview

Concepts

Terminologies

Delivery Process

System Processes

Architecture

OLAP

Relational OLAP

Multidimensional OLAP

Schemas

Partitioning Strategy

Metadata Concepts

Data Marting

System Managers

Process Managers

Security

Backup

Tuning

Testing

Future Aspects

Interview Questions