This repository contains a collection of SQL queries I wrote while completing SQL courses.
15 DAYS OF SQL: THE COMPLETE SQL MASTERCLASS 2025 (PostgreSQL)
101 PRACTICE SQL QUESTIONS: BASIC TO ADVANCED (Microsoft SQL)
The queries cover a wide range of SQL concepts, including:
Basic Filtering – WHERE, BETWEEN, LIKE, logical operators
Grouping and Aggregation – GROUP BY, HAVING, aggregate functions
Joins – INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN
Subqueries – simple subqueries inside SELECT, FROM, or WHERE clauses
Correlated Subqueries – subqueries that reference columns from the outer query
Window Functions – RANK(), ROW_NUMBER(), OVER(), PARTITION BY
SQL Functions – text, date/time, numeric, and conditional functions
Database Manipulation – CREATE, INSERT, UPDATE, DELETE, DROP
These scripts are for learning and practice purposes and reflect my progress as I developed my SQL skills.