Freaks City

User Account Management Creating New Users CentOS/RHEL Systems: USERNAME=admin adduser ${USERNAME} echo securePass123 | sudo passwd ${USERNAME} --stdin &>/dev/null usermod -aG wheel ${USERNAME} && usermod -aG docker ${USERNAME} Debian/Ubuntu Systems: USERNAME=admin useradd -d /home/${USERNAME} -s /bin/bash -m ${USERNAME} echo &q ...

Database Data Evolution The history of data storage methods can be illlustrated with a simple ATM example. # Phase 1: Storing data in individual files. # Files named inconsistently like 'kevin|123', 'kevin@123', 'kevin*123'. # This leads to file management issues. # Phase 2: Organizing data files into a dedicated 'db' folder. # As user registr ...

1. String Concatenation Operator SELECT 'Employee: ' || ename || ', Role: ' || job || ', Salary: ' || sal AS details FROM emp; 2. Convert Strings to Lowercase SELECT LOWER(ename) AS lowercase_name FROM emp; 3. Value Replacmeent SELECT DECODE(deptno, 10, 'Development', 20, 'Product', 30, 'Maintenance') AS department FROM emp; 4. Extract Curre ...

Setting up an Rsync daemon on a server enables efficient and secure file mirroring to remote clients. This guide walks through deploying a sync service on 192.168.18.211 to replicate /root/rsync-server/ to a client's /root/rsync-local directory, leveraging CentOS 6.5's built-in rsync capabilities. Verification and Installation Confirm rsync is ...