Purpose of this repository is to showcase my proficiency in SQL. This repository demonstrates SQL skills applied to pharmacy/pharmaceutical operations: sales analysis, inventory monitoring, and simple supply chain insights. It is tailored for roles in healthcare software and pharmacy management.
Contents
sql/create_tables.sql – schema definition
sql/sample_data.sql – example dataset
sql/analysis_queries.sql – analytical SQL queries (basic → advanced)
sql/indexes_and_explain_examples.sql – indexing and query plan demonstrations
assets/ – charts or screenshots for visualization