Alexander Obregon's Substack

Home
Notes
Behind the Scenes
Java and JVM
Java LeetCode Solutions
SQL
Archive
About
Build a Search Feature with SQL LIKE and Wildcards
How Wildcards Shape Your Queries
 • 
Alexander Obregon
Turning Rows Into Columns To Build Pivot Tables In SQL
When you need to build a report from relational data, the default layout isn’t always what works best.
 • 
Alexander Obregon
Calculating Percent Change Between Rows in SQL
When working with time-based data or data sorted in a specific order, you often need to compare each value to the one before it.
 • 
Alexander Obregon
Breaking Big Queries into Manageable Parts with CTEs
Use CTEs to organize your SQL without nesting everything
 • 
Alexander Obregon
Kotlin Enum Classes and the Companion JVM Code
What the compiler adds to enum classes
 • 
Alexander Obregon
Weekly Recap – June 8th, 2025
Java, Spring Boot, JavaScript, Kotlin, and LeetCode
 • 
Alexander Obregon
LeetCode #11: Container With Most Water — Solved in Java
Brute Force and Two-Pointer Solution
 • 
Alexander Obregon
Alexander Obregon's Substack
Weekly recaps of what I’ve published, plus updates, extras, and some exclusive content you won’t find on my Medium.

Alexander Obregon's Substack

AboutArchiveSitemap
© 2025 Alexander Obregon
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture