# wafiazizi702/dbadmin architecture

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

- Interactive diagram: https://gitdiagram.com/wafiazizi702/dbadmin
- Repository: https://github.com/wafiazizi702/dbadmin

## Overview

This repository is a collection of database administration guides and training material, organized by platform rather than a single deployable application. The main workflow is for an administrator to choose a database platform from the top-level README and consult its guides. MSSQL also contains a Databricks notebook demonstrating data ingestion, transformation, and output to lake, SQL, and Delta destinations. The platform links are explicit in the README; notebook interactions are supported by its excerpt. Other guide internals are not shown, so their relationships are not inferred.

Main entry points: [`README.md`](https://github.com/wafiazizi702/dbadmin/blob/master/README.md) (Platform catalog), [`MSSQL/Contents/Trainings/blog/Databricks 101/Databricks 101 - Github Ready.py`](https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/Trainings/blog/Databricks%20101/Databricks%20101%20-%20Github%20Ready.py) (Databricks notebook), [`Oracle/README.md`](https://github.com/wafiazizi702/dbadmin/blob/master/Oracle/README.md) (Oracle guides), [`MSSQL/README.md`](https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/README.md) (MSSQL guides)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_platforms["Database platforms"]
  node_oracle["Oracle guides<br/>[README.md]"]
  node_mssql_docs["MSSQL guides<br/>[README.md]"]
  node_postgres["Postgres guides<br/>[README.md]"]
  node_redis["KeyDB / Redis<br/>[README.md]"]
  node_mongodb["MongoDB guides<br/>[README.md]"]
end

subgraph group_mssql["MSSQL guides"]
  node_always_encrypt["Always Encrypted<br/>[README.md]"]
  node_availability["Availability groups<br/>[README.md]"]
  node_backup_recovery["Backup and recovery<br/>[README.md]"]
  node_security["Security architecture<br/>[README.md]"]
end

subgraph group_analytics["Analytics example"]
  node_databricks["Databricks notebook"]
end

subgraph group_external["External data services"]
  node_adls[("Azure Data Lake")]
  node_spark["Spark"]
  node_azure_sql[("Azure SQL")]
  node_delta_dbfs[("Delta / DBFS")]
end

node_reader(("Administrator"))
node_catalog["Platform catalog<br/>[README.md]"]

node_reader -->|"browses"| node_catalog
node_catalog -->|"links to"| node_oracle
node_catalog -->|"links to"| node_mssql_docs
node_catalog -->|"links to"| node_postgres
node_catalog -->|"links to"| node_redis
node_catalog -->|"links to"| node_mongodb
node_databricks -->|"reads and writes"| node_adls
node_databricks -->|"uses"| node_spark
node_databricks -->|"writes to"| node_azure_sql
node_databricks -->|"writes to"| node_delta_dbfs

click node_catalog "https://github.com/wafiazizi702/dbadmin/blob/master/README.md"
click node_oracle "https://github.com/wafiazizi702/dbadmin/blob/master/Oracle/README.md"
click node_mssql_docs "https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/README.md"
click node_postgres "https://github.com/wafiazizi702/dbadmin/blob/master/Postgres/README.md"
click node_redis "https://github.com/wafiazizi702/dbadmin/blob/master/Redis_KeyDB/README.md"
click node_mongodb "https://github.com/wafiazizi702/dbadmin/blob/master/MongoDB/README.md"
click node_always_encrypt "https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/AlwaysEncryptColumn2022/README.md"
click node_availability "https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/AlwaysOnAvailabilityGroup/README.md"
click node_backup_recovery "https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/MSSQL219/Backup_and_Recovery/README.md"
click node_security "https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/MSSQL219/Security_architecture/README.md"
click node_databricks "https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/Trainings/blog/Databricks%20101/Databricks%20101%20-%20Github%20Ready.py"

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_oracle,node_mssql_docs,node_postgres,node_redis,node_mongodb toneBlue
class node_always_encrypt,node_availability,node_backup_recovery,node_security toneAmber
class node_databricks toneMint
class node_adls,node_spark,node_azure_sql,node_delta_dbfs toneRose
class node_reader toneIndigo
class node_catalog toneTeal
```

## Components

### Database platforms

- [Oracle guides](https://github.com/wafiazizi702/dbadmin/blob/master/Oracle/README.md): `Oracle/README.md`
- [MSSQL guides](https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/README.md): `MSSQL/README.md`
- [Postgres guides](https://github.com/wafiazizi702/dbadmin/blob/master/Postgres/README.md): `Postgres/README.md`
- [KeyDB / Redis](https://github.com/wafiazizi702/dbadmin/blob/master/Redis_KeyDB/README.md): `Redis_KeyDB/README.md`
- [MongoDB guides](https://github.com/wafiazizi702/dbadmin/blob/master/MongoDB/README.md): `MongoDB/README.md`

### MSSQL guides

- [Always Encrypted](https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/AlwaysEncryptColumn2022/README.md): `MSSQL/Contents/AlwaysEncryptColumn2022/README.md`
- [Availability groups](https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/AlwaysOnAvailabilityGroup/README.md): `MSSQL/Contents/AlwaysOnAvailabilityGroup/README.md`
- [Backup and recovery](https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/MSSQL219/Backup_and_Recovery/README.md): `MSSQL/Contents/MSSQL219/Backup_and_Recovery/README.md`
- [Security architecture](https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/MSSQL219/Security_architecture/README.md): `MSSQL/Contents/MSSQL219/Security_architecture/README.md`

### Analytics example

- [Databricks notebook](https://github.com/wafiazizi702/dbadmin/blob/master/MSSQL/Contents/Trainings/blog/Databricks%20101/Databricks%20101%20-%20Github%20Ready.py): `MSSQL/Contents/Trainings/blog/Databricks 101/Databricks 101 - Github Ready.py`

### External data services

- **Azure Data Lake**
- **Spark**
- **Azure SQL**
- **Delta / DBFS**

### Other components

- **Administrator**
- [Platform catalog](https://github.com/wafiazizi702/dbadmin/blob/master/README.md): `README.md`

## Connections

- Administrator → Platform catalog: browses (evidence: `README.md`)
- Platform catalog → Oracle guides: links to (evidence: `README.md`)
- Platform catalog → MSSQL guides: links to (evidence: `README.md`)
- Platform catalog → Postgres guides: links to (evidence: `README.md`)
- Platform catalog → KeyDB / Redis: links to (evidence: `README.md`)
- Platform catalog → MongoDB guides: links to (evidence: `README.md`)
- Databricks notebook → Azure Data Lake: reads and writes (evidence: `MSSQL/Contents/Trainings/blog/Databricks 101/Databricks 101 - Github Ready.py`)
- Databricks notebook → Spark: uses (evidence: `MSSQL/Contents/Trainings/blog/Databricks 101/Databricks 101 - Github Ready.py`)
- Databricks notebook → Azure SQL: writes to (evidence: `MSSQL/Contents/Trainings/blog/Databricks 101/Databricks 101 - Github Ready.py`)
- Databricks notebook → Delta / DBFS: writes to (evidence: `MSSQL/Contents/Trainings/blog/Databricks 101/Databricks 101 - Github Ready.py`)