
Sql Union Syntax
Learn how SQL UNION works and how I use it to combine results from multiple SELECT statements into a single result set

Learn how SQL UNION works and how I use it to combine results from multiple SELECT statements into a single result set
In this video, I show how I use Playwright together with WebStorm to create and maintain end-to-end tests. It is so easy to setup and use. Try it out!
I show how to connect your contacts, email, and calendar to ChatGPT so you can work faster, stay organized, and reduce the time spent switching between apps
Sets are especially useful when uniqueness matters. I explain how sets automatically remove duplicates and make operations like membership testing, intersections, and differences very convenient. They are great for cleaning data, comparing collections, tracking seen values, and validating unique entries in applications.
I walk through what Flask is, why it is such a popular framework, and how to get everything set up so you can begin developing right away.
apply and unapply + pattern matching is the strong case for case classes. I created this article on my webpage https://codeinvestigator.com/articles/scala-is-more-fun-than-java
I dive into three core Python topics that show up constantly in real code: functions, dictionaries, and lambda expressions. If you want to write cleaner scripts, organize logic better, and handle data more efficiently, these concepts are essential. I walk through how functions help break problems into reusable pieces, how dictionaries make it easy to store and retrieve related data, and how lambdas can simplify short operations when a full function definition would be unnecessary.
I explain Xml Schema Definition, commonly called XSD, and how it is used to define, validate, and control the structure of XML documents. If you work with XML in data exchange, integrations, configuration files, enterprise systems, or service communication, understanding XSD is essential. I walk through the purpose of an XML schema, how it improves data quality, and why it matters when systems need to exchange information in a predictable and reliable way.
In this video, I walk through Java while and do while loops and show how they work in real code. If you want to understand how to repeat actions based on a condition, this lesson helps you see the difference between these two loop types, when each one should be used, and how they behave during execution.
If you have ever run into a NameError, accidentally overwritten a value, or wondered why a variable inside a function does not behave the same as one outside it, this lesson is designed to make that clear.
In this video, I compare Skills and AGENTS.md workflows in Claude Codex and Cursor, focusing on how each approach changes the way I structure context, delegate tasks, and keep AI-assisted coding predictable as projects grow.
Java is finally catching up with the missing ecosystem for ai. We have been behind our fellow python developers for years. The Spring AI module makes the gap smaller.
Visualize your git commits for a cool way to end each Scrum sprints
In this video, we dive into **Spring Boot AssertJ `anySatisfy()` and `allSatisfy()`** and show how these powerful assertion methods can make your tests more expressive, readable, and maintainable. If you are writing unit tests or integration tests in a Spring Boot application and want cleaner ways to validate collections, lists of DTOs, API responses, repository results, or service-layer outputs, this tutorial will help you understand when and how to use these AssertJ features effectively.
Convert Kotlin Object to Xml in the rest response with this approach! Yes you can have multiple converters per ktor backend.
I focus on a practical workflow where modern tooling helps me write code that is easier to understand, easier to maintain, and less likely to fail because of ambiguous null handling.
Learn to generate images from IntelliJ by using Spring Boot AI.
Don't repeat yourself! Automate boring tasks with rules and scripts instead of AI.
If you want your code to run smoother and perform better then use this trick!