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