How pedroaugustopivetta/sql-mastery-hub works
This repository is a portfolio of five PostgreSQL relational-database scenarios, not a single application workflow. Each project documents a schema-definition stage (DDL), data-population and modification stage (DML), and query/analytics stage (DQL), applied to its domain database. The README names the principal entities and capabilities; no SQL excerpts were available, so the graph reflects those documented relationships without inferring finer-grained query or execution behavior.
Main entry points: DDL - E-Commerce - Query.sql Schema DDL · DML - E-Commerce - Query.sql Sales Data DML · DQL - E-Commerce - Query.sql Sales Queries · DDL - E-Learning - Query.sql Schema DDL
Components 20
E-Commerce
- Schema DDL
E-Commerce/DDL - E-Commerce - Query.sql - Sales Data DML
E-Commerce/DML - E-Commerce - Query.sql - Sales Queries
E-Commerce/DQL - E-Commerce - Query.sql - Commerce Database
E-Learning
- Schema DDL
E-Learning/DDL - E-Learning - Query.sql - Learning Data DML
E-Learning/DML - E-Learning - Query.sql - Learning Queries
E-Learning/DQL - E-Learning - Query.sql - Learning Database
Streaming
- Schema DDL
Streaming/DDL - Streaming - Query.sql - Streaming Data DML
Streaming/DML - Streaming - Query.sql - Streaming Queries
Streaming/DQL - Streaming - Query.sql - Streaming Database
Medical Clinic
- Schema DDL
MedicalClinic/DDL - MedicalClinic - Query.sql - Clinic Data DML
MedicalClinic/DML - MedicalClinic - Query.sql - Clinic Queries
MedicalClinic/DQL - MedicalClinic- Query.sql - Clinic Database
Finance App
- Schema DDL
FinanceApp/DDL - FinanceApp - Query.sql - Finance Data DML
FinanceApp/DML - FinanceApp - Query.sql - Finance Queries
FinanceApp/DQL - FinanceApp - Query.sql - Finance Database
Connections 15
- Schema DDL → Commerce Database: defines schema
- Sales Data DML → Commerce Database: writes data
- Sales Queries → Commerce Database: queries data
- Schema DDL → Learning Database: defines schema
- Learning Data DML → Learning Database: writes data
- Learning Queries → Learning Database: queries data
- Schema DDL → Streaming Database: defines schema
- Streaming Data DML → Streaming Database: writes data
- Streaming Queries → Streaming Database: queries data
- Schema DDL → Clinic Database: defines schema
- Clinic Data DML → Clinic Database: writes data
- Clinic Queries → Clinic Database: queries data
- Schema DDL → Finance Database: defines schema
- Finance Data DML → Finance Database: writes data
- Finance Queries → Finance Database: queries data