Skip to content
Art of Coding

Art of Coding

  • Advanced
  • AI / Machine Learning
  • Algorithms
  • API Integration
  • Automation Scripts
  • Beginner
  • C#
  • C++
  • Data Structures
  • Databases
  • DevOps / CLI Tools
  • Dynamic Programming
  • Go
  • Graph Theory
  • HTML / CSS
  • Intermediate
  • Java
  • JavaScript
  • Python
  • Recursion
  • Rust
  • Search Algorithms
  • Shell / Bash
  • Sorting Algorithms
  • SQL
  • TypeScript
  • Uncategorized
  • Web Development

Month: January 2026

  • Home
  • 2026
  • January
Python Meets Excel: Automate Monthly Reports Without Opening Excel
Posted inPython

Python Meets Excel: Automate Monthly Reports Without Opening Excel

Python Meets Excel: Automate Monthly Reports Without Opening Excel   Manually updating Excel reports every month is tedious, error-prone, and unnecessary in 2024. With just a few lines of Python…
Posted by Oana Rinaldi January 31, 2026
Write a SQL Query That Builds a Running Total Without Window Functions
Posted inSQL

Write a SQL Query That Builds a Running Total Without Window Functions

Write a SQL Query That Builds a Running Total Without Window Functions   Window functions like SUM() OVER (ORDER BY ...) make calculating running totals in SQL straightforward and efficient.…
Posted by Oana Rinaldi January 30, 2026
Scrape and Schedule: Automate Web Reports Using Python & Cron
Posted inPython

Scrape and Schedule: Automate Web Reports Using Python & Cron

Scrape and Schedule: Automate Web Reports Using Python & Cron   Automatically receiving a daily report in your inbox with up-to-date financial data can save time, improve decision-making, and reduce…
Posted by Oana Rinaldi January 29, 2026
Detect Duplicate Files on Your System with a Python Hashing Script
Posted inPython

Detect Duplicate Files on Your System with a Python Hashing Script

Detect Duplicate Files on Your System with a Python Hashing Script   Duplicate files can quietly eat up precious disk space, especially on systems that see heavy data movement or…
Posted by Oana Rinaldi January 26, 2026
From CSV to Insight: Parse and Analyze CSV Files Using Modern Java Streams
Posted inJava

From CSV to Insight: Parse and Analyze CSV Files Using Modern Java Streams

From CSV to Insight: Parse and Analyze CSV Files Using Modern Java Streams   In today’s data-driven world, it’s common to work with large CSV files for everything from analytics…
Posted by Oana Rinaldi January 25, 2026
Visualizing SQL Query Performance with EXPLAIN Plans
Posted inSQL

Visualizing SQL Query Performance with EXPLAIN Plans

Visualizing SQL Query Performance with EXPLAIN Plans   Performance tuning is a critical aspect of working with relational databases. In PostgreSQL, understanding how a query gets executed is the first…
Posted by Oana Rinaldi January 24, 2026
Use Python’s Requests and BeautifulSoup to Scrape Product Prices
Posted inPython

Use Python’s Requests and BeautifulSoup to Scrape Product Prices

Use Python's Requests and BeautifulSoup to Scrape Product Prices   Web scraping allows developers to automate data collection from websites, making it a powerful tool for monitoring prices, extracting content,…
Posted by Oana Rinaldi January 23, 2026
Speed Up SQL Queries Using Indexes—With Before-and-After Benchmarks
Posted inSQL

Speed Up SQL Queries Using Indexes—With Before-and-After Benchmarks

Speed Up SQL Queries Using Indexes—With Before-and-After Benchmarks   SQL performance tuning is one of the most impactful ways to improve an application’s responsiveness. One of the most powerful tools…
Posted by Oana Rinaldi January 22, 2026
Building a Simple CAPTCHA System in JavaScript Without Dependencies
Posted inJavaScript

Building a Simple CAPTCHA System in JavaScript Without Dependencies

Building a Simple CAPTCHA System in JavaScript Without Dependencies   Spam and automated bots are common nuisances when building web forms. To prevent bot submissions, a well-known solution is the…
Posted by Oana Rinaldi January 21, 2026
Find Duplicates Fast — SQL vs Python Algorithm Showdown
Posted inDatabases

Find Duplicates Fast — SQL vs Python Algorithm Showdown

Find Duplicates Fast — SQL vs Python Algorithm Showdown   When you're working with massive datasets—think millions of rows—duplicate detection becomes more than just a simple query or a loop.…
Posted by Oana Rinaldi January 20, 2026

Posts pagination

1 2 Next page

Recent Posts

  • Building a Personal Finance Tracker with SQLite and Python
  • Image Resizing Automation with Python PIL
  • Flattening Nested JSON Objects in Python for Data Analysis
  • Scheduling Repetitive Tasks Using Cron and Bash
  • Automate Your File Organization with Python

Recent Comments

No comments to show.

Archives

  • March 2026
  • February 2026
  • January 2026
  • December 2025
  • November 2025
  • October 2025
  • September 2025
  • August 2025

Categories

  • Algorithms
  • Automation Scripts
  • Databases
  • DevOps / CLI Tools
  • Graph Theory
  • Java
  • JavaScript
  • Python
  • Recursion
  • Search Algorithms
  • Shell / Bash
  • Sorting Algorithms
  • SQL
Copyright 2026 — Art of Coding. All rights reserved. Bloghash WordPress Theme
Scroll to Top