This repository contains a collection of beginner‑level SQL projects completed through DataCamp’s Real‑World Projects. Each project demonstrates SQL fundamentals such as query logic, filtering, joins, and aggregation applied to diverse datasets.
| Project | SQL Concepts Practiced |
|---|---|
| Exploring Trends in American Baby Names | CASE WHEN, SUM(), COUNT(), GROUP BY, ORDER BY, LIMIT, RANK() OVER, self-JOIN |
| Analyzing Electric Vehicle Charging Habits | COUNT(DISTINCT), AVG(), COUNT(), GROUP BY, HAVING, WHERE, ORDER BY |
| When Was the Golden Era of Video Games? | INNER JOIN, USING, AVG(), ROUND(), COUNT(), GROUP BY, HAVING |
| Analyzing Industry Carbon Emissions | COUNT(DISTINCT), SUM(), ROUND(), GROUP BY, ORDER BY, WHERE |
| Analyze International Debt Statistics | COUNT(DISTINCT), SUM(), MIN(), GROUP BY, ORDER BY, WHERE |
| Analyzing Students' Mental Health | AVG(), ROUND(), COUNT(), WHERE, GROUP BY, ORDER BY |
- Applied SQL techniques across real‑world datasets in domains including health, finance, energy, and entertainment.
- Strengthened ability to translate ambiguous questions into structured queries.
- Built confidence in joins, filtering, and aggregation through varied scenarios.