RDBMS fundamentals, MySQL and PostgreSQL administration, replication, and backup strategies.
? ACID Properties of Database Transactions
Start →
? MySQL vs PostgreSQL Feature Comparison
Start →
? Database Replication Types
Start →
? Write-Ahead Logging (WAL) in PostgreSQL
Start →
? Point-in-Time Recovery (PITR)
Start →
</> MySQL User Creation and Privilege Grant Script
Start →
</> MySQL Source-Replica Replication Configuration
Start →
</> PostgreSQL pg_hba.conf Configuration
Start →
</> PostgreSQL Streaming Replication Setup
Start →
</> Automated Database Backup Script
Start →
NFS, Samba file server and AD DC, FTP with vsftpd, and CUPS print server.
? NFS vs SMB Protocol Comparison
Start →
? FTP Active vs Passive Mode
Start →
? CUPS and Internet Printing Protocol
Start →
? CIFS Mount Options and Security
Start →
</> Configure a Samba File Share
Start →
</> Harden a vsftpd Configuration
Start →
</> Samba AD Domain Provisioning Script
Start →
</> CUPS Printer Setup Script
Start →
SMTP/IMAP/POP3 protocols, Postfix, Dovecot, Exim4, SPF/DKIM/DMARC, and mail stack integration.
? Mail TLS Ports and Protocols
Start →
? DKIM Signing and Verification
Start →
</> Configure Postfix main.cf
Start →
</> Dovecot IMAPS SSL Configuration
Start →
</> DNS SPF and DKIM TXT Records
Start →
</> SMTP Relay Connectivity Test Script
Start →
</> Exim4 Smarthost Relay Configuration
Start →
Nagios, Logwatch, Journald, Bacula, rsnapshot, DRBD replication, and Pacemaker clustering.
? Nagios Active vs Passive Checks
Start →
? Backup Rotation Strategies
Start →
? DRBD Split-Brain Resolution
Start →
? Pacemaker STONITH Fencing
Start →
</> Nagios Host and Service Configuration
Start →
</> rsnapshot Backup Configuration
Start →
</> Bacula Backup Job Configuration
Start →
</> DRBD Resource Configuration
Start →
</> Pacemaker HA Cluster Setup Script
Start →
OpenSSH, AppArmor, Kerberos, OpenLDAP, SSSD/AD integration, OpenVPN, and WireGuard.
? SSH Key Algorithm Comparison
Start →
? Kerberos Authentication Ticket Flow
Start →
? LDAP Directory Information Tree
Start →
</> Harden OpenSSH Server Configuration
Start →
</> AppArmor Profile for Web Application
Start →
</> Kerberos Client Configuration (krb5.conf)
Start →
</> OpenLDAP Organizational Structure (LDIF)
Start →
</> WireGuard VPN Peer-to-Site Tunnel
Start →
OSI model, TCP/IP stack, sockets, DNS, DHCP, firewall, and network troubleshooting.
? OSI Model Layer Identification
Start →
? TCP vs UDP Protocol Characteristics
Start →
? Subnet Calculation — Usable Hosts
Start →
? Firewall Rule Evaluation Order
Start →
</> IPv4 Address Validator Script
Start →
</> Netplan Static Network Configuration
Start →
</> BIND Forward DNS Zone File
Start →
</> UFW Firewall Rules Script
Start →
</> Tcpdump Traffic Analysis Script
Start →
QEMU/KVM, Libvirt, LXD system containers, Docker fundamentals, and cloud-init.
? Type 1 vs Type 2 Hypervisors
Start →
? KVM Hardware Requirements
Start →
? LXD System vs Docker Application Containers
Start →
? Docker Container Networking Modes
Start →
</> virsh VM Provisioning Script
Start →
</> LXD Profile for Web Server
Start →
</> Multi-stage Dockerfile for Go Application
Start →
</> docker-compose.yml for Web App Stack
Start →
</> cloud-init user-data Configuration
Start →
HTTP fundamentals, Apache2, Nginx, TLS certificates, PHP deployment, and proxy servers.
? HTTP Methods and Status Codes
Start →
? Apache vs Nginx Architecture
Start →
? TLS 1.3 Handshake Process
Start →
? HTTP Caching and Cache-Control
Start →
</> Apache Virtual Host Configuration
Start →
</> Nginx Reverse Proxy Configuration
Start →
</> Certbot Certificate Renewal Script
Start →
</> PHP-FPM Pool Configuration
Start →
</> Squid Proxy ACL Configuration
Start →