Fundamentals of Data Engineering – Data Lakes and Data Warehouses Training

This course provides a thorough introduction to data warehousing concepts, design, implementation, and management. It is designed to equip participants with the skills needed to create and manage data warehouses effectively, enabling them to support business intelligence and decision-making processes.

Key Learnings:

The components that define a data warehouse platform
What trends impact the modern data warehouse
To position the data warehouse platform in the big data era
Architectural options and considerations
Development options and approaches
The requirements gathering process
Necessary design activities
How operations and service processes enable business capabilities

Course Content:

Module 1: Introduction to Data Warehouse

What is Data Warehousing?
Features of Data Warehouse
Types of Data Warehouse
Components of Data Warehouse
Use of Data Warehouse
Advantages of Data Warehouse
Disadvantages of Data Warehouse
Data Warehouse Tools
Data Warehouse Applications
Integrating Heterogeneous Databases

Module 2: Terminologies
Metadata
Metadata Repository
Data Cube
Data Mart
Virtual Warehouse

Module 3: Dimensions and Facts
Facts
Dimensions

Module 4: Modelling
Data Warehouse Modelling Overview
ER Diagram

Module 5: Delivery Process
Delivery Method
IT Strategy
Education and Prototyping
Technical Blueprint

Module 6: System Processes
Process Flow in Data Warehouse
Extract and Load Process
Clean and Transform Process
Backup and Archive the Data

Module 7: Data Warehouse Architecture
Three-Tier Data Warehouse Architecture
Data Warehouse Models
Load, Warehouse, and Query Manager

Module 8: Data Warehouse OLAP
Types of OLAP Servers
OLAP Operations
OLAP Vs OLTP

Module 9: Relational and Multidimensional OLAP
Relational OLAP
Multidimensional OLAP
Three-Tier Data Warehouse Architecture

Module 10: Data Warehouse Schemas
Star Schema
Snowflake Schema
Fact Constellation Schema
Schema Definition

Module 11: Horizontal and Vertical Partitioning
Introduction to Partitioning
Horizontal Partitioning
Vertical Partitioning

Module 12: Metadata Concepts
Metadata Categories
Role of Metadata

Module 13: System and Process Managers
System Managers
Process Managers

Who’s this course for?
Data Professionals
Business Analysts
IT Managers
Software Developers
Business Intelligence Professionals
Project Managers
Database Professionals

Career Path
Data Warehouse Developer
Business Intelligence (BI) Analyst
Data Engineer
Data Architect
Senior Data Warehouse Engineer

International Student Fees: USD950$

Job Interview Preparation (Soft Skills Questions & Answers)
Tough Open-Ended Job Interview Questions
What to Wear for Best Job Interview Attire
Job Interview Question- What are You Passionate About?
How to Prepare for a Job Promotion Interview

Stay connected even when you’re apart

Join our WhatsApp Channel – Get discount offers

500+ Free Certification Exam Practice Question and Answers

Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

Join Internships and Referral Program (click for details)

Work as Freelancer or Full-Time Employee (click for details)

Hire an Intern

Flexible Class Options