This repository contains a collection of projects I’ve completed to demonstrate proficiency in SQL.
Each project is based on real-world datasets and highlights specific SQL skills such as string manipulation, date parsing, joins, aggregations, and exploratory analysis.
This repo is a portfolio showcase of my SQL skills, demonstrating:
- Cleaning messy real-world datasets
- Building reusable queries and views
- Analyzing data to extract meaningful insights
- Documenting processes for both technical and non-technical audiences
Dataset Sources:
Description:
Analyzed layoff trends across cities, months, and quarters, and compared layoffs to interest rate changes over time.
Also explored differences between layoffs in private vs. public companies.
Skills Highlighted:
- String cleaning (
REPLACE,SUBSTR,TRIM) - Date parsing (handling
M/D/YYYYformats) - Aggregations (
GROUP BY,COUNT,AVG) - Combining external datasets (joining layoffs with SOFR interest rate data)
Key Findings:
- Layoffs were concentrated in major tech hubs like San Francisco and New York.
- Layoffs peaked in late 2022, coinciding with rising interest rates.
- Public companies tended to report larger absolute layoffs.
(Additional SQL projects will be added here. Each will have its own subfolder with queries, results, and documentation.)
- SQLite / DB Browser for SQLite for query execution and database management
- Excel for exporting and visualizing results
- GitHub for version control and project documentation