# karthickravichandran2101-droid/sql-learning-journey architecture

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

- Interactive diagram: https://gitdiagram.com/karthickravichandran2101-droid/sql-learning-journey
- Repository: https://github.com/karthickravichandran2101-droid/sql-learning-journey

## Overview

This is a SQL Server learning portfolio: users study T-SQL through topic exercises and a hospital-management project, then execute queries in SSMS, validate results, and document evidence. The graph groups the documented learning areas and the hospital project’s distinct database, data-entry, and query stages; operator directories are grouped by concept. No source excerpts were provided, so links describe only relationships stated in the root README or clearly represented by the project tree; internal SQL calls and table-level dependencies are not inferred.

Main entry points: [`README.md`](https://github.com/karthickravichandran2101-droid/sql-learning-journey/blob/main/README.md) (SQL Practice), [`Hospital_Patient_Management_System/02_DML`](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/02_DML) (Hospital Data Changes), [`Hospital_Patient_Management_System/03_DRL`](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/03_DRL) (Hospital Queries), [`Hospital_Patient_Management_System/01_DDL`](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/01_DDL) (Hospital Database Setup)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_learning["Learning Workflow"]
  node_practice["SQL Practice<br/>[README.md]"]
  node_validation["Result Validation<br/>[README.md]"]
  node_documentation["Portfolio Documentation<br/>[README.md]"]
end

subgraph group_database["Database Operations"]
  node_ddl["DDL Examples"]
  node_dml["DML Examples"]
  node_renaming["Rename and Copy"]
end

subgraph group_queries["Query Concepts"]
  node_arithmetic["Arithmetic Operators"]
  node_comparison["Comparison Operators"]
  node_logical["Logical Operators"]
  node_setops["Set Operators"]
  node_special["Special Operators"]
end

subgraph group_hospital["Hospital Project"]
  node_hospitaldb["Hospital Database Setup"]
  node_hospitaldata["Hospital Data Changes"]
  node_hospitalqueries["Hospital Queries"]
  node_hospitaloperators["Hospital Operator Exercises"]
end

node_learner(("Learner"))
node_ssms["SSMS"]
node_sqlserver[("SQL Server")]

node_learner -->|"practices"| node_practice
node_practice -->|"executes in"| node_ssms
node_ssms -->|"runs queries"| node_sqlserver
node_practice -->|"validates results"| node_validation
node_validation -->|"documents evidence"| node_documentation
node_practice -->|"includes"| node_ddl
node_practice -->|"includes"| node_dml
node_practice -->|"includes"| node_renaming
node_practice -->|"includes"| node_arithmetic
node_practice -->|"includes"| node_comparison
node_practice -->|"includes"| node_logical
node_practice -.->|"covers"| node_setops
node_practice -.->|"covers"| node_special
node_hospitaldb -.->|"followed by"| node_hospitaldata
node_hospitaldata -.->|"followed by"| node_hospitalqueries
node_hospitalqueries -.->|"also includes"| node_hospitaloperators

click node_practice "https://github.com/karthickravichandran2101-droid/sql-learning-journey/blob/main/README.md"
click node_validation "https://github.com/karthickravichandran2101-droid/sql-learning-journey/blob/main/README.md"
click node_documentation "https://github.com/karthickravichandran2101-droid/sql-learning-journey/blob/main/README.md"
click node_ddl "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/01_DDL"
click node_dml "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/DML"
click node_renaming "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/04_Renaming_and_Copying_Data"
click node_arithmetic "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/05_Operators"
click node_comparison "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/06_Comparison_Operators"
click node_logical "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/07_Logical_Operators"
click node_setops "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/08_Set_Operators"
click node_special "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/09_Special_Operators"
click node_hospitaldb "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/01_DDL"
click node_hospitaldata "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/02_DML"
click node_hospitalqueries "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/03_DRL"
click node_hospitaloperators "https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System"

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_practice,node_validation,node_documentation toneBlue
class node_ddl,node_dml,node_renaming,node_sqlserver toneAmber
class node_arithmetic,node_comparison,node_logical,node_setops,node_special toneMint
class node_hospitaldb,node_hospitaldata,node_hospitalqueries,node_hospitaloperators toneRose
class node_learner,node_ssms toneIndigo
```

## Components

### Learning Workflow

- [SQL Practice](https://github.com/karthickravichandran2101-droid/sql-learning-journey/blob/main/README.md): `README.md`
- [Result Validation](https://github.com/karthickravichandran2101-droid/sql-learning-journey/blob/main/README.md): `README.md`
- [Portfolio Documentation](https://github.com/karthickravichandran2101-droid/sql-learning-journey/blob/main/README.md): `README.md`

### Database Operations

- [DDL Examples](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/01_DDL): `01_DDL`
- [DML Examples](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/DML): `DML`
- [Rename and Copy](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/04_Renaming_and_Copying_Data): `04_Renaming_and_Copying_Data`

### Query Concepts

- [Arithmetic Operators](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/05_Operators): `05_Operators`
- [Comparison Operators](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/06_Comparison_Operators): `06_Comparison_Operators`
- [Logical Operators](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/07_Logical_Operators): `07_Logical_Operators`
- [Set Operators](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/08_Set_Operators): `08_Set_Operators`
- [Special Operators](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/09_Special_Operators): `09_Special_Operators`

### Hospital Project

- [Hospital Database Setup](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/01_DDL): `Hospital_Patient_Management_System/01_DDL`
- [Hospital Data Changes](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/02_DML): `Hospital_Patient_Management_System/02_DML`
- [Hospital Queries](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System/03_DRL): `Hospital_Patient_Management_System/03_DRL`
- [Hospital Operator Exercises](https://github.com/karthickravichandran2101-droid/sql-learning-journey/tree/main/Hospital_Patient_Management_System): `Hospital_Patient_Management_System`

### Other components

- **Learner**
- **SSMS**
- **SQL Server**

## Connections

- Learner → SQL Practice: practices (evidence: `README.md`)
- SQL Practice → SSMS: executes in (evidence: `README.md`)
- SSMS → SQL Server: runs queries (evidence: `README.md`)
- SQL Practice → Result Validation: validates results (evidence: `README.md`)
- Result Validation → Portfolio Documentation: documents evidence (evidence: `README.md`)
- SQL Practice → DDL Examples: includes (evidence: `README.md`)
- SQL Practice → DML Examples: includes (evidence: `README.md`)
- SQL Practice → Rename and Copy: includes (evidence: `README.md`)
- SQL Practice → Arithmetic Operators: includes (evidence: `README.md`)
- SQL Practice → Comparison Operators: includes (evidence: `README.md`)
- SQL Practice → Logical Operators: includes (evidence: `README.md`)
- SQL Practice → Set Operators: covers
- SQL Practice → Special Operators: covers
- Hospital Database Setup → Hospital Data Changes: followed by
- Hospital Data Changes → Hospital Queries: followed by
- Hospital Queries → Hospital Operator Exercises: also includes
