Christian Paez articles - 63 total
The Ultimate SQL JOIN Cheat Sheet
If you're working with relational databases, you'll often need to combine data from multiple tables....
HackerRank SQL Preparation: Weather Observation Station 3(MySQL)
Problem Statement: Query a list of CITY names from STATION for cities that have an even ID number....
HackerRank SQL Preparation: Weather Observation Station 1(MySQL)
Problem Statement: Query a list of CITY and STATE from the STATION table. Link: HackerRank - Weather...
HackerRank SQL Preparation: Japanese Cities' Names(MySQL)
Problem Statement: Query the names of all Japanese cities in the CITY table. The COUNTRYCODE for...
HackerRank SQL Preparation: Japanese Cities' Attributes(MySQL)
Problem Statement: Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for...
HackerRank SQL Preparation: Select by ID(MySQL)
Problem Statement: Query all columns for a city in the CITY table with the ID 1661. Link:...
HackerRank SQL Preparation: Select All(MySQL)
Problem Statement: Query all columns (attributes) for every row in the CITY table. Link:...
Automate binary execution at Startup with BASH
Automating the startup of frequently used binaries can save time and streamline your workflow. This...
Simplifying PATH Management with Bash
In the world of command-line, every keystroke counts. One essential aspect of this efficiency is...
Automating Video editing with programming knowledge
Many video editing tasks can be repetitive and time-consuming, especially when applied frequently...
HackerRank SQL preparation; Revising the Select Query II(MySQL)
Problem Statement: Query the NAME field for American cities in the CITY table with populations larger...
HackerRank SQL Preparation: Revising the Select Query I(MySQL)
Problem Statement: Query all columns for American cities in the CITY table with populations larger...
The Ultimate SQL SELECT Cheat Sheet
Have you ever found yourself staring blankly at your SQL code, trying to recall the syntax for a...
Bandit Level 23 Level 24
Introduction Welcome back, in this level we will learn some basics of privilege escalation...
Bandit Level 22 Level 23
Introduction In this level, we'll navigate through the uses of cron jobs and bash...
Bandit Level 21 Level 22
Introduction Welcome back, fearless hacker, to the Bandit challenges! In this level, we'll...
Bandit Level 20 Level 21
Introduction Welcome back tothe OverTheWire Bandit challenges. In this level, we encounter...
Bandit Level 19 Level 20
Introduction Greetings, Welcome back to the OverTheWire Bandit challenges. In this level,...
Bandit Level 18 Level 19
Introduction In this level, we'll learn about SSH connections, command execution, and file...
Bandit Level 17 Level 18
Introduction Greetings, Welcome back to the OverTheWire Bandit challenges. In this level,...
Bandit Level 16 Level 17
Introduction In this level of the OverTheWire Bandit challenges, we'll learn how to scan...
Unleashing Git Aliases: A Guide to Boosting Linux Productivity
Introduction The command line is a powerful interface, and for Linux enthusiasts,...
Bandit Level 15 Level 16
Introduction Welcome to another level of the OverTheWire Bandit challenges! In this level,...
Bandit Level 14 Level 15
Introduction Greetings, folks! We're back in the Bandit wargame, in this level where we'll...
Bandit Level 13 Level 14
Introduction Greetings, We're back with another step in the Bandit wargame journey. Level...
Bandit Level 12 Level 13
Introduction Greetings, As we step into Level 12 of the Bandit wargame, we're faced with a...
Bandit Level 11 Level 12
Introduction In Level 11 of the Bandit wargame, we're faced with a cryptographic challenge...
Unlocking Productivity and Linux Knowledge with Bash Aliases
In the world of command-line mastery, every keystroke counts. That's where Bash aliases come to the...
Bandit Level 10 Level 11
Introduction Bandit11 is the twelfth level of the OverTheWire Bandit wargame. In this...
Bandit Level 9 Level 10
Introduction Bandit10 is the eleventh level in the OverTheWire Bandit wargame. In this...