# ratnesh-181998/sql architecture

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

- Interactive diagram: https://gitdiagram.com/ratnesh-181998/sql
- Repository: https://github.com/ratnesh-181998/sql

## Overview

This repository is a static SQL learning collection rather than an application runtime. The learner-facing workflow is to consult reference material, study lessons and interview problems, then work through SQL assignments or examples; CSV and spreadsheet files provide sample data. The README explicitly highlights a SQL cheat sheet and window-function patterns. Source excerpts were unavailable, so relationships among scripts, assignments, datasets, and database setup are not asserted.

Main entry points: [`README.md`](https://github.com/ratnesh-181998/sql/blob/main/README.md) (SQL cheat sheet), [`SQL Window Functions 50 Patterns.pdf`](https://github.com/ratnesh-181998/sql/blob/main/SQL%20Window%20Functions%2050%20Patterns.pdf) (Window patterns)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_learning["Learning materials"]
  node_readme["SQL cheat sheet<br/>[README.md]"]
  node_windowpatterns["Window patterns"]
  node_sqlreference["SQL references"]
  node_interviewguides["Interview guides"]
  node_classnotes["Class notes"]
end

subgraph group_practice["SQL practice"]
  node_commands1["Class commands"]
  node_commands2["Class commands 2"]
  node_commands3["Class commands 3"]
  node_commands4["Class commands 4"]
  node_assignments["SQL assignments"]
  node_musicanalysis["Music store analysis"]
  node_schema["DDL schema<br/>[DDL.sql]"]
  node_datachanges["DML examples<br/>[DML.sql]"]
  node_databaseconfig["MySQL setup"]
end

subgraph group_data["Sample data"]
  node_musiccsv["Music store data<br/>[track.csv]"]
  node_citydata["City data<br/>[City_Table.xlsx]"]
  node_stationdata["Station data<br/>[stationdata.xlsx]"]
end

node_learner(("Learner"))

node_learner -->|"reads"| node_readme
node_readme -->|"highlights"| node_windowpatterns

click node_readme "https://github.com/ratnesh-181998/sql/blob/main/README.md"
click node_windowpatterns "https://github.com/ratnesh-181998/sql/blob/main/SQL%20Window%20Functions%2050%20Patterns.pdf"
click node_sqlreference "https://github.com/ratnesh-181998/sql/blob/main/The%20Ultimate%20Guide%20of%20SQL.pdf"
click node_interviewguides "https://github.com/ratnesh-181998/sql/blob/main/300%20Real%20SQL%20Interview%20Questions.pdf"
click node_classnotes "https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_1_PPT.pdf"
click node_commands1 "https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_1_Commands.sql"
click node_commands2 "https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_2_Commands.sql"
click node_commands3 "https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_3_Commands.sql"
click node_commands4 "https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_4_Commands.sql"
click node_assignments "https://github.com/ratnesh-181998/sql/blob/main/GDS_SQL_Class_1_Assignment.pdf"
click node_musicanalysis "https://github.com/ratnesh-181998/sql/blob/main/Music_Store_Analysis_SQL.sql"
click node_schema "https://github.com/ratnesh-181998/sql/blob/main/DDL.sql"
click node_datachanges "https://github.com/ratnesh-181998/sql/blob/main/DML.sql"
click node_databaseconfig "https://github.com/ratnesh-181998/sql/blob/main/mysql_docker_compose.yml"
click node_musiccsv "https://github.com/ratnesh-181998/sql/blob/main/track.csv"
click node_citydata "https://github.com/ratnesh-181998/sql/blob/main/City_Table.xlsx"
click node_stationdata "https://github.com/ratnesh-181998/sql/blob/main/stationdata.xlsx"

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_windowpatterns,node_sqlreference,node_interviewguides,node_classnotes toneBlue
class node_commands1,node_commands2,node_commands3,node_commands4,node_assignments,node_musicanalysis,node_schema,node_datachanges,node_databaseconfig toneAmber
class node_musiccsv,node_citydata,node_stationdata toneMint
class node_learner toneIndigo
```

## Components

### Learning materials

- [SQL cheat sheet](https://github.com/ratnesh-181998/sql/blob/main/README.md): `README.md`
- [Window patterns](https://github.com/ratnesh-181998/sql/blob/main/SQL%20Window%20Functions%2050%20Patterns.pdf): `SQL Window Functions 50 Patterns.pdf`
- [SQL references](https://github.com/ratnesh-181998/sql/blob/main/The%20Ultimate%20Guide%20of%20SQL.pdf): `The Ultimate Guide of SQL.pdf`
- [Interview guides](https://github.com/ratnesh-181998/sql/blob/main/300%20Real%20SQL%20Interview%20Questions.pdf): `300 Real SQL Interview Questions.pdf`
- [Class notes](https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_1_PPT.pdf): `SQL_Class_1_PPT.pdf`

### SQL practice

- [Class commands](https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_1_Commands.sql): `SQL_Class_1_Commands.sql`
- [Class commands 2](https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_2_Commands.sql): `SQL_Class_2_Commands.sql`
- [Class commands 3](https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_3_Commands.sql): `SQL_Class_3_Commands.sql`
- [Class commands 4](https://github.com/ratnesh-181998/sql/blob/main/SQL_Class_4_Commands.sql): `SQL_Class_4_Commands.sql`
- [SQL assignments](https://github.com/ratnesh-181998/sql/blob/main/GDS_SQL_Class_1_Assignment.pdf): `GDS_SQL_Class_1_Assignment.pdf`
- [Music store analysis](https://github.com/ratnesh-181998/sql/blob/main/Music_Store_Analysis_SQL.sql): `Music_Store_Analysis_SQL.sql`
- [DDL schema](https://github.com/ratnesh-181998/sql/blob/main/DDL.sql): `DDL.sql`
- [DML examples](https://github.com/ratnesh-181998/sql/blob/main/DML.sql): `DML.sql`
- [MySQL setup](https://github.com/ratnesh-181998/sql/blob/main/mysql_docker_compose.yml): `mysql_docker_compose.yml`

### Sample data

- [Music store data](https://github.com/ratnesh-181998/sql/blob/main/track.csv): `track.csv`
- [City data](https://github.com/ratnesh-181998/sql/blob/main/City_Table.xlsx): `City_Table.xlsx`
- [Station data](https://github.com/ratnesh-181998/sql/blob/main/stationdata.xlsx): `stationdata.xlsx`

### Other components

- **Learner**

## Connections

- Learner → SQL cheat sheet: reads (evidence: `README.md`)
- SQL cheat sheet → Window patterns: highlights (evidence: `README.md`)