Welcome to my SQL Projects Repository, a collection of real-world Data Analytics and Data Science projects using SQL. This repository showcases how SQL can be used to clean data, analyze datasets, generate insights, and solve business problems through structured queries.
Whether you're a recruiter, data enthusiast, or learner, this repository demonstrates my ability to work with relational databases and write efficient SQL queries.
This repository includes SQL projects focusing on:
- Removing duplicates
- Handling missing values
- Standardizing data
- Formatting & restructuring tables
- Summary statistics
- Trend analysis
- Category & segment-level insights
- Filtering, grouping, and aggregations
- Window functions for advanced analysis
- Sales & revenue analysis
- Customer segmentation
- Product performance
- Market trends
- Operational insights
- CTEs (Common Table Expressions)
- Window functions (ROW_NUMBER, RANK, LAG, LEAD)
- Subqueries & nested queries
- Joins (INNER, LEFT, RIGHT, FULL)
- Views & temporary tables
Each project folder will include:
📁 Project Name
├── dataset.sql / dataset.csv
├── queries.sql
├── project_notes.md (problem statements, explanation)
└── README.md (project documentation)
- SQL Query Writing
- Data Cleaning Using SQL
- Joins & Relationships
- CTEs & Window Functions
- Query Optimization
- Analytical SQL
- Problem Solving
- Business Insights Generation
- MySQL
- PostgreSQL
- SQL Server
- SQLite (Projects may vary based on datasets and requirements)
This repository serves as:
- A portfolio of my SQL-based analytics & data science projects
- A reference for solving real-world business problems using SQL
- A place where I will regularly upload new SQL projects
- A demonstration of my SQL competency for recruiters and collaborators
- Recruiters evaluating SQL expertise
- Data analytics learners
- Students practicing SQL queries
- Professionals improving SQL skills
- Anyone interested in real-world database analysis
Muhammed Thaha Uwais 📧 muhammedthahauwais@gmail.com 🔗 LinkedIn: https://www.linkedin.com/in/muhammed-thaha-uwais-5b5444279/
If you find this helpful, consider giving the repository a ⭐ Star — it motivates me to build and share more SQL projects!
Just tell me!