# s-shemmee/sql-101 architecture

> Architecture diagram of the GitHub repository s-shemmee/sql-101, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-05-22). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/s-shemmee/sql-101
- Repository: https://github.com/s-shemmee/sql-101

## Overview

1. This repository is not an application runtime; it is a content-only SQL learning package. The “system” is the documentation set itself: a README-led tutorial plus two PDF note bundles.

2. The top-level entry point is `README.md`. It acts as the curriculum map and narrative layer, organizing the material into a learning path: installation, querying, data modification, schema rules, joins, aggregation, subqueries/views, indexing, transactions, advanced topics, and exercises.

3. The core knowledge content lives in the PDFs:
   - `Sql Notes Part 1 & Part 2 marged.pdf`
   - `Sql Short Notes Part 3.pdf`
   These likely contain the detailed lecture/notes material behind the README topics, with the README serving as a summary and table of contents.

4. The repository’s main boundary is between educational content and external database engines. It does not ship a database server, schema, or executable SQL project; instead, it assumes the learner will install and use an external RDBMS.

5. The external runtime targets are explicitly MySQL, PostgreSQL, and SQLite. These are not dependencies managed by the repo, but supported learning environments. Their installation and version checks are part of the onboarding flow described in the README.

6. The data flow is instructor/content → learner → local DBMS:
   - The learner reads the README and PDFs.
   - The learner installs or chooses a database engine.
   - The learner runs SQL statements in that engine to practice the concepts.
   - The repository provides conceptual guidance, not stored datasets or automated validation.

7. The SQL concepts covered imply several logical subsystems in the learning material:
   - Querying and filtering
   - Data modification
   - Schema design and constraints
   - Relational modeling and joins
   - Aggregation and grouping
   - Subqueries and views
   - Performance via indexes
   - Transaction behavior and isolation
   - Advanced server-side features like procedures, triggers, and UDFs

8. Exercises are part of the educational workflow, but the repo does not include an obvious executable harness, test suite, or solution files in the file tree provided. Any “solutions” appear to be narrative rather than code-based assets.

9. The README also points to external learning resources and practice sites such as SQLZoo, HackerRank, and LeetCode. These sit outside the repository boundary and function as optional practice/execution environments rather than integrated services.

10. From an architecture-diagram perspective, the repo should be modeled as a static documentation hub with three asset nodes: README index, detailed PDF notes, and external practice/install targets. There are no backend services, APIs, build pipelines, or persistent application data stores inside the repository itself.

Main entry points: [`README.md`](https://github.com/s-shemmee/sql-101/blob/main/README.md) (README), [`Sql Notes Part 1 & Part 2 marged.pdf`](https://github.com/s-shemmee/sql-101/blob/HEAD/Sql%20Notes%20Part%201%20%26%20Part%202%20marged.pdf) (Part 1-2 Notes), [`Sql Short Notes Part 3.pdf`](https://github.com/s-shemmee/sql-101/blob/HEAD/Sql%20Short%20Notes%20Part%203.pdf) (Part 3 Notes)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_content["Repository Content"]
  node_readme["README<br/>curriculum index<br/>[README.md]"]
  node_notes12["Part 1-2 Notes<br/>pdf notes"]
  node_notes3["Part 3 Notes<br/>pdf notes"]
  node_querying["Querying<br/>SQL topic"]
  node_schema["Schema<br/>SQL topic"]
  node_joins["Joins<br/>SQL topic"]
  node_perf["Performance<br/>SQL topic"]
  node_advanced["Advanced SQL<br/>SQL topic"]
  node_exercises["Exercises<br/>practice workflow"]
end

subgraph group_external["External Targets"]
  node_dbms[("DBMS<br/>external runtime")]
  node_practice(("Practice Sites<br/>external practice"))
end

node_readme -->|"summarizes"| node_notes12
node_readme -->|"extends"| node_notes3
node_readme -->|"covers"| node_querying
node_readme -->|"covers"| node_schema
node_readme -->|"covers"| node_joins
node_readme -->|"covers"| node_perf
node_readme -->|"covers"| node_advanced
node_readme -->|"includes"| node_exercises
node_querying -->|"runs in"| node_dbms
node_schema -->|"runs in"| node_dbms
node_joins -->|"runs in"| node_dbms
node_perf -->|"runs in"| node_dbms
node_advanced -->|"runs in"| node_dbms
node_exercises -.->|"extends to"| node_practice

click node_readme "https://github.com/s-shemmee/sql-101/blob/main/README.md"
click node_notes12 "https://github.com/s-shemmee/sql-101/blob/main/Sql Notes Part 1 & Part 2 marged.pdf"
click node_notes3 "https://github.com/s-shemmee/sql-101/blob/main/Sql Short Notes Part 3.pdf"

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_readme,node_notes12,node_notes3,node_querying,node_schema,node_joins,node_perf,node_advanced,node_exercises toneBlue
class node_dbms,node_practice toneAmber
```

## Components

### Repository Content

Static learning materials bundled in the repository.

- [README](https://github.com/s-shemmee/sql-101/blob/main/README.md): curriculum index · Top-level learning path and topic map for the SQL course. · `README.md`
- [Part 1-2 Notes](https://github.com/s-shemmee/sql-101/blob/HEAD/Sql%20Notes%20Part%201%20%26%20Part%202%20marged.pdf): pdf notes · Detailed lecture notes covering the main SQL foundations and core topics. · `Sql Notes Part 1 & Part 2 marged.pdf`
- [Part 3 Notes](https://github.com/s-shemmee/sql-101/blob/HEAD/Sql%20Short%20Notes%20Part%203.pdf): pdf notes · Short notes bundle for later SQL topics and advanced material. · `Sql Short Notes Part 3.pdf`
- **Querying**: SQL topic · SELECT, filtering, ordering, and basic retrieval workflows.
- **Schema**: SQL topic · Tables, constraints, relationships, and data modification basics.
- **Joins**: SQL topic · Relational linking, grouping, aggregation, subqueries, and views.
- **Performance**: SQL topic · Indexes, transactions, and concurrency-oriented behavior.
- **Advanced SQL**: SQL topic · Procedures, triggers, UDFs, and other server-side features.
- **Exercises**: practice workflow · Learner practice and review activities referenced by the tutorial.

### External Targets

Database engines and practice sites used outside the repo.

- **DBMS**: external runtime · External MySQL, PostgreSQL, or SQLite installation used to run statements.
- **Practice Sites**: external practice · External learning platforms such as SQLZoo, HackerRank, and LeetCode.

## Connections

- README → Part 1-2 Notes: summarizes · README maps the main curriculum to the detailed note bundle.
- README → Part 3 Notes: extends · README points to the later-topic notes bundle.
- README → Querying: covers · Curriculum starts with querying and filtering.
- README → Schema: covers · Curriculum includes modification, schema rules, and relational basics.
- README → Joins: covers · Curriculum includes joins, aggregation, subqueries, and views.
- README → Performance: covers · Curriculum includes indexing and transactions.
- README → Advanced SQL: covers · Curriculum includes procedures, triggers, and UDFs.
- README → Exercises: includes · Exercises are part of the learning flow.
- Querying → DBMS: runs in · Concepts are practiced in an external SQL engine.
- Schema → DBMS: runs in · Schema and data modification practice happens in a local DBMS.
- Joins → DBMS: runs in · Relational queries are executed in an external DBMS.
- Performance → DBMS: runs in · Indexes and transactions are explored in an external DBMS.
- Advanced SQL → DBMS: runs in · Advanced SQL features depend on the chosen engine.
- Exercises → Practice Sites: extends to · Optional practice can be done on external learning platforms.
