5 Data
Every entry filed under Data and its subtopics.
What kind of help
Works on
What do these mean?
- Beginner
- You are new to this topic.
- Intermediate
- You use it, and want to get better.
- Advanced
- You know it well and need the details.
- Guided project
- Build something small from start to finish, step by step.
- Explains an idea
- Plain words on how something works and why.
- Step by step
- Numbered steps to get one task done.
- Cheat sheet
- Commands and options in a table, to look up fast.
- Fixes an error
- An error message, what it means, and how to solve it.
15 entries match these filters
- 0393 Install PostgreSQL on Linux, macOS and Windows Install the PostgreSQL server and the psql client on each desktop OS, start the service, connect as the postgres superuser and create… Beginner · Step by step · Linux, macOS, Windows Article Install & connect · Installing languages & tools 15 Oct 2026
- 0364 Schedule PostgreSQL and MySQL dumps with systemd timers Write one dump script for PostgreSQL and MySQL, run it from a systemd service and timer instead of cron, keep two weeks… Intermediate · Step by step · Linux Article Backup tools · PostgreSQL 15 Oct 2026
- 0331 docker compose for an app with a PostgreSQL database A compose.yaml that runs your application next to a PostgreSQL container, with a named volume for the data, a health check so… Intermediate · Step by step · Linux, macOS, Windows Article Docker Compose · Install & connect 15 Oct 2026
- 0233 Turn on MongoDB authentication and create least-privilege users A fresh MongoDB install accepts connections without a password. Create a user administrator, enable authorization, then give each application and backup job… Intermediate · Step by step · Linux Article Administration · Security & access 15 Oct 2026
- 0242 Database security checklist: access, encryption, exposure and patching A practical checklist for hardening any database server, with MongoDB and Redis examples: no public exposure, authentication, least privilege, TLS, protected backups,… Advanced · Step by step · Linux Article Database operations · Security & access 15 Oct 2026
- 0243 Database backup strategy: the 3-2-1 rule and testing restores Keep three copies of your data on two kinds of storage with one copy offsite, choose dump or snapshot methods per database,… Intermediate · Step by step · Linux Article Database operations · Security & access 15 Oct 2026
- 0225 Oracle Data Pump: export and import schemas with expdp and impdp Data Pump moves schemas, tables or whole databases between Oracle databases as dump files. Set up a directory object, export with expdp… Intermediate · Step by step · Linux, Windows Article Administration · Backup with RMAN 15 Oct 2026
- 0202 Back up and restore PostgreSQL with pg_dump, pg_restore and pg_dumpall Make logical backups of one database with pg_dump, of roles and the whole cluster with pg_dumpall, and restore them with pg_restore or… Beginner · Step by step · Linux Article Backup & restore 15 Oct 2026
- 0205 Set up PostgreSQL streaming replication with a hot standby Step-by-step: prepare a primary, clone it with pg_basebackup, start a read-only standby that streams WAL, check it works, and understand promotion and… Advanced · Step by step · Linux Article Replication & high availability 15 Oct 2026
- 0214 MySQL users and privileges: CREATE USER, GRANT and authentication plugins A MySQL account is a user name plus the host it connects from. You create it with CREATE USER, give it rights… Beginner · Step by step · Linux Article Administration · Security & access 15 Oct 2026
- 0218 Setting up MySQL source-replica replication with GTIDs Step by step: configure a MySQL 8.4 source and replica with GTIDs, create the replication account, copy the data, connect the replica… Advanced · Step by step · Linux Article Administration · Replication 15 Oct 2026
- 0198 Install PostgreSQL and connect with psql on Debian, Ubuntu and RHEL Install the PostgreSQL server from your distribution or the official PGDG repositories, start it, and open your first psql session as the… Beginner · Step by step · Linux Article Install & connect 15 Oct 2026
- 0200 PostgreSQL roles, privileges and default privileges Create login and group roles, grant access to databases, schemas and tables, and use ALTER DEFAULT PRIVILEGES so tables created later get… Intermediate · Step by step · Linux Article Roles & administration · Security & access 15 Oct 2026
- 0074 pandas basics: read a CSV, filter rows and summarize with groupby Load a CSV into a pandas DataFrame, inspect it, filter rows with conditions, and compute totals per group, with the SQL equivalent… Intermediate · Step by step · Any system Article Data analysis · Files & automation 15 Oct 2026
- 0067 Your first SQL queries: SELECT, WHERE, ORDER BY, LIMIT and GROUP BY Read data from a table, keep only the rows you want, sort them, take the first few, and summarize groups with COUNT,… Beginner · Step by step · Any system Article Queries 15 Oct 2026