5 Data
Every entry filed under Data and its subtopics.
What kind of help
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.
8 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
- 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
- 0223 Oracle users, roles and tablespaces: setup script and usage report (SQL) A SQL*Plus/SQLcl script that creates a tablespace, a role and an application user inside a PDB, then reports tablespace usage from the… Intermediate · Step by step · Any system Script Administration · 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
- 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
- 0075 CSV to JSON converter (Python, standard library) Convert any CSV file with a header row into a JSON array or JSON Lines. Handles quoted fields, a byte order mark,… Beginner · Step by step · Any system Script CSV & JSON · 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
- 0009 CSV to JSON converter A small command-line tool that turns a CSV file into a JSON array of objects, with optional number detection, custom delimiters and… Beginner · Step by step · Any system Script CSV & JSON · Files & automation 15 Oct 2026