PostgreSQL Foundations on Windows

Distinguish tables, rows, columns, data types, and keys in a relational database using spreadsheet concepts as a reference.

Explain how a PostgreSQL client sends SQL requests to a database server and receives results.

Install PostgreSQL Server and pgAdmin on Windows with an explicitly chosen port, data directory, and administrator password.

Verify the PostgreSQL Windows service and locate the installed programs, data directory, and configuration files.

Navigate directories and run PostgreSQL-related programs from Windows PowerShell.

Connect to a PostgreSQL server with pgAdmin and verify the active server, database, user, and port.

Connect with psql and use essential meta-commands to inspect databases, schemas, tables, and connection details.

Create a training database and load a supplied SQL script into it with psql.