# rishabhnmishra/sql_tutorial architecture

> Architecture diagram of the GitHub repository rishabhnmishra/sql_tutorial, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-01-22). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/rishabhnmishra/sql_tutorial
- Repository: https://github.com/rishabhnmishra/sql_tutorial

## Overview

##### Main Components

a) Educational Content Layer:
- PDF Tutorial Document
- Video Content Reference (YouTube playlist)

b) Practice Data Layer:
- CSV Files Structure
- Sample Datasets Categories:
- Customer Data
- Payment Data
- CTE Examples
- Case Statement Examples

##### Specific Design Elements

- Document symbol for the PDF file

b) Annotations:
- Notes about the relationship between tutorial content and practice files
- File sizes or record counts if relevant

##### Flow and Relationships

- A progression path showing learning order:
- Basic CSV files → CTE examples → Case Statement examples

## Diagram (Mermaid)

```mermaid
graph TB
    %% Define styles
    classDef tutorial fill:#f9f,stroke:#333,stroke-width:2px
    classDef video fill:#ff9,stroke:#333,stroke-width:2px
    classDef basic fill:#9f9,stroke:#333,stroke-width:2px
    classDef advanced fill:#99f,stroke:#333,stroke-width:2px
    classDef group fill:none,stroke:#333,stroke-width:2px

    subgraph Learning_Resources["Learning Resources Layer"]
        Tutorial["Complete SQL Tutorial (Hindi)"]:::tutorial
        Video["YouTube Tutorial Playlist"]:::video
    end

    subgraph Practice_Data["Practice Data Layer"]
        subgraph Basic["Basic Concepts"]
            Customer[(Customer Data)]:::basic
            Payment[(Payment Data)]:::basic
        end

        subgraph Advanced["Advanced Concepts"]
            CustomerCTE[(CTE Customer Examples)]:::advanced
            PaymentCTE[(CTE Payment Examples)]:::advanced
            PaymentCase[(Case Statement Examples)]:::advanced
        end
    end

    %% Relationships
    Tutorial <--> Video
    Tutorial --> Customer
    Tutorial --> Payment
    Tutorial --> CustomerCTE
    Tutorial --> PaymentCTE
    Tutorial --> PaymentCase

    Customer -.-> CustomerCTE
    Payment -.-> PaymentCTE
    Payment -.-> PaymentCase

    %% Click events
    click Tutorial "https://github.com/rishabhnmishra/SQL_Tutorial/blob/main/Complete SQL Tutorial In Hindi By Rishabh Mishra.pdf"
    click Customer "https://github.com/rishabhnmishra/SQL_Tutorial/blob/main/customer.csv"
    click Payment "https://github.com/rishabhnmishra/SQL_Tutorial/blob/main/payment.csv"
    click CustomerCTE "https://github.com/rishabhnmishra/SQL_Tutorial/blob/main/customer-CTE.csv"
    click PaymentCTE "https://github.com/rishabhnmishra/SQL_Tutorial/blob/main/payment-CTE.csv"
    click PaymentCase "https://github.com/rishabhnmishra/SQL_Tutorial/blob/main/payment-case statement.csv"

    %% Legend
    subgraph Legend
        L1[Tutorial Document]:::tutorial
        L2[Video Content]:::video
        L3[Basic Data Files]:::basic
        L4[Advanced Data Files]:::advanced
    end
```
