A structured record of my progress learning SQL and PostgreSQL — from fundamentals to real problem-solving.
This repository documents my hands-on journey learning PostgreSQL and SQL through consistent practice. Each solution reflects my understanding of relational database concepts, query design, and problem-solving with real datasets.
I use this space to track growth over time, reinforce best practices, and build a portfolio of SQL work that demonstrates practical, production-relevant skills.
postgreSQL/
└── easy/ # LeetCode-style SQL problems organized by difficulty
Problems are organized by difficulty level. Each file contains a clean, well-reasoned solution to a real SQL problem.
- Writing clean, readable SQL queries
- Filtering and aggregating data with
WHERE,GROUP BY, andHAVING - Handling
NULLvalues correctly - Using subqueries and
JOINoperations - Applying conditional expressions with
CASE - Solving real-world data problems from structured datasets
- Database: PostgreSQL
- Interface: VS Code with SQLTools extension
- Problem source: LeetCode SQL problem set
- Complete all LeetCode Easy SQL problems
- Progress to Medium difficulty problems
- Cover window functions (
ROW_NUMBER,RANK,LAG,LEAD) - Practice with CTEs and recursive queries
- Document solutions with explanations
I'm actively building my SQL and data skills through daily practice. This repository is one part of a broader commitment to becoming proficient in data engineering and backend development.
Feel free to explore the solutions, suggest improvements, or connect with me.
Solutions are added regularly as I work through new problems.