• Home
  • Testing
  • SAP
  • Web
  • Must Learn!
  • Big Data
  • Live Projects
  • 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 Difference between Data Mining and Data Warehouse
Tutorial Difference Between Fact Table and Dimension Table