# desertdba/learn-sql-in-a-month-of-lunches architecture

> Architecture diagram of the GitHub repository desertdba/learn-sql-in-a-month-of-lunches, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-28). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/desertdba/learn-sql-in-a-month-of-lunches
- Repository: https://github.com/desertdba/learn-sql-in-a-month-of-lunches

## Overview

This repository provides chapter-by-chapter SQL learning resources for *Learn SQL in a Month of Lunches*. The documented workflow is to set up the SQLNovel database, then use the chapter SQL scripts as learning exercises; the README specifically warns that later scripts may depend on an updated database. Source excerpts were unavailable, so script contents and most individual database interactions cannot be confirmed.

Main entry points: [`Chapter_01/Create_SQLNovel_database.sql`](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_01/Create_SQLNovel_database.sql) (Create SQLNovel), [`Chapter_07/SQL_MOL_Ch07.sql`](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_07/SQL_MOL_Ch07.sql) (Chapter 07 SQL), [`Chapter_08/SQL_MOL_Ch08.sql`](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_08/SQL_MOL_Ch08.sql) (Chapter 08 SQL), [`Chapter_09/SQL_MOL_Ch09.sql`](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_09/SQL_MOL_Ch09.sql) (Chapter 09 SQL)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_setup["Database setup"]
  node_setup_script["Create SQLNovel"]
  node_sqlnovel[("SQLNovel database")]
end

subgraph group_lessons["Chapter lessons"]
  node_ch02["Chapter 02 SQL"]
  node_ch03["Chapter 03 SQL"]
  node_ch04["Chapter 04 SQL"]
  node_ch05["Chapter 05 SQL<br/>[SQL_MOL_Ch05.sql]"]
  node_ch06["Chapter 06 SQL<br/>[SQL_MOL_Ch06.sql]"]
  node_ch07["Chapter 07 SQL<br/>[SQL_MOL_Ch07.sql]"]
  node_ch08["Chapter 08 SQL<br/>[SQL_MOL_Ch08.sql]"]
  node_ch09["Chapter 09 SQL<br/>[SQL_MOL_Ch09.sql]"]
  node_ch10["Chapter 10 SQL<br/>[SQL_MOL_Ch10.sql]"]
  node_ch11["Chapter 11 SQL<br/>[SQL_MOL_Ch11.sql]"]
  node_ch12["Chapter 12 SQL<br/>[SQL_MOL_Ch12.sql]"]
  node_ch13["Chapter 13 SQL<br/>[SQL_MOL_Ch13.sql]"]
  node_ch14["Chapter 14 SQL<br/>[SQL_MOL_Ch14.sql]"]
  node_ch15["Chapter 15 SQL<br/>[SQL_MOL_Ch15.sql]"]
  node_ch16["Chapter 16 SQL<br/>[SQL_MOL_Ch16.sql]"]
  node_ch17["Chapter 17 SQL<br/>[SQL_MOL_Ch17.sql]"]
  node_ch18["Chapter 18 SQL<br/>[SQL_MOL_Ch18.sql]"]
  node_ch19["Chapter 19 SQL<br/>[SQL_MOL_Ch19.sql]"]
  node_ch20["Chapter 20 SQL<br/>[SQL_MOL_Ch20.sql]"]
  node_ch21["Chapter 21 SQL<br/>[SQL_MOL_Ch21.sql]"]
  node_ch22["Chapter 22 SQL<br/>[SQL_MOL_Ch22.sql]"]
  node_ch23["Chapter 23 SQL<br/>[SQL_MOL_Ch23.sql]"]
end

node_learner(("SQL learner"))

node_learner -->|"runs setup"| node_setup_script
node_setup_script -->|"creates database"| node_sqlnovel
node_learner -->|"uses lesson"| node_ch02
node_learner -->|"uses lesson"| node_ch03
node_learner -->|"uses lesson"| node_ch04
node_learner -->|"uses lesson"| node_ch05
node_learner -->|"uses lesson"| node_ch06
node_learner -->|"uses lesson"| node_ch07
node_learner -->|"uses lesson"| node_ch08
node_learner -->|"uses lesson"| node_ch09
node_learner -->|"uses lesson"| node_ch10
node_learner -->|"uses lesson"| node_ch11
node_learner -->|"uses lesson"| node_ch12
node_learner -->|"uses lesson"| node_ch13
node_learner -->|"uses lesson"| node_ch14
node_learner -->|"uses lesson"| node_ch15
node_learner -->|"uses lesson"| node_ch16
node_learner -->|"uses lesson"| node_ch17
node_learner -->|"uses lesson"| node_ch18
node_learner -->|"uses lesson"| node_ch19
node_learner -->|"uses lesson"| node_ch20
node_learner -->|"uses lesson"| node_ch21
node_learner -->|"uses lesson"| node_ch22
node_learner -->|"uses lesson"| node_ch23
node_sqlnovel -.->|"prerequisite for"| node_ch07
node_sqlnovel -.->|"prerequisite for"| node_ch08
node_sqlnovel -.->|"prerequisite for"| node_ch09
node_sqlnovel -.->|"prerequisite for"| node_ch10
node_sqlnovel -.->|"prerequisite for"| node_ch11
node_sqlnovel -.->|"prerequisite for"| node_ch12
node_sqlnovel -.->|"prerequisite for"| node_ch13
node_sqlnovel -.->|"prerequisite for"| node_ch14
node_sqlnovel -.->|"prerequisite for"| node_ch15
node_sqlnovel -.->|"prerequisite for"| node_ch16
node_sqlnovel -.->|"prerequisite for"| node_ch17
node_sqlnovel -.->|"prerequisite for"| node_ch18
node_sqlnovel -.->|"prerequisite for"| node_ch19
node_sqlnovel -.->|"prerequisite for"| node_ch20
node_sqlnovel -.->|"prerequisite for"| node_ch21
node_sqlnovel -.->|"prerequisite for"| node_ch22
node_sqlnovel -.->|"prerequisite for"| node_ch23

click node_setup_script "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_01/Create_SQLNovel_database.sql"
click node_ch02 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_02/SQL_MOL_Chapter_02.sql"
click node_ch03 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_03/SQL_MOL_Chapter_03.sql"
click node_ch04 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_04/SQL_MOL_Chapter_04.sql"
click node_ch05 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_05/SQL_MOL_Ch05.sql"
click node_ch06 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_06/SQL_MOL_Ch06.sql"
click node_ch07 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_07/SQL_MOL_Ch07.sql"
click node_ch08 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_08/SQL_MOL_Ch08.sql"
click node_ch09 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_09/SQL_MOL_Ch09.sql"
click node_ch10 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_10/SQL_MOL_Ch10.sql"
click node_ch11 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_11/SQL_MOL_Ch11.sql"
click node_ch12 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_12/SQL_MOL_Ch12.sql"
click node_ch13 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_13/SQL_MOL_Ch13.sql"
click node_ch14 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_14/SQL_MOL_Ch14.sql"
click node_ch15 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_15/SQL_MOL_Ch15.sql"
click node_ch16 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_16/SQL_MOL_Ch16.sql"
click node_ch17 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_17/SQL_MOL_Ch17.sql"
click node_ch18 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_18/SQL_MOL_Ch18.sql"
click node_ch19 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_19/SQL_MOL_Ch19.sql"
click node_ch20 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_20/SQL_MOL_Ch20.sql"
click node_ch21 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_21/SQL_MOL_Ch21.sql"
click node_ch22 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_22/SQL_MOL_Ch22.sql"
click node_ch23 "https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_23/SQL_MOL_Ch23.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_setup_script,node_sqlnovel toneBlue
class node_ch02,node_ch03,node_ch04,node_ch05,node_ch06,node_ch07,node_ch08,node_ch09,node_ch10,node_ch11,node_ch12,node_ch13,node_ch14,node_ch15,node_ch16,node_ch17,node_ch18,node_ch19,node_ch20,node_ch21,node_ch22,node_ch23 toneAmber
class node_learner toneIndigo
```

## Components

### Database setup

- [Create SQLNovel](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_01/Create_SQLNovel_database.sql): `Chapter_01/Create_SQLNovel_database.sql`
- **SQLNovel database**

### Chapter lessons

- [Chapter 02 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_02/SQL_MOL_Chapter_02.sql): `Chapter_02/SQL_MOL_Chapter_02.sql`
- [Chapter 03 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_03/SQL_MOL_Chapter_03.sql): `Chapter_03/SQL_MOL_Chapter_03.sql`
- [Chapter 04 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_04/SQL_MOL_Chapter_04.sql): `Chapter_04/SQL_MOL_Chapter_04.sql`
- [Chapter 05 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_05/SQL_MOL_Ch05.sql): `Chapter_05/SQL_MOL_Ch05.sql`
- [Chapter 06 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_06/SQL_MOL_Ch06.sql): `Chapter_06/SQL_MOL_Ch06.sql`
- [Chapter 07 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_07/SQL_MOL_Ch07.sql): `Chapter_07/SQL_MOL_Ch07.sql`
- [Chapter 08 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_08/SQL_MOL_Ch08.sql): `Chapter_08/SQL_MOL_Ch08.sql`
- [Chapter 09 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_09/SQL_MOL_Ch09.sql): `Chapter_09/SQL_MOL_Ch09.sql`
- [Chapter 10 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_10/SQL_MOL_Ch10.sql): `Chapter_10/SQL_MOL_Ch10.sql`
- [Chapter 11 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_11/SQL_MOL_Ch11.sql): `Chapter_11/SQL_MOL_Ch11.sql`
- [Chapter 12 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_12/SQL_MOL_Ch12.sql): `Chapter_12/SQL_MOL_Ch12.sql`
- [Chapter 13 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_13/SQL_MOL_Ch13.sql): `Chapter_13/SQL_MOL_Ch13.sql`
- [Chapter 14 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_14/SQL_MOL_Ch14.sql): `Chapter_14/SQL_MOL_Ch14.sql`
- [Chapter 15 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_15/SQL_MOL_Ch15.sql): `Chapter_15/SQL_MOL_Ch15.sql`
- [Chapter 16 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_16/SQL_MOL_Ch16.sql): `Chapter_16/SQL_MOL_Ch16.sql`
- [Chapter 17 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_17/SQL_MOL_Ch17.sql): `Chapter_17/SQL_MOL_Ch17.sql`
- [Chapter 18 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_18/SQL_MOL_Ch18.sql): `Chapter_18/SQL_MOL_Ch18.sql`
- [Chapter 19 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_19/SQL_MOL_Ch19.sql): `Chapter_19/SQL_MOL_Ch19.sql`
- [Chapter 20 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_20/SQL_MOL_Ch20.sql): `Chapter_20/SQL_MOL_Ch20.sql`
- [Chapter 21 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_21/SQL_MOL_Ch21.sql): `Chapter_21/SQL_MOL_Ch21.sql`
- [Chapter 22 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_22/SQL_MOL_Ch22.sql): `Chapter_22/SQL_MOL_Ch22.sql`
- [Chapter 23 SQL](https://github.com/desertdba/learn-sql-in-a-month-of-lunches/blob/main/Chapter_23/SQL_MOL_Ch23.sql): `Chapter_23/SQL_MOL_Ch23.sql`

### Other components

- **SQL learner**

## Connections

- SQL learner → Create SQLNovel: runs setup
- Create SQLNovel → SQLNovel database: creates database
- SQL learner → Chapter 02 SQL: uses lesson
- SQL learner → Chapter 03 SQL: uses lesson
- SQL learner → Chapter 04 SQL: uses lesson
- SQL learner → Chapter 05 SQL: uses lesson
- SQL learner → Chapter 06 SQL: uses lesson
- SQL learner → Chapter 07 SQL: uses lesson
- SQL learner → Chapter 08 SQL: uses lesson
- SQL learner → Chapter 09 SQL: uses lesson
- SQL learner → Chapter 10 SQL: uses lesson
- SQL learner → Chapter 11 SQL: uses lesson
- SQL learner → Chapter 12 SQL: uses lesson
- SQL learner → Chapter 13 SQL: uses lesson
- SQL learner → Chapter 14 SQL: uses lesson
- SQL learner → Chapter 15 SQL: uses lesson
- SQL learner → Chapter 16 SQL: uses lesson
- SQL learner → Chapter 17 SQL: uses lesson
- SQL learner → Chapter 18 SQL: uses lesson
- SQL learner → Chapter 19 SQL: uses lesson
- SQL learner → Chapter 20 SQL: uses lesson
- SQL learner → Chapter 21 SQL: uses lesson
- SQL learner → Chapter 22 SQL: uses lesson
- SQL learner → Chapter 23 SQL: uses lesson
- SQLNovel database → Chapter 07 SQL: prerequisite for
- SQLNovel database → Chapter 08 SQL: prerequisite for
- SQLNovel database → Chapter 09 SQL: prerequisite for
- SQLNovel database → Chapter 10 SQL: prerequisite for
- SQLNovel database → Chapter 11 SQL: prerequisite for
- SQLNovel database → Chapter 12 SQL: prerequisite for
- SQLNovel database → Chapter 13 SQL: prerequisite for
- SQLNovel database → Chapter 14 SQL: prerequisite for
- SQLNovel database → Chapter 15 SQL: prerequisite for
- SQLNovel database → Chapter 16 SQL: prerequisite for
- SQLNovel database → Chapter 17 SQL: prerequisite for
- SQLNovel database → Chapter 18 SQL: prerequisite for
- SQLNovel database → Chapter 19 SQL: prerequisite for
- SQLNovel database → Chapter 20 SQL: prerequisite for
- SQLNovel database → Chapter 21 SQL: prerequisite for
- SQLNovel database → Chapter 22 SQL: prerequisite for
- SQLNovel database → Chapter 23 SQL: prerequisite for