Database Excel

Excel as a Database (DBMS) – Relationships, Joins, and Data Modeling

Excel as a DBMS: table relationships, Inner/Left/Right Join with Power Query, and many-to-many data modeling.

Course description

Excel as a Database: relationships, joins and relational data modeling

Did you know you can use Excel as a true relational database? With Power Query and Power Pivot, Excel can handle table relationships, SQL-style joins and complex data models — without writing a single line of code. This course teaches you to think relationally and structure your data like a database.

What You'll Learn

  • The concept of foreign keys and table relationships in Excel
  • Creating a coherent data model with Power Pivot
  • Inner Join between tables with Power Query
  • Left Join, Right Join and Full Join: when to use them and how to read results
  • Data projections: selecting only the columns you need
  • One-to-Many relationship on a real use case (employee management)
  • Many-to-Many relationship with a junction table and join across three tables

Why This Is Useful Even If You're Not a DBA

You don't need to know SQL to follow this course — but by the end you'll understand joins like a database administrator. This fundamentally changes the way you think about data everywhere, not just in Excel.

Who This Course Is For

Analysts, controllers and anyone who works with structured data who wants to understand database concepts without switching to SQL or installing a DBMS.

Lessons list

I'll introduce you to the core concepts of relational databases applied to Excel: let's see what table relationships are, how foreign keys work, and why these database pillars radically change the way you manage data.

Guarda lezione

Let's see together how to create table relationships in Excel and build a coherent data model with Power Pivot: I'll walk you from raw data all the way to a relational structure ready for analysis.

Guarda lezione

I'll show you how to perform an Inner Join between two tables directly with Power Query in Excel: one of the most powerful relational database concepts, applied without writing a single line of SQL.

Guarda lezione

Let's explore Left Join and Right Join in Power Query together: I'll explain when to use each one, why the join type changes the results, and how to retain data even when there's no match between tables.

Guarda lezione

Let's tackle a real-world one-to-many relationship in Excel: I'll show you how to correctly model employee management for an office using Power Query, from table design all the way to the final result.

Guarda lezione

Let's continue with the one-to-many relationship, building joins with Power Query: I'll show you how to apply both Inner Join and Left Join and how the returned records differ depending on the join type chosen.

Guarda lezione

Let's complete the Power Query join picture with Right Join and Full Join, and introduce the concept of projection: I'll explain how to select only the columns you need to keep your queries clean and efficient.

Guarda lezione

I'll explain what a many-to-many relationship is in Excel and why you can't handle it without a junction table: let's see how to structure it correctly in Power Query to connect related data without errors.

Guarda lezione

Let's see how to handle a many-to-many relationship with an Inner Join across three tables in Power Query: I'll show you the key role of the junction table and how to correctly link data distributed across multiple tables.

Guarda lezione

Let's wrap up the many-to-many model by completing the dataset and analyzing the final join result: I'll show you how to read and validate the relational structure obtained to make sure everything works correctly.

Guarda lezione
Giovanni Pace

Giovanni Pace

Ingegnere Informatico · Pratola Peligna

  • 107 Courses
About the teacher

Sono un ingegnere informatico con oltre 15 anni di esperienza nel settore ICT. Mi occupo di sviluppo software, cybersecurity, data science e intelligenza artificiale, con particolare attenzione all’innovazione e all’automazione dei processi aziendali. Da anni svolgo anche attività di docenza e formazione, creando percorsi pratici e coinvolgenti su programmazione, DevOps, AI e sicurezza informatica.

This course includes

  • Lessons 10
  • Duration 1h 41m
  • Difficulty intermedio
  • Language it
  • Certificate No

Recently viewed