{"repo":"Victor-Kipruto-Rop/SQL-for-Data","free":true,"listed":false,"github":"https://github.com/Victor-Kipruto-Rop/SQL-for-Data","clone":"git clone https://github.com/Victor-Kipruto-Rop/SQL-for-Data.git","description":"SQL practice repository covering data analysis, joins, aggregations, window functions, and real-world query solving for data engineering and analytics.","language":"Shell","stars":26,"topics":["data-analysis","data-engineering","data-warehouse","joins","mysql","querying","sql","window-functions"],"license":null,"category":"databases-storage","readme_excerpt":"SQL Data Engineering Project End-to-end SQL project for ingesting raw CSV data, transforming it into an OLTP model, loading a dimensional warehouse, and running analytics, quality checks, performance tests, and monitoring. Project Layout Tech Stack - PostgreSQL 14+ - SQL (psql-compatible scripts) - Optional Python tools (linting/automation) CI - GitHub Actions workflow: .github/workflows/ci.yml - Runs the full pipeline ( ./run all.sh ) on pushes and pull requests to main . - Scheduled monitoring workflow: .github/workflows/monitoring schedule.yml - Runs weekly and on manual trigger; publishes monitoring logs as workflow artifacts. Quick Start One command end-to-end (recommended): Run with Docker (PostgreSQL + pipeline): Manual execution: 1. Create database (example): 2. Set environment values in .env . 3. Initialize core schemas and tables: 4. Load source data and run ETL: 5. Build warehouse model (includes SCD Type 2 update + fact load): 6. Run quality checks, analytics, and tests: Pipeline Flow 1. Extract CSVs into staging raw tables. 2. Transform and standardize datatypes + deduplicate records. 3. Load cleaned data into OLTP tables with upserts. 4. Warehouse load dimensions/facts and apply SCD Type 2 for customers. 5. Analyze KPIs and run fraud/retention/segmentation logic. 6. Monitor row counts and anomaly signals. Notes - SQL is written for PostgreSQL. - etl/extract.sql uses \\copy , so run with psql from project root. - Example data is included in data/raw/ . - Architect","default_branch":null,"files":null,"tree":[],"storefront":"/r/Victor-Kipruto-Rop","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Victor-Kipruto-Rop/SQL-for-Data/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}