SQL
-
Software Development
SQL Window Functions: The Decades-Old Feature Most Application Code Still Ignores
Standardized in 2003. Pioneered in 1998. Still missing from a huge share of the code that could use it. Ask…
Read More » -
Software Development
How to Use Subqueries in SQL
Subqueries are advanced features in SQL for solving problems that require more than a single level of filtering, comparison, or…
Read More » -
Core Java
Java SQL String Building Example
Building SQL queries dynamically is a common requirement in Java applications. Search screens, filtering APIs, reporting modules, and administrative dashboards…
Read More » -
Python
Python vs SQL for Data Transformation: When ETL Meets DataFrame Magic
In the data engineering world, two titans compete for dominance in data transformation: SQL, the venerable language that has powered…
Read More » -
Core Java
H2 Stored Procedures in Java
Stored procedures are a common way to encapsulate reusable logic within a database. While H2 is an in-memory Java SQL…
Read More » -
Core Java
Using UNION Logic in Hibernate Applications
Hibernate is a Java ORM tool that allows interaction with relational databases using entity objects. However, it lacks native support…
Read More » -
Python
Build Text-to-SQL using LLM
Text-to-SQL is a powerful application of large language models (LLMs) like GPT that enables users to interact with a database…
Read More » -
Core Java
Working with Sequences in H2 Database
When developing Java applications with databases, auto-generating primary keys is a common requirement. Sequences are a reliable way to generate…
Read More » -
Software Development
Introduction to Apache Kylin
In the era of big data analytics, fast query performance over massive datasets has become an essential requirement. Traditional relational…
Read More »
