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....

I have professionally worked with four different SQL database types PostgreSQL, MySQL & MariaDB...

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...

Every core SQL idea in the order they build on each other: tables and grain, the six clauses and the order they really run in,…