Thinking in terms of existence instead of lists
SQL Pattern Series #1 of 21
A collection of practical SQL patterns that help developers recognize common solutions to recurring database problems.
What You'll Learn
In this article you'll learn:
Thinking in terms of existence instead of lists SQL Pattern Series #1 of 21 A collection of...
Thinking in terms of existence instead of lists
SQL Pattern Series #1 of 21
A collection of practical SQL patterns that help developers recognize common solutions to recurring database problems.
What You'll Learn
In this article you'll learn:

Choosing between exact matches and pattern matches SQL Pattern Series #2 of 21 A collection of...

SQL is often treated as an implementation detail something to hide behind an ORM or repository layer....

Foreword In the Java backend world, ORM (JPA/Hibernate) and MyBatis have long been the...

Learning SQL can feel overwhelming at first, especially when you're staring at a blank query editor...

Twelve real SQL interview problems covering window functions, joins, deduplication, and gaps. Each includes a full answer and…

SQL for Developers: The Practical Guide (2026) You don't need to be a DBA to write good...