Skip to content

alhanoofalabdullah-ai/SQL-Projects

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

106 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQL Projects

A complete collection of SQL projects for data analysis, business intelligence, and real-world database systems.


Overview

This repository contains professional SQL projects covering multiple industries such as finance, healthcare, e-commerce, and operations.


Projects

Core SQL Projects

  • Project 01 – Employee Database
  • Project 02 – Sales Database
  • Project 03 – Banking System
  • Project 04 – E-Commerce Database
  • Project 05 – Inventory Database
  • Project 06 – Student Analytics
  • Project 07 – Hospital Database
  • Project 08 – Log Analysis
  • Project 09 – Reporting Engine
  • Project 10 – HR Analytics

Advanced SQL Projects

  • Project 11 – Customer Analytics Dashboard
  • Project 12 – Fraud Detection System
  • Project 13 – Recommendation Engine
  • Project 14 – Real-Time Sales Analysis
  • Project 15 – Inventory Optimization System
  • Project 16 – Employee Performance Analytics
  • Project 17 – Banking Risk Analysis
  • Project 18 – Healthcare Analytics System
  • Project 19 – Log Monitoring System
  • Project 20 – Business Intelligence Reports

Technologies Used

  • SQL
  • Relational Databases
  • Joins
  • Aggregations
  • Window Functions
  • Subqueries
  • Data Modeling

Skills Covered

  • Data analysis and reporting
  • Business intelligence (BI)
  • Query optimization
  • Data aggregation
  • KPI generation
  • Real-world scenario problem solving

Project Structure

Each project includes:

  • schema.sql → Database structure
  • data.sql → Sample data
  • queries.sql → SQL queries
  • README.md → Documentation

Goal

Build a strong SQL portfolio demonstrating expertise in data analysis, reporting, and database design.


Author

Alhanoof Alabdullah

About

Collection of SQL projects for data analysis, reporting, and database design (real-world scenarios)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors