September 2025 – Art of Coding

Join Data From Multiple Tables With Ease: Advanced SQL Joins Explained

Join Data From Multiple Tables With Ease: Advanced SQL Joins Explained Working with relational databases often means working with multiple related tables. Whether you're building reports for an e-commerce…

Oana Rinaldi September 30, 2025

Java

@Query Annotation Magic: Custom SQL in Spring Boot Repositories

@Query Annotation Magic: Custom SQL in Spring Boot Repositories Spring Data JPA’s power lies in its ability to abstract away complex data connectivity layers. But there comes a point…

Oana Rinaldi September 29, 2025

Python

Create a Personal Expense Tracker with SQLite and Python

Create a Personal Expense Tracker with SQLite and Python Managing personal finances doesn't need a fancy web application or integration with a bank API. Sometimes, a simple terminal-based utility…

Oana Rinaldi September 28, 2025

Python

Automate Invoice Generation with Python and Jinja2

Automate Invoice Generation with Python and Jinja2 Generating invoices manually can be time-consuming and error-prone—especially for freelancers or small businesses juggling multiple clients. With Python and Jinja2, you can…

Oana Rinaldi September 27, 2025

Python

“Set It and Forget It” Web Scraper in Python Using schedule + requests

"Set It and Forget It" Web Scraper in Python Using schedule + requests Web scraping has become an essential tool for automation, data monitoring, and real-time notification systems. Whether…

Oana Rinaldi September 26, 2025

Python

[Python] Turn Gmail into an Automated Alert System

[Python] Turn Gmail into an Automated Alert System In today's world of ever-growing email notifications, manually checking important emails can be inefficient. Imagine a script that scans your Gmail…

Oana Rinaldi September 25, 2025

Shell / Bash

Automate Daily Git Backups with Bash Scripts

Automate Daily Git Backups with Bash Scripts Keeping your source code safe and versioned is one of the core principles of modern software development. Git is already a powerful…

Oana Rinaldi September 24, 2025

Shell / Bash

Automate File Backup With a Bash Script and Cron Job

Automate File Backup With a Bash Script and Cron Job Backing up important data is essential for developers, system administrators, and anyone handling critical files. In this post, we'll…

Oana Rinaldi September 23, 2025

SQL

SQL Window Functions Demystified: Real Analytics Queries Explained

SQL Window Functions Demystified: Real Analytics Queries Explained SQL window functions are one of the most powerful — yet often misunderstood — features in modern SQL. These functions enable…

Oana Rinaldi September 22, 2025

Shell / Bash

Bash Scripting Challenge: Find the Top N Largest Files in a Directory Tree

Bash Scripting Challenge: Find the Top N Largest Files in a Directory Tree Managing disk space efficiently is a common concern for system administrators and developers alike. Files can…

Oana Rinaldi September 21, 2025