This repository showcases a comprehensive collection of SQL queries and exercises organized by topic. The goal is to demonstrate proficiency in core SQL concepts using real-world inspired data problems, with a focus on query structure, optimization, and analytical thinking.
The exercises are grouped into key SQL categories, each containing example queries designed to reinforce specific skills:
| Topic | Description |
|---|---|
📌 Basic-Selects |
Simple SELECT statements, filters, ordering |
📊 Aggregate-Functions |
COUNT, SUM, AVG, MIN, MAX with GROUP BY & HAVING |
🔄 Joins |
INNER, LEFT, RIGHT, FULL joins with table relationships |
🧮 Case |
Conditional logic using CASE expressions |
📐 Set-Operators |
UNION, INTERSECT, MINUS use cases |
🧩 Subqueries |
Nested SELECT statements and scalar queries |
🛠️ Creating-Tables |
SQL DDL examples to build schemas |
👓 Creating-Views |
Simplifying queries with views |
🔧 Oracle-SQL-Functions |
Oracle-specific string, date, and numeric functions |
Recruiters and hiring managers often ask:
“Can you write efficient SQL queries on real data?”
This portfolio answers that question with proof.
- Each folder contains clean
.sqlscripts and data output examples. - Queries mirror patterns found in business analytics, dashboards, and reporting use cases.
- Code is tested using Oracle SQL Developer with a school performance schema.
- Clone the repo:
git clone https://github.com/Dionte18Cape/SQL-Portfolio.git