Data Modeling

The course covers topics such as normalization, denormalization, and advanced techniques for modeling complex relationships, temporal data, and schema evolution.




Hours per week


Live Sessions

Oct 23, 2023

Next Date


The objetive is to provide participants with a comprehensive understanding of data modeling principles and techniques in the context of data engineering. The course aims to equip participants with the knowledge and skills to design efficient, scalable, and optimized database schemas for data storage and retrieval. By the end of the course, participants should be able to create well-designed data models that meet business requirements and support data engineering workflows effectively.


  • Basic understanding of databases and SQL.
  • Familiarity with data concepts and data management principles.
  • Access to a computer with a database management system (DBMS) installed (e.g., MySQL, PostgreSQL, Oracle).


Introduction to Data Modeling

Delve into data modeling in data engineering, covering relational, dimensional, and NoSQL types. Understand key concepts like ER modeling, entities, attributes, relationships, and constraints. Explore data modeling tools and notations like Lucidchart, ERDs, Crow’s Foot Notation, and ETV.

Relational Data Modeling

Master Entity-Relationship (ER) modeling fundamentals, create entity types, attributes, and relationships. Explore different types of Relational Database Management Systems (RDBMS) with a focus on PostgreSQL.

Dimensional Data Modeling

Learn dimensional modeling for data warehousing using Databricks. Study star and snowflake schema design principles, fact and dimension tables, hierarchies, and attributes.

NoSQL Data Modeling

Explore NoSQL databases and their data modeling approaches. Understand NoSQL principles such as document-based, key-value, columnar, and graph data models. Work with unstructured and semi-structured data.

Normalization and Denormalization

Comprehend normalization principles (1NF to 3NF) for data structuring. Explore denormalization techniques for performance optimization and learn about trade-offs between normalization and denormalization.

Advanced Data Modeling Techniques

Handle complex relationships like one-to-one, one-to-many, and many-to-many. Study subtyping and inheritance in data models and understand modeling temporal data and effective dating.

Data Modeling Considerations for Data Engineering Workflows

Integrate data models into data engineering pipelines. Employ data modeling in ETL (Extract, Transform, Load) processes and understand schema evolution and versioning.

Data Modeling Best Practices and Case Studies

Implement best practices for designing efficient and maintainable data models. Analyze real-world case studies showcasing data modeling in data engineering. Stay updated on emerging trends and advancements in data modeling and tools.


Mentor to be defined.
Our alumni works in:

Learn all you can. No extra fees, no commissions, no surprises.

— We’re an hybrid learning platform with live-cohorts. Learn everything you want by acquiring a membership.