Art Of Code - Art Of Code

sql, writeups, hackerrank

HackerRank SQL Preparation: Weather Observation Station 1(MySQL)

Query a list of CITY and STATE from the STATION table.

sql, writeups, hackerrank

HackerRank SQL Preparation: Japanese Cities' Names(MySQL)

Query the names of all Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

sql, writeups, hackerrank

HackerRank SQL Preparation: Japanese Cities' Attributes(MySQL)

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

sql, writeups, hackerrank

HackerRank SQL Preparation: Select by ID(MySQL)

Query all columns for a city in the CITY table with the ID 1661.

sql, writeups, hackerrank

HackerRank SQL Preparation: Select All(MySQL)

Query all columns (attributes) for every row in the CITY table.

blog, linux, scripting

Automate binary execution at Startup with BASH

Automating the startup of frequently used binaries can save time and streamline your workflow. This blog post introduces a simple Bash script that adds specified binaries to a function that executes them every time you start your computer.

blog, linux, path, scripting

Simplifying PATH Management with Bash

In this blog post, we create a simple script that streamlines the process of adding directories to your PATH, with instructions on how to use it with curl.

blog, automation, software, scripting

Automating Video editing with programming knowledge

Many video editing tasks can be repetitive when applied frequently across different videos. In this blog post, we'll explore how to enhance videos by adding opacity transitions using Python and OpenCV.

sql, hackerrank, writeups

HackerRank SQL preparation; Revising the Select Query II(MySQL)

Query the NAME field for American cities in the CITY table with populations larger than 120,000. The CountryCode for America is USA

writeups, sql, hackerrank

HackerRank SQL Preparation: Revising the Select Query I(MySQL)

Query all columns for American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.

sql, cheatsheet

The Ultimate SQL SELECT Cheat Sheet

SQL, with its vast array of commands and clauses, can be daunting to remember every detail. Here I will share a useful cheat sheet to write the most common SELECT queries.

ctf, overthewire, bandit, writeups

Bandit Level 23 → Level 24

Welcome back, in this level we will learn some basics of privilege escalation by abusing cron jobs.