joaquinrojash/SQL-Projects
A diverse collection of SQL-based projects that solve practical business problems using relational data. From global economics to urban transport and marketing analytics, these projects highlight strong proficiency in data querying, joins, CTEs, and window functions.
🗃️ SQL Projects Portfolio
Welcome to my SQL Projects Portfolio, a collection of real-world data analysis projects powered by SQL and exploratory data tools. These projects demonstrate my ability to translate business questions into data-driven insights using relational databases, advanced querying, and visualization.
🧰 Tools & Technologies Used
- SQL Engines: PostgreSQL, SQLite
- Languages: SQL, Python (for visualization and notebooks)
- Libraries: pandas, matplotlib, seaborn
- Concepts: Joins, Aggregations, CTEs, Window Functions, Subqueries, Database Design, ERD
- Other: Jupyter Notebooks, Data Cleaning, Statistical Analysis, Problem Solving
📁 Project Summaries
Each folder contains a self-contained project with relevant scripts, data, and notebooks.
1. 🌎 Analyze International Debt Statistics
Explore which countries owe the most debt and to whom using debt statistics from the World Bank.
Skills: SQL joins, aggregation, filtering, global data analysis.
2. 👶 Analyzing American Baby Name Trends
Use SQL to explore baby name popularity over the decades in the U.S.
Skills: CTEs, window functions, time-based analysis, trend detection.
3. ⚡ Analyzing Electric Vehicle Charging Habits
Study EV charging patterns to uncover usage trends and station performance.
Skills: Grouping, average duration analysis, behavior patterns.
4. 🌫️ Analyzing Industry Carbon Emissions
Investigate which sectors contribute most to pollution and how emission levels change.
Skills: Grouping by sector, subqueries, cumulative comparisons.
5. 🏍️ Analyzing Motorcycle Part Sales
Analyze a dataset of motorcycle parts to determine top products, revenue drivers, and trends.
Skills: Transactional analysis, revenue computation, rank functions.
6. 🧠 Analyzing Students' Mental Health
Examine survey data to understand mental health challenges faced by students.
Skills: Conditional logic, percentage breakdowns, demographic filters.
7. 🚇 Exploring London’s Travel Network
Explore TfL (Transport for London) subway data to uncover peak travel times and busiest lines.
Skills: Multi-table joins, ridership analysis, daily trends.
8. 🌱 Impact Analysis of GoodThought NGO Initiatives
Assess the effectiveness of an NGO’s social campaigns using project and impact data.
Skills: ERD interpretation, relational schema analysis, data summarization.
📈 Key Strengths Demonstrated
- Comfort with relational database structure and logic
- Advanced SQL for business analysis and insight generation
- Real-world datasets and practical case studies
- Communication of complex data insights through visual and narrative storytelling
📬 Let’s Connect!
If you’re hiring or collaborating on data-centric projects, I’d love to chat. Feel free to reach out!