# christianebacani/roadmap architecture

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

- Interactive diagram: https://gitdiagram.com/christianebacani/roadmap
- Repository: https://github.com/christianebacani/roadmap

## Overview

##### Main Components

a. Learning Tracks (Primary Components):
- SQL Learning Track
- Python Engineering Track
- Database Design Track
- ETL Pipeline Track

b. Project Categories:
- Practice Projects
- Guided Projects
- CLI Applications
- Data Pipeline Projects

**Level 1 (Top): Core Learning Domains**
**Level 2: Project Categories**
**Level 3: Implementation Components**
**Level 4: Technical Dependencies**

##### Specific Component Relationships

a. SQL Track Components:
- Progression from Introduction → Intermediate → Joining → Relational
- To Database Design track
- Link to practical implementations (8 Week SQL Challenge)

b. Python Engineering Track:
- ETL Pipelines to Database components
- Link Coding Challenges to skill development
- CLI Projects as practical applications

c. ETL Pipeline Components:
- Three main source types:
- Flat Files
- Web Scraping
- API Integration
- Transformation flows
- To target storage systems

##### Key Relationships to Highlight

- How SQL knowledge feeds into Database Design
- Demonstrate how Python skills enable ETL Pipeline development
- Connection between theoretical learning and practical projects
- Progression from basic to advanced concepts

##### Implementation Details

- Clear section headers for each learning track
- Version control integration (GitHub)
- Data flow directions between components
- Tool and technology dependencies
- Project complexity levels

##### Documentation Elements

Supporting elements:
- Version information
- Last updated date
- Skill level requirements
- Technology stack references
- Learning resource links

## Diagram (Mermaid)

```mermaid
graph TB
    subgraph Legend
        A[Main Track]
        B([Project Category])
        C{{Implementation}}
        D{Decision Point}
        E[(Database)]
        style A fill:#f0f0f0
        style B fill:#e1e1e1
        style C fill:#d2d2d2
        style D fill:#c3c3c3
        style E fill:#b4b4b4
    end

    subgraph Core_Learning_Domains
        SQL[SQL Learning Track]:::sql
        Python[Python Engineering Track]:::python
        DB[Database Design Track]:::database
        ETL[ETL Pipeline Track]:::etl
    end

    subgraph SQL_Components
        SQL --> SQL_Intro[Introduction to SQL]:::sql
        SQL --> SQL_Inter[Intermediate SQL]:::sql
        SQL --> SQL_Join[Joining Data]:::sql
        SQL --> SQL_Rel[Relational Databases]:::sql
        SQL --> SQL_Challenge[8 Week SQL Challenge]:::sql
    end

    subgraph Python_Components
        Python --> Py_Challenge[Coding Challenges]:::python
        Python --> CLI[CLI Applications]:::python
        Python --> DataEng[Data Engineering]:::python
        
        Py_Challenge --> HackerRank[HackerRank Problems]:::python
        Py_Challenge --> LeetCode[LeetCode Problems]:::python
        
        CLI --> SMS[Student Management System]:::python
    end

    subgraph DB_Components
        DB --> DB_Design[Database Design Principles]:::database
        DB --> DB_Games[Video Game Reviews Design]:::database
        DB --> DB_Weather[Weather Data Design]:::database
    end

    subgraph ETL_Components
        ETL --> Sources{Data Sources}:::etl
        Sources --> FlatFiles[Flat Files Processing]:::etl
        Sources --> WebScraping[Web Scraping]:::etl
        Sources --> API[API Integration]:::etl
        
        FlatFiles --> Transform((Transform)):::etl
        WebScraping --> Transform
        API --> Transform
        
        Transform --> Storage[(Target Storage)]:::etl
    end

    %% Relationships
    SQL -.-> DB
    Python -.-> ETL
    DB -.-> ETL
    
    %% Click Events
    click SQL_Intro "https://github.com/christianebacani/Roadmap/tree/main/Introduction to SQL/"
    click SQL_Inter "https://github.com/christianebacani/Roadmap/tree/main/Intermediate SQL/"
    click SQL_Join "https://github.com/christianebacani/Roadmap/tree/main/Joining Data in SQL/"
    click SQL_Rel "https://github.com/christianebacani/Roadmap/tree/main/Relational Databases in SQL/"
    click SQL_Challenge "https://github.com/christianebacani/Roadmap/tree/main/8 Week SQL Challenge/"
    
    click Py_Challenge "https://github.com/christianebacani/Roadmap/tree/main/Coding Challenges using Python/"
    click CLI "https://github.com/christianebacani/Roadmap/tree/main/Python CLI Projects/"
    click DataEng "https://github.com/christianebacani/Roadmap/tree/main/Python for Data Engineering/"
    
    click DB_Design "https://github.com/christianebacani/Roadmap/tree/main/Database Design/"
    click DB_Games "https://github.com/christianebacani/Roadmap/tree/main/Database Design/Database Design of Video Game Reviews Kaggle Datasets/"
    click DB_Weather "https://github.com/christianebacani/Roadmap/tree/main/Database Design/Database Design of Historical Weather Data from the Year of 2024 of Balanga City, Bataan/"
    
    click FlatFiles "https://github.com/christianebacani/Roadmap/tree/main/Python for Data Engineering/ETL Pipelines/Scripts/ETL Pipeline Scripts for Extracting Flat Files/"
    click WebScraping "https://github.com/christianebacani/Roadmap/tree/main/Python for Data Engineering/ETL Pipelines/Scripts/ETL Pipeline Scripts for Web Scraping/"
    click API "https://github.com/christianebacani/Roadmap/tree/main/Python for Data Engineering/ETL Pipelines/Scripts/ETL Pipeline Scripts using APIs/"
    
    click HackerRank "https://github.com/christianebacani/Roadmap/tree/main/Coding Challenges using Python/HackerRank Solved Problems/"
    click LeetCode "https://github.com/christianebacani/Roadmap/tree/main/Coding Challenges using Python/LeetCode Solved Problems/"
    click SMS "https://github.com/christianebacani/Roadmap/tree/main/Python CLI Projects/Student Management System/"

    classDef sql fill:#4a90e2
    classDef python fill:#2ecc71
    classDef database fill:#9b59b6
    classDef etl fill:#e67e22
```
