Home
Projects
Author
Christian Páez
Twitter
Facebook
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.
Page 1 of 5
Next