Database Tutorials and Administration Guides - Page 5

The Databases section is where you learn to install, query, and maintain the data stores behind modern applications.

Relational engines such as MySQL, MariaDB, and PostgreSQL still power most production workloads, while NoSQL options like MongoDB and Redis appear in caching and document-store roles. The guides here walk through both sides: writing correct SQL and keeping the server healthy after it is running.

What you will find here

Start with the SQL tutorial if you need the language fundamentals — SELECT, joins, aggregates, subqueries, and DML statements such as INSERT, UPDATE, and DELETE. From there, branch into focused walkthroughs on date formatting, transactions, and stored procedures.

Installation and day-two administration guides cover popular distributions on Linux. Look for PostgreSQL on RHEL and Rocky Linux and Debian, MongoDB on Rocky Linux and Ubuntu, and Redis on Ubuntu. These articles include service setup, basic hardening, and the commands you reach for during troubleshooting.

Who this section is for

Database administrators, backend developers, and DevOps engineers all land here for different reasons. You might be migrating a schema, tuning a slow query, or standing up a lab instance before wiring an application. The tutorials assume you can open a terminal on Linux and follow step-by-step output rather than copy-pasting blind.

If you are preparing for interviews, pair this hub with our DBMS interview questions and PostgreSQL interview questions collections.

Related topics on GoLinuxCloud

Databases rarely live in isolation. Application code in Programming connects through drivers and ORMs. Production hosts are provisioned and monitored through Linux and DevOps guides. When security matters — least-privilege users, TLS, or backup access — browse Security for complementary hardening material.

Browse the article list below for the full catalog of database tutorials on GoLinuxCloud.