A curated collection of SQL projects focusing on real-world data analysis, database design, and reporting use cases. This repository includes beginner to intermediate SQL applications covering business insights, data transformation, and querying skills using PostgreSQL/MySQL.
Each project is organized in a separate branch for modularity and clarity.
- Visit the main repo page on GitHub.
- Click the "Branch" dropdown at the top-left (above the file list).
- Select the branch corresponding to the project you're interested in.
| Branch Name | Description |
|---|---|
main |
Overview and instructions for the repo |
Netflix Movies and TV Shows Data Analysis using SQL |
Netflix Movies & TV Shows Data Analysis |
💡 Each branch contains its own
README.mdwith setup instructions, dataset source, schema info, and key query results.
- SQL Dialects: PostgreSQL, MySQL, SQLite
- Tools: pgAdmin, MySQL Workbench, DBeaver, DB Browser for SQLite
- Features:
- Data exploration & filtering
- Aggregations, joins, subqueries
- Window functions and CTEs
- Data classification & keyword analysis
- Query optimization and indexing
- Version Control: Git & GitHub
- ✅ Writing complex SQL queries
- ✅ Data cleaning and transformation using SQL
- ✅ Grouping, filtering, and sorting data for reports
- ✅ ER modeling and relational schema design
- ✅ Business intelligence queries
- ✅ Thematic content analysis using string matching and classification
- ✅ ETL pipelines with staging and final tables