every note, in one binder ✎

Developer interview notes & guides — Page 31

Focused explanations and longer guides, with worked scenarios, common mistakes and interview exercises across every chapter.

read ✓Spring Boot · easy

Spring REST Validation at Request Boundaries

Validate Spring Boot request bodies and parameters with @Valid and Jakarta constraints, return clear 400 errors, and avoid silent gaps.

~6 min readread →
read ✓Spring Boot · hard

Spring Startup Checks and Readiness

How Spring Boot liveness and readiness probes work on Kubernetes, what belongs in each health group, and how to warm up and shut down gracefully.

~6 min readread →
read ✓Spring Boot · mid

Spring Transaction Duration and Remote Calls

Why long @Transactional methods exhaust the Hikari pool and hold locks, and how to keep remote calls, files and email outside the transaction.

~7 min readread →
read ✓Spring Boot · mid

Spring Transactions and Proxy Invocation

Why @Transactional is ignored on self-invocation and private methods in Spring Boot, how the proxy works, and four ways to fix it.

~7 min readread →
read ✓SQL & PostgreSQL · easy

SQL Aggregation and Result Grain

SQL Aggregation and Result Grain. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · hard

SQL Constraints as Concurrent Safety Nets

SQL Constraints as Concurrent Safety Nets. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · easy

SQL Count Star Versus Count Column

SQL Count Star Versus Count Column. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · mid

SQL Exists for Relationship Checks

SQL Exists for Relationship Checks. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · mid

PostgreSQL Explain Analyze and Real Execution

PostgreSQL Explain Analyze and Real Execution. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · easy

SQL Joins and Unexpected Row Multiplication

SQL Joins and Unexpected Row Multiplication. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · mid

SQL Keyset Pagination and Stable Ordering

SQL Keyset Pagination and Stable Ordering. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · easy

SQL Left Joins and Filter Placement

SQL Left Joins and Filter Placement. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · hard

PostgreSQL MVCC, Old Versions and Vacuum

PostgreSQL MVCC, Old Versions and Vacuum. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · easy

SQL Null and Three-Valued Logic

SQL Null and Three-Valued Logic. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · hard

SQL Parameterization and Injection Prevention

SQL Parameterization and Injection Prevention. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · mid

SQL Row Number, Rank and Dense Rank

SQL Row Number, Rank and Dense Rank. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
read ✓SQL & PostgreSQL · mid

PostgreSQL Row Locks and Concurrent Updates

PostgreSQL Row Locks and Concurrent Updates. Learn the reasoning, a practical example, common mistakes and an interview exercise.

~2 min readread →
esc