• Home
  • Testing
  • SAP
  • Web
  • Must Learn!
  • Big Data
  • Live Projects
  • AI
  • Blog

Training Summary

Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. The goal is to derive profitable insights from the data. This course covers advance topics like Data Marts, Data Lakes, Schemas amongst others.

What should I know?


The tutorials are designed for beginners with little or no Data Warehouse Experience. Though basic understanding of Database and SQL is a plus.

Course Syllabus

Tutorial What Is Data Warehousing? Types, Definition & Example
Tutorial Data Warehouse Concepts, Architecture and Components
Tutorial ETL (Extract, Transform, and Load) Process
Tutorial ETL vs ELT: Must Know Differences
Tutorial What is Data Modelling? Conceptual, Logical, & Physical Data Models
Tutorial What is OLAP (Online Analytical Processing): Cube, Operations & Types
Tutorial MOLAP (Multidimensional Online Analytical Processing)
Tutorial OLTP vs OLAP: What's the Difference?
Tutorial What is Dimensional Model in Data Warehouse?
Tutorial Star and SnowFlake Schema in Data Warehousing
Tutorial Data Mart Tutorial: What is Data Mart, Types & Example
Tutorial Data Warehouse vs Data Mart: Know the Difference
Tutorial What is Data Lake & It's Architecture
Tutorial Data Lake vs Data Warehouse: Know the Difference 
Tutorial What is Business Intelligence? Definition & Example
Tutorial Data Mining Tutorial: Process, Techniques, Tools & Examples
Tutorial DataStage Tutorial: Beginner's Training
Tutorial Difference between Data Mining and Data Warehouse
Tutorial Difference Between Fact Table and Dimension Table
Tutorial 20 Best ETL / Data Warehousing Tools in 2018
Tutorial 15 Best Data Integration Tools in 2018
Tutorial 20 Best Continuous Integration(CI) Tools in 2018
Tutorial 5 Best ETL Automation Testing Tools in 2018
Tutorial 24 Best Business Intelligence(BI) Tools List in 2018
Tutorial Top 25 ETL Testing Interview Questions & Answers