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 Database vs Data Warehouse: Key Differences
Tutorial Data Warehouse Concepts, Architecture and Components
Tutorial ETL (Extract, Transform, and Load) Process
Tutorial ETL vs ELT: Must Know Differences
Advanced Stuff
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 What is OLTP? Definition, Architecture, Example
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 What is Data Reconciliation? Definition, Process, Tools
Must Know!
Tutorial Difference between Data Mining and Data Warehouse
Tutorial Difference Between Fact Table and Dimension Table
Tutorial Difference between Information and Data
Tutorial Information vs Knowledge: Key Differences
Tutorial 20 Best ETL / Data Warehousing Tools
Tutorial 22+ BEST ETL Tools
Tutorial 15 Best Data Integration Tools
Tutorial 20 Best Continuous Integration(CI) Tools
Tutorial 5 Best ETL Automation Testing Tools
Tutorial 24 Best Business Intelligence(BI) Tools
Tutorial 25 BEST Data Mining Tools
Tutorial 20 BEST Data Modeling Tools: Design your Database for FREE
Tutorial 22 BEST Data Visualization Tools
Tutorial 18 BEST Reporting Tools
Tutorial 20 BEST Flowchart Creator | Maker | Software
Tutorial 30+ BEST Log Management Tools
Tutorial 15+ BEST Syslog Servers for Windows & Linux (Free/Paid)
Tutorial 20+ BEST SIEM Tools & Software Solutions
Tutorial Top 25 ETL Testing Interview Questions & Answers
Tutorial Teradata Tutorial: Learn Basics for Beginners
Tutorial Top 50 Teradata Interview Questions & Answers
Tutorial Top 88 Data Modeling Interview Questions and Answers
Tutorial Data Warehouse PDF