Art of Coding – Art of Coding

SQL Window Functions Explained by Example

SQL Window Functions Explained by Example IntroductionSQL window functions are among the most powerful tools in modern SQL. They allow developers to perform calculations across sets of rows that…

Oana Rinaldi April 28, 2026

Java

Optimizing Java Loops: Small Changes That Make Big Differences

Optimizing Java Loops: Small Changes That Make Big Differences Introduction: Looping is at the heart of most Java applications, from simple data processing to high-performance systems. While Java provides…

Oana Rinaldi April 27, 2026

JavaScript

Consuming GraphQL APIs Smoothly with JavaScript Fetch

Consuming GraphQL APIs Smoothly with JavaScript Fetch GraphQL has revolutionized how modern applications fetch and manage data. Rather than dealing with multiple REST endpoints, a single GraphQL endpoint can…

Oana Rinaldi April 26, 2026

SQL

Optimizing SQL Queries: Index Use Cases You Can Actually See

Optimizing SQL Queries: Index Use Cases You Can Actually See IntroductionIndexes are among the most powerful tools for improving database performance. Yet, many developers don’t fully grasp how much…

Oana Rinaldi April 25, 2026

Shell / Bash

Batch Rename Utility in Bash Using Loops

Batch Rename Utility in Bash Using Loops IntroductionRenaming multiple files manually is tedious and error-prone — especially when dealing with large sets of images, logs, or exported data. Bash…

Oana Rinaldi April 24, 2026

Java

Sorting Beyond the Basics: Implementing Merge Sort in Java

Sorting Beyond the Basics: Implementing Merge Sort in Java Sorting Beyond the Basics: Implementing Merge Sort in JavaSorting algorithms form the foundation of efficient data processing in software development.…

Oana Rinaldi April 17, 2026

Python

Parallel Processing Made Easy with Python’s concurrent.futures

Parallel Processing Made Easy with Python’s concurrent.futures IntroductionPython developers often face a common problem when dealing with large datasets or computation-heavy workflows — sequential execution slows everything down. Whether…

Oana Rinaldi April 16, 2026

JavaScript

Streamlining JSON Data Transformation with JavaScript Maps

Streamlining JSON Data Transformation with JavaScript Maps IntroductionWhen working with modern REST or GraphQL APIs, developers often face deeply nested JSON responses that complicate data processing. Transforming these structures…

Oana Rinaldi April 15, 2026

JavaScript

Creating Mock APIs for Front-End Testing with JSON Server

Creating Mock APIs for Front-End Testing with JSON Server IntroductionWhen building modern front-end applications, developers often need to test their UI before the API is ready. This is where…

Oana Rinaldi April 14, 2026

SQL

SQL Tricks for Real-World Data Cleaning

SQL Tricks for Real-World Data Cleaning IntroductionIn the real world, data is rarely clean. Duplicate records, inconsistent formats, and missing values often plague raw datasets and threaten the reliability…

Oana Rinaldi April 13, 2026