Database Theory
Understand the theoretical foundations of databases: data models, entity-relationship diagrams, and relational algebra.

Join the AI Workshop to learn more about AI and how it can be applied to web development. Next cohort February 1st, 2026

The AI-first Web Development BOOTCAMP cohort starts February 24th, 2026. 10 weeks of intensive training and hands-on projects.


Before diving into the specifics of SQL and databases, it’s important to understand the theoretical foundations that underpin all database systems.

In this section you’ll learn about data models, entity-relationship diagrams, relational algebra, and the concepts that make relational databases work.

Lessons in this unit:

0: ▶︎ Introduction
1: Information systems, data and information
2: Data models
3: What is a Database? And a DBMS?
4: Introduction to the ER Data Model
5: The Relational Model
6: Relational Databases
7: Relational Algebra
8: Introduction to SQL
9: Do you always need a database for your app?