Let's Encrypt Cheatsheet
This guide helps you set up and manage Let’s Encrypt SSL certificates using Certbot.
1. Install Certbot
Ensure Certbot is installed. If not, install it with
sudo apt update
sudo apt install certbot
SQL Keywords & Usage Cheatsheet
1. Data Query Language (DQL)
| Keyword | Usage |
|---|---|
SELECT |
Retrieves data from a table. |
FROM |
Specifies the table to query. |
WHERE |
Filters records based on conditions. |
GROUP BY |
Groups rows that have the same values. |
HAVING |
Filters grouped data. |
ORDER BY |
Sorts the results in ascending (ASC) or descending (DESC) order. |
LIMIT |
Restricts the number of rows returned. |
OFFSET |
Skips a specific number of rows. |
DISTINCT |
Returns unique records. |
SQL Cheatsheet Data Analysts & Data Engineers
1. Basic SQL (Fundamentals for Everyone)
SELECT Statement (Retrieving Data)
SELECT column1, column2 FROM table_name;
SELECT * FROM customers;
WHERE Clause (Filtering Data)
SELECT * FROM sales WHERE region = 'North America';
SELECT * FROM employees WHERE salary > 50000;
NGINX Configuration Cheatsheet
1. Basic NGINX Setup
user www-data;
worker_processes auto;
pid /run/nginx.pid;
events {
worker_connections 1024;
}
http {
include mime.types;
default_type application/octet-stream;
sendfile on;
keepalive_timeout 65;
}
Linux Text Manipulation Cheat Sheet
Master text processing in Linux using essential commands like grep, sed, awk, cut, tr, and more.
1. grep - Search Text in Files
Find lines containing “error”
grep "error" logs.txt