Hands-On Tutorials

Write one short Bash script that counts error lines in each prepared log.

Restore one missing configuration file from a prepared compressed archive.

Build beginner Bash scripts with shebangs, variables, quoting, input, arguments, conditions, file tests, exit status, and for loops.

Diagnose one invalid configuration value and return its systemd service to the active state.

Inspect and stop one prepared process by using its recorded PID.

Learn to identify a Linux system, interpret load, inspect processes, find PIDs, send signals, control terminal jobs, use exit status, and run detached work.

Learn how systemd manages services, control and enable a safe practice service, inspect journal and text logs, and recover from a simple failure.

Follow a beginner network diagnostic path from hostname and interfaces through routes, connectivity, DNS, listening ports, HTTP, and safe UFW activation.

Learn SSH host verification, remote shells and commands, scp file and directory transfer, SSH key generation, and key-based authentication.

Use the supplied SSH identity to copy one configuration file to a remote account.

Change one local-only service to listen on all IPv4 interfaces while preserving its response.

Create manifest-based tar backups, inspect archives, restore one file, and schedule timestamped backups safely with Cron.

In this lab, you will learn how to work with MySQL views, which are virtual tables based on the result-set of an SQL statement. The lab covers creating, updating, querying, and dropping MySQL views. You'll create a database, populate it with data, and then create and manipulate a view.

In this lab, you will explore MySQL transactions and their importance in maintaining data integrity. You'll learn how to use transactions to ensure that a series of SQL operations are treated as a single unit of work. The lab covers BEGIN, COMMIT, ROLLBACK, and savepoints.

In this lab, you will learn how to automate tasks in MySQL using triggers. The lab focuses on creating a trigger that logs insert operations on a `products` table into a separate `product_logs` table. You will test, update, and drop the trigger.

In this lab, you will explore PostgreSQL's advanced data types, focusing on JSON/JSONB, arrays, and UUIDs. You'll learn how to store, query, and manipulate data within these types. The lab covers storing and querying JSON/JSONB, creating array columns, and using UUIDs as identifiers.

In this lab, you will learn how to work with temporary tables in MySQL, focusing on their creation and usage within a session. You'll create, insert data into, query, and drop a temporary table. You'll also verify its scope and understand its utility for session-specific data manipulation.

In this lab, you will enhance your PostgreSQL query writing skills by exploring advanced techniques. You'll learn subqueries, CTEs, window functions like ROW_NUMBER, and GROUP BY/HAVING clauses to extract meaningful insights from your datasets.