Data Engineering

🛒 Point of Sale (POS) System - PostgreSQL

A comprehensive PostgreSQL database design for a modern retail Point of Sale system, featuring advanced SQL techniques including triggers, stored procedures, materielized views, and strategic indexing.

PostgreSQL

View on GitHub ->

🔌PostgreSQL Database Connector

A lightweight Python toolkit for connecting to PostgreSQL and AWS-Redshift databases and executing SQL queries directly in notebooks or Python scripts. This repository provides a simple, cross-platform solution for database operations with minimal configuration.

Python * Pandas * PostgreSQL * AWS-Redshift

View on GitHub ->

🔌Oracle - Python Database Connector

This toolkit provides a robust solution for connecting to Oracle databases and managing Pluggable Databases (PDB) through Python.

Python * Pandas * Oracle

View on GitHub ->