/case study

SQL Practice — Query Collection

A focused collection of SQL scripts built for hands-on practice with the query patterns that come up constantly in real data work — subqueries, conditional aggregation with HAVING, EXISTS operators, and correlated queries — organized around core relational database operations.

4SQL patterns: subqueries, HAVING, EXISTS, correlated queries

type
SQL · Data
year
2026
stack
SQL
SQL Practice — Query Collection: project preview

01

The problem

I wanted focused, hands-on practice with the SQL patterns that come up constantly in real data work — subqueries, conditional aggregation, and correlated queries — beyond what a single course project would cover.

02

What I did

I built and organized a collection of SQL scripts covering core relational database operations: subqueries, HAVING clauses, EXISTS operators, and correlated subqueries, applied across data manipulation and analysis tasks.

03

What I found

Working through these patterns repeatedly built real fluency with query structures I now reach for naturally when exploring a new dataset, rather than looking them up each time.