This repository is a personal archive of SQL projects, sample databases, and practice challenges I’ve worked through. It’s where I keep track of the tools I’ve used, the datasets I’ve explored, and the kinds of problems I’ve tackled across different SQL environments
Foundational SQL concepts including:
- SELECT, WHERE, ORDER BY
- JOINs and relationships
- Aggregations and grouping
- Basic data cleaning patterns
Focused on analytical SQL patterns:
- Window functions
- Subqueries and nested logic
- CTEs and recursive queries
- Real‑world business scenarios
A practice database for exploring:
- Mathematical expressions
- Aggregate functions
- Order of operations
- “What‑if” calculations and scenario analysis
This project helped reinforce how SQL handles arithmetic, grouping, and numeric logic.
Tutorial credit: DigitalOcean.
A data analysis project based on a fictional digital music store.
Includes information on:
- Artists, albums, and tracks
- Employees and customers
- Invoices and sales
Used to practice:
- Multi‑table joins
- Customer behavior analysis
- Sales insights
- Query optimization
A full OLTP database for a fictional bicycle manufacturer.
Covers:
- Manufacturing
- Sales
- Purchasing
- Product management
- Human resources
Used for:
- Complex joins
- Relational modeling
- Business‑style reporting queries
Sales and order data for a fictional gourmet food supplier.
Includes:
- Customers
- Products
- Orders
- Shippers
- Employees
This dataset was part of a Maven Analytics challenge (May 2023) and is great for practicing:
- Sales analysis
- KPI development
- Trend exploration
- Multi‑table joins
Hands‑on SQL work using PostgreSQL, including:
- Database creation
- Schema exploration
- Data cleaning
- Window functions
- CTE‑based analysis
- SQL Server Management Studio (SSMS)
- MySQL / MariaDB
- PostgreSQL (psql, pgAdmin, VS Code extension)
- DB Browser for SQLite
- VS Code
This repo is just a place for me to collect the databases I practice on and the SQL projects and challenges I’ve worked through. It reflects ongoing learning and hands‑on exploration across multiple SQL platforms.