Projects
sql
SQL Business Queries Collection
50 SQL queries for business analytics
PostgreSQLSQLDatabase Design
The Story
50
Queries
13
Tables
Oman
Context
The Challenge
The Problem
SQL skills need practical demonstration with realistic business scenarios and properly structured database schemas.
The Solution
What I Built
Built a 13-table PostgreSQL schema with Oman-based sample data and 50 documented SQL queries covering common business analytics patterns.
My Role
Designed the database schema, created sample data, and wrote all SQL queries with documentation.
Technical
How It Works
1
Normalized relational database design
2
Aggregate functions and GROUP BY patterns
3
JOINs across multiple tables
4
Subqueries and CTEs for complex analysis
5
Window functions for rankings and running totals
Reflection
Key Takeaways
1
Good schema design simplifies queries
2
Real-world data context makes examples meaningful
3
Documentation improves query maintainability
Tools & Technologies
PostgreSQLSQLDatabase Design