عربى

UAE, Abu Dhabi

info@boostorg.com

+971 50 412 3294

Our blogs

Request in house Course

course | Data Architecture & Data Modeling Fundamentals

Join the Data Architectu... course taught in English – This 5-day program provides a comprehensive foundation in Data Architecture and Data Modeling, covering data…

IT-3744 | Data Architecture & Data Modeling Fundamentals

Course Sector : Information Technology

Course dates

Download brochure Icon

Duration	Date from	Date to	Course Venue	Course fees	Book a course
5 Days	19/10/2026	23/10/2026	Dubai	$4,250	Book now

Course Introduction

This 5-day program provides a comprehensive foundation in Data Architecture and Data Modeling, covering data architecture principles, data requirements, conceptual/logical/physical modeling, relational and dimensional modeling, data integration, governance, and modern data architecture concepts.

Course objective

Understand key Data Architecture concepts and principles.
Understand the role of data architecture within an organization.
Identify data requirements and business data domains.
Develop conceptual, logical, and physical data models.
Apply relationships, keys, normalization, and data integrity principles.
Design dimensional models using Star and Snowflake schemas.
Understand data integration and data flow concepts.
Apply basic data governance and data quality principles.
Evaluate data architecture and modeling decisions for business needs.

Course audience

Data Architects
Data Analysts
Data Engineers
Business Analysts
Database Developers
BI Developers
Database Administrators
IT Professionals
Data & Analytics Managers

Course Outline | DAY 1

Data Architecture Fundamentals

Introduction to Data Architecture
Data Architecture Principles & Components
Data Domains and Data Assets
Business, Application and Data Layers
Data Architecture Frameworks
Data Flows and Data Lifecycle
Operational vs. Analytical Data
Practical Exercise: Developing a basic data architecture

Course Outline | DAY 2

Data Modeling Fundamentals

Introduction to Data Modeling
Business & Data Requirements
Entities, Attributes and Relationships
Business Rules and Cardinality
Conceptual Data Modeling
Logical Data Modeling
Entity Relationship Diagrams (ERDs)
Practical Exercise: Creating a conceptual and logical data model

Course Outline | DAY 3

Relational & Physical Data Modeling

Relational Data Model Concepts
Tables, Columns and Data Types
Primary, Foreign and Composite Keys
Referential Integrity
Data Normalization – 1NF, 2NF, 3NF
Physical Data Modeling
Constraints and Indexing
Practical Exercise: Developing a physical database model

Course Outline | DAY 4

Dimensional Modeling & Data Integration

OLTP vs. OLAP
Dimensional Data Modeling
Fact and Dimension Tables
Star and Snowflake Schemas
Measures and Data Grain
Slowly Changing Dimensions – Introduction
Data Integration Concepts
ETL/ELT and Data Pipelines
Practical Exercise: Designing a dimensional model and basic data flow

Course Outline | DAY 5

Modern Data Architecture, Governance & Case Study

Data Warehouse Architecture
Data Lake and Lakehouse Concepts
Modern Data Architecture Patterns
Data Governance Fundamentals
Data Quality and Metadata
Data Security and Access Considerations
Data Architecture Best Practices
Final Case Study: Designing an end-to-end Data Architecture and Data Model
Review, Discussion and Assessment

Course Certificates

BOOST’s Professional Attendance Certificate “BPAC”

BPAC is always given to the delegates after completing the training course,and depends on their attendance of the program at a rate of no less than 80%,besides their active participation and engagement during the program sessions.

Request a Quote

The fundamentals include identifying entities, defining attributes, establishing relationships, selecting primary and foreign keys, setting data types, and applying rules that maintain data integrity.

A practical framework includes:Data strategy and governanceData modeling and designData storage and infrastructureData integration and processingData security and access

Data modeling in ETL involves designing the structure of data as it is extracted, transformed, and loaded so that information is organized consistently and can be efficiently stored, queried, and analyzed.

Start with database and SQL fundamentals, then study ER diagrams, relational databases, normalization, keys and relationships, and dimensional modeling. Practice by designing databases and data warehouses for realistic business scenarios.

Open Training Calendar

Since 2001, we’ve been at the forefront of professional training in the Middle East — shaping the future of learning and development one success story at a time. With a vision rooted in innovation and excellence, we help individuals, teams, and organizations reach their highest potential through integrated, future-ready training solutions. Our comprehensive programs combine global best practices with local insights, empowering people to grow, lead, and make a lasting impact in their industries.

Our whats app