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)
Flexible Class Options
- Week End Classes For Professionals SAT | SUN
- Corporate Group Training Available
- Online Classes – Live Virtual Class (L.V.C), Online Training
Related Courses
Fundamentals of Data Engineering – Data Lakes and Data Warehouses Training
Fundamentals of Data Engineering – Data Lakes Foundation
Data Sciences Specialization
Diploma in Big Data Analytics
Data Sciences with Python (2-in-1 Course
PostgreSQL For Data Science And Data Analyst
Big Data + Data Sciences Training with Machine Learning
